| Description: | pyxlsb2 (a variant of pyxlsb - is an Excel 2007+ Binary Workbook (xlsb) parser
written in Python. The pyxslb2 offers the following improvements/changes in
comparison to pyxlsb:
1. By default, keeps all data in memory instead of
creating temporary files. This is mainly to speed up the processing and also
not changing the local filesystem during the processing.
2. relies on both "xl\workbook.bin" and "xl_relsworkbook.bin.rels" to load
locate boundsheets. As a result, it can load all worksheets as well as all
macrosheets.
3. it extracts macro formulas:
- accurately shows the formulas
- supports A1 addressing
- supports external addressing (partially implemented))
4. extracts defined names such as auto_open |
|---|