/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 vote260 views1 answer
Gunicorn django static files
Python
1 vote268 views1 answer
Swap rows and columns pandas
Python
0 vote242 views1 answer
Save this RDD as a SequenceFile of serialized objects
Python
1 vote244 views1 answer
Create iterator object python
Python
-1 vote243 views2 answers
Hierarchical clustering Agglomerative
Python
0 vote258 views1 answer
How to make a series in python alternating between + and -
Python
2 votes248 views1 answer
Get local ipv4
Python
7 votes249 views1 answer
Python get list of files in path
Python
20 votes211 views3 answers
Python reload module
Python
9 votes262 views6 answers
Sorted key python
Python