Skip to content

Online Webinar: xlwings File Reader

Photo of Felix Zumstein
Hosted By
Felix Z.
Online Webinar: xlwings File Reader

Details

Note that this is an online webinar!

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.

Photo of xlwings Meetup London group
xlwings Meetup London
See more events