Py-pyxlsb2

Jul 20, 2023

Excel 2007+ Binary Workbook (xlsb) parser

pyxlsb2 a variant of pyxlsb is an Excel 2007+ Binary Workbook xlsb parser written in Python.

pyxslb2 offers the following improvements/changes in comparison to pyxlsb

  • 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 file system during the processing.
  • relies on both “xl\workbook.bin” and “xl_rels\workbook.bin.rels” to load locate boundsheets. As a result, it can load all worksheets as well as all macrosheets.
  • extracts macro formulas
    • accurately shows the formulas
    • supports A1 addressing
    • supports external addressing partially implemented
  • extracts defined names such as auto_open


Checkout these related ports:
  • Zxing-cpp - ZXing C++ Library for QR code recognition
  • Zu-hunspell - Zulu hunspell dictionaries
  • Zu-aspell - Aspell Zulu dictionary
  • Zq - Easier and faster alternative to jq
  • Zorba - General purpose C++ XQuery processor
  • Zenxml - Simple C++ XML Processing
  • Zed - Command-line tool to manage and query Zed data lakes
  • Yq - Command-line YAML and XML processor, jq wrapper for YAML/XML documents
  • Yould - Pronounceable word generator
  • Yodl - Easy to use but powerful document formatting/preparation language
  • Yi-hunspell - Yiddish hunspell dictionaries
  • Yi-aspell - Aspell Yiddish dictionary
  • Yelp-xsl - DocBook XSLT stylesheets for yelp
  • Yelp-tools - Utilities to help manage documentation for Yelp and the web
  • Ydiff - Diff readability enhancer for color terminals