Openpyxl is a Python library for reading and writing Excel 2010 xlsx/xlsm/xltx/xltm files.
Openpyxl is a Python library to read/write Excel 2010 xlsx, xlsm, xltx, and xltm files.
It was born from lack of an existing library to read/write natively from Python the Office Open XML format.
All kudos to the PHPExcel team as openpyxl was initially based on PHPExcel.
Features:
- Tables
- Data validation
- Charts
About security:
By default Openpyxl does not guard against quadratic blowup or billion laughs XML attacks. To guard against these attacks, install defusedxml.
Project documentation can be found at openpyxl - A Python library to read/write Excel 2010 xlsx/xlsm files.
