/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

36 votes128 views6 answers
Arrays in python
Python
0 vote130 views1 answer
Python txt to parquet
Python
-1 vote141 views1 answer
How to make a bitcoin miner in pythonn
Python
21 votes93 views1 answer
Raise en python
Python
0 vote138 views1 answer
Colab read xlsx
Python
6 votes137 views2 answers
Python - count total numeber of row in a dataframe
Python
0 vote170 views1 answer
Python tkinter entry hide text
Python
0 vote127 views1 answer
Highlight max value in table pandas dataframe
Python
0 vote130 views1 answer
Separating a relational plot based on a sixth variable | seaborn relational plot
Python
0 vote132 views1 answer
Python export 16 bit tiff
Python