Python API for Excel XLSX Spreadsheets
Generate, Modify,Manipulate and Read Microsoft Excel XLSX and XLSM File Format via open-source Python library.
pylightxl is an open source light weight Python library that gives software developers the capability to work with Microsoft Excel Files inside their own application with zero dependencies. The library has provided support for reading and writing Excel spreadsheets using Python commands.
The library has included Reading supports XLSX and XLSM spreadsheet file formats and writing support for XLSX file formats. The library is very easy to use and install as there is only a single source file that can need to be copied directly into a project. The library has included support for several important features, such as reading excel files, read all or selected sheets, better memory management and speed, reading a particular row or column, update row data, add or remove columns from a sheet, and many more.
At A Glance
An overview of pylightxl 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
pylightxl supports OOXML spreadsheet format as well as it can export data to common file formats.
pylightxl requires Python3 and Python2.7.18.
Getting Started with pylightxl
The library can smoothly run on both Python3 and Python2.7.18. The recommended way to install is via pip: Please use the following command.
Install pylightxl via PIP Command
pip install pylightx
Access and Read Excel Spreadsheet via Python
The pylightxl library gives software programmers the capability to read Excel files inside their own applications without any external dependencies. The library allows software developers to read XLSX and XLSM files with just a couple of lines of Java code. The library also provides support for reading only selected worksheet. It also supports accessing and reading a specific column or row from a given excel file.
Create an Excel XLSX File via Python
The open source pylightxl library has provided the capability for creating Excel XLSX files with just a couple of lines of Python code inside their own applications without installing Microsoft Excel file. The library only supports cell data writing and at the moment does not support graphs, formatting, images, macros, etc. It allows users to write a new excel file from python data and supports features like adding an empty worksheet, adding rows, columns, and many more.
Reading Semi-Structured data
The open source pylightxl library has included the capability for reading semi-structured data inside their own Python applications. Sometimes it’s required to read data from a sheet that can begin at any row or column and has any number of rows or columns per data group. The library searches out and finds the columnIDs where data groups start and read out multiple tables the same way as you would read a book.