The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →
Top 23 XLS Open-Source Projects
-
-
-
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.
-
ONLYOFFICE
ONLYOFFICE Docs is a free collaborative online office suite comprising viewers and editors for texts, spreadsheets and presentations, forms and PDF, fully compatible with Office Open XML formats: .docx, .xlsx, .pptx and enabling collaborative editing in real time.
-
django-import-export
Django application and library for importing and exporting data with admin integration.
-
DesktopEditors
An office suite that combines text, spreadsheet and presentation editors allowing to create, view and edit local documents
-
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.
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
-
ExcelMapper
An Excel to object mapper. Maps POCOs to and from Excel. Configuration via convention, attributes, or fluent methods.
-
-
Npoi.Mapper
Use this tool to import or export data with Excel file. The tool is a convention based mapper between strong typed object and Excel data via NPOI.
-
DocTo
Simple command line utility for converting .doc & .xls files to any supported format such as Text, RTF, CSV or PDF
-
react-spreadsheet-import
Import flow for Excel (.xlsx) and CSV file with automated column matching and validation.
-
grate
A Go native tabular data extraction package. Currently supports .xls, .xlsx, .csv, .tsv formats.
-
DocumentBuilder
ONLYOFFICE Document Builder is powerful text, spreadsheet, presentation and PDF generating tool
-
dbd
dbd is a database prototyping tool that enables data analysts and engineers to quickly load and transform data in SQL databases.
-
typed-xlsx
A simple yet powerful library to effortlessly export any data into XLSX sheets, with the full power of type-safety and awesome DX
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
We have used a PHP Script to do this https://github.com/PHPOffice/PhpSpreadsheet
Project mention: Ask HN: Why hasn't OnlyOffice see higher adoption than LibreOffice? | news.ycombinator.com | 2024-02-24Had never even heard of it.
And their website doesn't help at all - https://www.onlyoffice.com/ - At first, I thought it is selling some kind of add-on for Businesses to use with Microsoft Office. Then I clicked "Get it now" and saw a page that gives me options to download a Docker Image, or Cloud Images or VM Images. What the heck? Then I see the "GET OnlyOffice" link in the navigation menu and go to it - the menu pop-up talks about DocSpace, Enterprise, Workspace etc. etc. and asks to sign-in for cloud. Again, what the heck?? Then I go to the PRODUCT link that also pop-ups lot of options - like - Doc editors to integrate into your business platform .... ??? Then I see the "Desktop and Mobile Apps" option in it and click 'For Desktop'. And finally, here I found what I had been searching for - Get free desktop office suite for document editing and collaboration ( https://www.onlyoffice.com/desktop.aspx ).
When a website is designed to be "Enterprisey" - only targetting and catering to a particular audience, and totally ignores everyone else - I am not surprised it's userbase is limited.
Project mention: EDPS: European Commission's use of Microsoft 365 infringes data protection law [pdf] | news.ycombinator.com | 2024-03-11At least the desktop version is pretty much open source: https://github.com/ONLYOFFICE/DesktopEditors
There is similar open-source project for Google Sheets: https://github.com/0x6b/libgsqlite (SQLite extension), which is a fork of https://github.com/x2bool/xlite (same idea but for Microsoft Excel spreadsheets)
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.
We just went through the process of getting a file ingestion capability. Flatfile was considered. It’s very expensive. We chose open source https://github.com/UgnisSoftware/react-spreadsheet-import
Project mention: Typed-xlsx - Effortlessly export any data into excel sheets, with the full power of type-safety and good DX | /r/node | 2023-12-05And here's the git repository : https://github.com/ChronicStone/typed-xlsx
NOTE:
The open source projects on this list are ordered by number of github stars.
The number of mentions indicates repo mentiontions in the last 12 Months or
since we started tracking (Dec 2020).
XLS related posts
- Import or load a json into a database
- Today I learned that Range.Find() in the Excel interop library respects any filters the workbook was saved with and will not return results from filtered rows.
- Import data to the Django
- Help to draw graph in reactjs from data in excel sheet
- How do I read Excel 97 sheets with node?
- I need help..an old firm has cobol system with terminals, is there a way to extract data in that to Excell or anything?
- The World Cup of Microsoft Excel
-
A note from our sponsor - WorkOS
workos.com | 24 Apr 2024
Index
What are some of the best open-source XLS projects? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | easyexcel | 30,889 |
| 2 | PhpSpreadsheet | 12,970 |
| 3 | ONLYOFFICE | 4,351 |
| 4 | ExcelDataReader | 3,788 |
| 5 | django-import-export | 2,861 |
| 6 | DesktopEditors | 2,513 |
| 7 | python-benedict | 1,402 |
| 8 | xlite | 1,230 |
| 9 | pyexcel | 1,173 |
| 10 | Spreadsheet | 1,121 |
| 11 | rows | 860 |
| 12 | ExcelMapper | 728 |
| 13 | readxl | 719 |
| 14 | Npoi.Mapper | 577 |
| 15 | DocTo | 409 |
| 16 | react-spreadsheet-import | 391 |
| 17 | Sylvan.Data.Excel | 164 |
| 18 | grate | 133 |
| 19 | DocumentBuilder | 106 |
| 20 | dbd | 55 |
| 21 | xls2json | 43 |
| 22 | typed-xlsx | 26 |
| 23 | dif | 24 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com