/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

18 votes313 views5 answers
Pandas replace na with 0
Python
5 votes337 views4 answers
Discord.py find channel by id
Python
1 vote350 views1 answer
Print value of tensor
Python
0 vote271 views1 answer
How to subtract up everything in a list python
Python
0 vote301 views1 answer
Smallest program to make diamond python
Python
0 vote300 views1 answer
How to get the date from week number in Python?
Python
1 vote288 views1 answer
How to move a column to the beginning in dataframe
Python
4 votes308 views2 answers
How to plot two columns graphs in python
Python
0 vote279 views1 answer
Cbind arrays python
Python
0 vote299 views1 answer
Python index of dictionary in list
Python