The app for independent voices
Python and Excel:
A potent combination for working with data.
Here are the 17 Python libraries to help you unlock the power.
XlsxWriter
XlsxWriter is a Python module for writing files in the Excel 2007+ XLSX file format.
xlwings
xlwings is a BSD-licensed Python library that makes it easy to call Python from Excel and vice versa.
pyexcel
pyexcel provides one application programming interface to read, manipulate and write data in various excel formats.
pandas
pandas has rich tools for reading and writing Excel and CSV files.
xlwt
This is a library for developers to use to generate spreadsheet files compatible with Microsoft Excel versions 95 to 2003.
pycel
Pycel is a small python library that can translate an Excel spreadsheet into executable python code which can be run independently of Excel.
PyExcelerate
PyExcelerate is a Python library for writing Excel-compatible XLSX spreadsheet files, with an emphasis on speed.
xlutils
This package provides a collection of utilities for working with Excel files.
formulas
formulas implements an interpreter for Excel formulas, which parses and compile Excel formulas expressions.
pylightxl
A light weight, zero dependency (only standard libs used), to the point (no bells and whistles) Microsoft Excel reader/writer python 2.7-3+ library.
nb2xls
Convert Jupyter notebooks to Excel Spreadsheets (xlsx), through a new ‘Download As’ option or via nbconvert on the command line.
openpyxl
openpyxl is a Python library to read/write Excel 2010 xlsx/xlsm/xltx/xltm files.
Koala
Koala converts any Excel workbook into a python object that enables on the fly calculation without the need of Excel.
XlsxPandasFormatter
Provides a helper class that wraps the worksheet, workbook and dataframe objects written by pandas toexcel method using the xlsxwriter engine to allow consistent formatting of cells.
xls2slsx
Convert .xls files to .xlsx using xlrd and openpyxl.
vb2py
vb2py is a toolkit to aid in the conversion of Visual Basic projects to Python.
xltable
xltable is an API for writing tabular data and charts to Excel.
Hopefully you never need to convert VBA to Python.
But if you do, I have you covered:
xlwt
pycel
xlutils
Koala
vb2py
nb2xls
xltable
xls2slsx
xlwings
pyexcel
pandas
pylightxl
formulas
openpyxl
XlsxWriter
PyExcelerate
XlsxPandasFormatter