/Python/Ignore nil rows value in openpyxl

Ignore nil rows value in openpyxl

for row in ws.iter_rows(min_col=adres[0], min_row=adres[1], max_col=adres[2], max_row=adres[3]):
    if row[0].value is not None:
        data_rows.append([cell.value for cell in row])
    else: continue

Source: stackoverflow.com

Similar codes

0 vote167 views1 answer
Read JSON files with automatic schema inference
Python
4 votes159 views3 answers
How to input n space separated integers in python
Python
0 vote219 views1 answer
Tiktok python bot
Python
6 votes196 views3 answers
Sort a dictionary by value then key
Python
1 vote193 views2 answers
Sort a list of array python
Python
2 votes224 views3 answers
Convert csv to dictionary in Python
Python
11 votes194 views3 answers
Username Python
Python
1 vote153 views1 answer
Pandas merge dataframes from a list
Python
1 vote167 views1 answer
GdScript onready
Python
0 vote166 views2 answers
ArgumentParser(parent)
Python