Top 6 Python XLS Projects
-
django-import-export
Django application and library for importing and exporting data with admin integration.
-
python-benedict
:blue_book: dict subclass with keylist/keypath support, built-in I/O operations (base64, csv, html, ini, json, pickle, plist, query-string, toml, xls, xml, yaml), s3 support and many utilities.
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
-
dbd
dbd is a database prototyping tool that enables data analysts and engineers to quickly load and transform data in SQL databases.
You could try and write some simple python using the pyexcel and pandas libraries. I created a tool as a consultant with these packages that parsed spreadsheets with data from factories from all around the world. They did not lock down the Excel files used to submit data and it made it so much harder. If you go this route, I would recommend starting by putting your data into a SQLite database. Once you have your data in a database, you unlock the power of SQL for pulling reports. Also, you can port the data into a proper database if you ever need to. ChatGPT can probably get you a good chunk of the way there.
Python XLS related posts
Index
What are some of the best open-source XLS projects in Python? This list will help you:
Project | Stars | |
---|---|---|
1 | django-import-export | 2,887 |
2 | python-benedict | 1,424 |
3 | pyexcel | 1,173 |
4 | rows | 861 |
5 | dbd | 55 |
6 | degiro-trading-tracker | 20 |
Sponsored