willtrnr / pyxlsb

Excel 2007+ Binary Workbook (xlsb) reader for Python
GNU Lesser General Public License v3.0
90 stars 21 forks source link

Distinguish between worksheets and chart sheets #33

Open ahawryluk opened 3 years ago

ahawryluk commented 3 years ago

It would be useful to have a way of checking which sheets are worksheets and which are chart sheets. Currently (1.0.8), both kinds of sheets appear in sheet_names and the only way to identify a chart sheet is by trying to get_sheet, which raises an "error: unpack requires a buffer of 1 bytes." I tried to check the XLSB standard to see how difficult this would be, but I confess that I quit when I saw there were 1110 pages.

Thanks for providing this module!