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 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 supports 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.

Previous Next

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

 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.