Alternative modules for handling Excel files#

The following are some Python alternatives to XlsxWriter.

OpenPyXL#

From the openpyxl documentation:

openpyxl is a Python library to read/write Excel 2010 xlsx/xlsm/xltx/xltm files.

Xlwings#

From the xlwings webpage:

Leverage Python’s scientific stack for interactive data analysis using Jupyter Notebooks, NumPy, Pandas, scikit-learn etc. As such, xlwings is a free alternative to tools like Power BI or Tableau (Windows & Mac).

XLWT#

From the xlwt documentation:

xlwt is a library for writing data and formatting information to older Excel files (ie: .xls)

XLRD#

From the xlrd documentation:

xlrd is a library for reading data and formatting information from Excel files, whether they are .xls or .xlsx files.