Python API for Excel XLSX Spreadsheets
Create, Edit & Convert Excel OOXML File Format via open-source Python library.
PyExcelerate enables software programmers to read and write Excel XLSX spreadsheet files. It is also known as an accelerated Excel XLSX writing library for Python because it is by far the fastest option for Python spreadsheet solutions. It creates the 10,000 rows and 10 columns in just 0.17 seconds.
PyExcelerate supports writing bulk data, writing cell data, selecting cells by name, merging cells, styling cells, styling ranges, styling rows, styling columns, setting row heights and column widths and more.
At A Glance
An overview of PyExcelerate features.
- Create spreadsheets
- Read spreadsheets
- writing bulk data
- Writing cell data
- Selecting cells
- Merging cells
- Styling cells
- Styling ranges
- Styling rows
- Read larger files
- Less Memory usage
- Add table
- Insert comments
- Merge cells
- Hyperlinks support
PyExcelerate supports OOXML spreadsheet format as well as it can export data to common file formats.
PyExcelerate requires Python 2.6, 2.7, 3.3, 3,4 or 3.5.
Getting Started with PyExcelerate
First of all, you need to have Python 2.6 or higher installed on your system. After meeting the prerequisites, please use the following command.
pip install pyexcelerate
Python API to Generate & Modify Spreadsheet
PyExcelerate API enables software developers to generate an Excel-compatible XLSX spreadsheet from their own Python applications. Developers can also modify an existing sheet; write data to cell, select cells by name, merging cells, styling rows or cells and much more.
Writing Bulk Data to a Range
PyExcelerate API gives the developer the capability to write bulk data to an Excel range of cells. It is an important feature for adding a huge amount of data in less time. The API also gives developers the power to directly write data to ranges, which is quicker than writing cell-by-cell.
Styling Cells in Excel Spreadsheet
PyExcelerate API allows styling with custom colors, font, fill & more. Sometimes styling cells cause non-negligible overhead because it may increase the execution time.