All Projects → PydPiper → Pylightxl

PydPiper / Pylightxl

Licence: mit
A light weight, zero dependency, minimal functionality excel read/writer python library

Programming Languages

python
139335 projects - #7 most used programming language
python3
1442 projects
python2
120 projects

Projects that are alternatives of or similar to Pylightxl

Excelize
Golang library for reading and writing Microsoft Excel™ (XLSX) files.
Stars: ✭ 10,286 (+7576.12%)
Mutual labels:  excel, microsoft, office
Xlnt
📊 Cross-platform user-friendly xlsx library for C++11+
Stars: ✭ 876 (+553.73%)
Mutual labels:  api, excel, microsoft
Kms Activator
Windows activation research project.
Stars: ✭ 1,001 (+647.01%)
Mutual labels:  microsoft, office
Desktopeditors
An office suite that combines text, spreadsheet and presentation editors allowing to create, view and edit local documents
Stars: ✭ 1,008 (+652.24%)
Mutual labels:  excel, office
Xlsx
Fast and reliable way to work with Microsoft Excel™ [xlsx] files in Golang
Stars: ✭ 132 (-1.49%)
Mutual labels:  excel, microsoft
Gotenberg Go Client
Go client for the Gotenberg API
Stars: ✭ 35 (-73.88%)
Mutual labels:  api, excel
Excel Io
A utility library that makes it easy to read and write Excel workbooks using C#
Stars: ✭ 35 (-73.88%)
Mutual labels:  excel, office
Tablereport
A python library for making table report.
Stars: ✭ 51 (-61.94%)
Mutual labels:  excel, office
Pytradfri
IKEA Trådfri/Tradfri API. Control and observe your lights from Python. Examples available. On pypi. Sans-io.
Stars: ✭ 778 (+480.6%)
Mutual labels:  api, pypi
Pypistats
Command-line interface to PyPI Stats API to get download stats for Python packages
Stars: ✭ 86 (-35.82%)
Mutual labels:  api, pypi
Gotenberg Php Client
PHP client for the Gotenberg API
Stars: ✭ 80 (-40.3%)
Mutual labels:  api, excel
Onenote
📚 Linux Electron Onenote - A Linux compatible version of OneNote
Stars: ✭ 1,300 (+870.15%)
Mutual labels:  microsoft, office
Luckysheet
Luckysheet is an online spreadsheet like excel that is powerful, simple to configure, and completely open source.
Stars: ✭ 9,772 (+7192.54%)
Mutual labels:  excel, office
Quip Export
Export all folders and documents from Quip
Stars: ✭ 28 (-79.1%)
Mutual labels:  api, office
Janitor
simple tools for data cleaning in R
Stars: ✭ 981 (+632.09%)
Mutual labels:  excel, data-analysis
Freenom Dns Updater
A tool to update freenom's dns records
Stars: ✭ 117 (-12.69%)
Mutual labels:  api, pypi
Regtweaks
Registry Tweaks for Windows.
Stars: ✭ 675 (+403.73%)
Mutual labels:  microsoft, office
Python O365
A simple python library to interact with Microsoft Graph and Office 365 API
Stars: ✭ 742 (+453.73%)
Mutual labels:  excel, microsoft
Pymarketcap
Python3 API wrapper and web scraper for https://coinmarketcap.com
Stars: ✭ 73 (-45.52%)
Mutual labels:  api, pypi
Phpspreadsheet
A pure PHP library for reading and writing spreadsheet files
Stars: ✭ 10,627 (+7830.6%)
Mutual labels:  excel, office

pylightxl - A Light Weight Excel Reader/Writer

Documentation

A light weight, zero dependency (only standard libs used), to the point (no bells and whistles) Microsoft Excel reader/writer python 2.7.18 - 3+ library.

Please help us spread the word about pylightxl to the community by voting for pylightxl to be added to python-awesome list. Follow the LINK and upvote the pull request in the top right corner

Project featured on PythonBytes Podcast Episode #165


Supports:

  • Reader supports .xlsx and .xlsm file extensions.
  • Writer only supports .xlsx (no macros/buttons/graphs/formatting)

Limitations:

  • Does not support .xls (excel 97-2003 worksheet).
  • Does not support worksheet cell data more than 536,870,912 cells (32-bit list limitation).
  • Writer does not support anything other than writing values/formulas/strings.
  • Writing to existing workbooks will remove any macros/buttons/graphs/formatting!

Why pylightxl over pandas/openpyxl/xlrd

  • 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 file 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')


Setup

pylightxl is officially published on pypi.org, however one of the key features of pylightxl is that it is packed light in case the user has pip and/or download restrictions, see docs - installation

pip install pylightxl


pypi version 1.53

  • bug fix: writing to existing file previously would only write to the current working directory, it now can handle subdirs. In addition inadvertently discovered a bug in python source code ElementTree.iterparse where source passed as a string was not closing the file properly. We submitted a issue to python issue tracker.

See full history log of revisions: Here


Contact/Questions/Suggestions

If you have any questions or feedback, we would love to hear from you - send us a post directly on GitHub.

We try to keep an active lookout for users trying to solve Microsoft Excel related problems with python on Stack Overflow. Please help us build on the great community that python already is by helping others get up to speed with pylightxl!

From everyone in the pylightxl family, thank you for visiting!

logo

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].