Get empty cell coordinates with openpyxl

Question

I work at a script to extract some very messy data from a huge excel file and I run into a bump. There is any way to get coordinates from an empty cell with openpyxl?

This will return an error saying EmptyCell has no row/column attribute

for row in sheet.iter_rows():
    for cell in row:
        if cell.column is ... :
           print(cell.value)

I cannot skip the empty cells, as there are empty cells in some columns that have to taken into account and extracted as such in the new file. Also, I cannot fill the empty cells because the original file is huge and its opened read only because of this.

There is any way to do this with openpyxl or I should try to use another library?

Already answered here: http://stackoverflow.com/questions/7907928/openpyxl-check-for-empty-cell — Gourav Chawla, Sep 20 '16 at 14:21
I found that topic and is about finding empty cells... That is not helpfull because I needed the coordinates of the empty cell — Dorin.D, Sep 21 '16 at 09:57

score 3 · Accepted Answer · answered Sep 21 '16 at 08:00

3

EmptyCell's are special cells in the read-only context: they are fillers created where there are no cells in the original XML so that rows from a range are of equal length. As such they do not really exist and hence do not have coordinates. If you need their coordinates then you can simply use enumerate to count for you while looping.

answered Sep 21 '16 at 08:00

Charlie Clark

18,477
4
49
55

Thanks Charlie, that will do :) – Dorin.D Sep 21 '16 at 09:58

score 1 · Answer 2 · answered Jul 29 '19 at 02:41

1

for row in sheet.iter_rows():  
       for cell in row:  
        if cell.value is None :  
           print(str(cell.column)+str(cell.row))

answered Jul 29 '19 at 02:41

ashim

67
1
2
12

Get empty cell coordinates with openpyxl

2 Answers2