pylightxl pypi | github

Welcome to pylightxl documentation

A light weight Microsoft Excel File reader. Although there are several excellent read/write options out there (python-excel.org or excelpython.org) pylightxl focused on the following key features:

• Zero non-standard library dependencies
  No compatibility/version control issues.
• Light-weight single source code file that supports both Python3 and Python2.7.18.
  Single source files that can easily be copied directly into a project for true zero-dependency.
  Great for those that have installation/download restrictions.
  In addition the library’s size and zero dependency makes this library pyinstaller compilation small and easy!
• 100% test-driven development for highest reliability/maintainability with 100% coverage on all supported versions
• API aimed to be user friendly and intuitive. Structure: database > worksheet > indexing example: db.ws('Sheet1').index(row=1,col=2) or db.ws('Sheet1').address(address='B1')

High-Level Feature Summary

• Read excel files (.xlsx, .xlsm), all sheets or selective few for speed/memory management
• Index cell data by row/col number or address
• Calling an entire row/col of data returns an easy to use list output: db.ws('Sheet1').row(1) or db.ws('Sheet1').rows
• Worksheet data size is consistent for each row/col. Any data that is empty will return a ‘’ (default empty cell can be updated)
• Write to existing or now spreadsheets

Limitations

Although every effort was made to support a variety of users, the following limitations should be read carefully:

• Does not support .xls files (Microsoft Excel 2003 and older files)
• Writer does not support anything other than cell data (no graphs, images, macros, formatting)
• Does not support worksheet cell data more than 536,870,912 cells (32-bit list limitation)

• 1. Installation
  • 1.1. pip install
  • 1.2. Git Clone
  • 1.3. Download Source Files
  • 1.4. Copy Source Files
• 2. Quick Start Guide
  • 2.1. Read/Write CSV File
  • 2.2. Read Excel File
  • 2.3. Access Worksheet and Cell Data
  • 2.4. Read Semi-Structured Data
  • 2.5. Write out a pylightxl.Database as an excel file
  • 2.6. Write a new excel file from python data
• 3. Source Code Documentation
  • 3.1. readxl
  • 3.2. writexl
  • 3.3. database
• 4. Example Solutions
  • 4.1. Reading Semi Structured data
• 5. Revision Log
  • 5.1. pypi version 1.52 (in-work)
  • 5.2. pypi version 1.51
  • 5.3. pypi version 1.50
  • 5.4. pypi version 1.49
  • 5.5. pypi version 1.48
  • 5.6. pypi version 1.47
  • 5.7. pypi version 1.46
  • 5.8. pypi version 1.45
  • 5.9. pypi version 1.44
  • 5.10. pypi version 1.43
  • 5.11. pypi version 1.42
  • 5.12. pypi version 1.41
  • 5.13. pypi version 1.3
  • 5.14. pypi version 1.2
  • 5.15. pypi version 1.1
• 6. License

Support Content Creator

If you enjoyed this library, please consider supporting its creators! Help Today