Agenda
xlwings File Reader is a brand new xlwings PRO functionality introduced with xlwings 0.28.0. It can read xlsx/xlsm, xlsb, and xls files without the need to have Excel installed and therefore works everywhere where Python works, including Linux!
xlwings File Reader is an alternative to pandas.read_excel(), OpenPyXL, pyxlsb, and xlrd. The advantages include:
* Speed: Reading a typical xlsx sheet is 5-10x faster, reading a typical xlsb sheet is around 30x faster
* Single package to rule them all: Use the same syntax across xlsx, xlsb, and xls as well as across automating Excel and reading Excel files
* Full Excel object model: Work with objects that aren't supported by pandas such as named ranges and cell errors
* Not everything is a DataFrame: You can easily read data as lists, dicts, or scalar values from single cells.
* Powerful and clean API: Supports the full xlwings syntax with convenience functions such as reading in dynamic ranges
While xlwings File Reader is part of the PRO offering, it is free for non-commercial use.
xlwings File Reader is an alternative to pandas.read_excel(), OpenPyXL, pyxlsb, and xlrd. The advantages include:
* Speed: Reading a typical xlsx sheet is 5-10x faster, reading a typical xlsb sheet is around 30x faster
* Single package to rule them all: Use the same syntax across xlsx, xlsb, and xls as well as across automating Excel and reading Excel files
* Full Excel object model: Work with objects that aren't supported by pandas such as named ranges and cell errors
* Not everything is a DataFrame: You can easily read data as lists, dicts, or scalar values from single cells.
* Powerful and clean API: Supports the full xlwings syntax with convenience functions such as reading in dynamic ranges
While xlwings File Reader is part of the PRO offering, it is free for non-commercial use.
