Unable to read xlsx file created by Apache POI
Hi,
I got error "openpyxl\styles\stylesheet.py:214: UserWarning: Workbook contains no default style, apply openpyxl's default" when I try to read an excel file using openpyxl (3.0.5). I figure out that this file is created by Apache POI (don't know de version). This causes a strange behavior since it's possible to target a specific cell and read the value, however it's not possible to iterate avec the rows. Pandas cannot load the DataFrame from the xlsx file since the iteration stop at the first cell.
Example file: https://dashboard.nexmo.com/download_pricing
I see on issue #1171 (closed) that Apache POI is use to create invalid file but I would like to confirm this is not a bug.
Thanks