Excel

Open-source projects categorized as Excel
Edit details
Language: + JavaScript + Go + TypeScript + C# + Java + PHP + CSS + Shell + Python
Topics: XLSX Spreadsheet CSV Office Python
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.
www.influxdata.com
Sponsored

Top 23 Excel Open-Source Projects

  • SheetJS js-xlsx

    📗 SheetJS Spreadsheet Data Toolkit -- New home https://git.sheetjs.com/SheetJS/sheetjs

    • Project mention: how to work with .xlsx files? | /r/node | 2023-06-28

    ExcelJS and XLSX (SheetJS) are great libraries to work with XLSX files. The former I've found a bit easier to work with but less efficient in general.

  • easyexcel

    快速、简洁、解决大文件内存溢出的java处理Excel工具

  • SurveyJS

    Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

    SurveyJS logo

  • HANDSONTABLE

    JavaScript data grid with a spreadsheet look & feel. Works with React, Angular, and Vue. Supported by the Handsontable team ⚡

    • Project mention: MUI Datagrid resizable columns (free solution) | /r/reactjs | 2023-06-14

    handsontable

  • excelize

    Go language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets

    • Project mention: Recommend a powerful excel processing library, @zurmokeeper/exceljs, which supports encryption and decryption of xlsx files and flexible setting of multiple table headers when exporting, etc. | /r/node | 2023-07-01

    Then I found out that WPS only supports ecma376 standard encrytion for xlsx files. Then I referred to the official documentation and libraries in other languages, such as msoffcrypto-tool written in python. msoffcrypto-tool) and go's excelize. Since I don't know much about encryption and decryption, the process of implementation is also a bit of a twist.

  • x-spreadsheet

    The project has been migrated to @wolf-table/table https://github.com/wolf-table/table

  • PhpSpreadsheet

    A pure PHP library for reading and writing spreadsheet files

    • Project mention: Exporting data to Excel | /r/filemaker | 2023-12-08

    We have used a PHP Script to do this https://github.com/PHPOffice/PhpSpreadsheet

  • ag-Grid

    The best JavaScript Data Table for building Enterprise Applications. Supports React / Angular / Vue / Plain JavaScript.

    • Project mention: How To Enhance AG Grid with Avatars: Building a Collaborative Grid with React and Ably | dev.to | 2024-01-26

    In this post I’ll show you how, using the AG Grid component and Ably Spaces, you can create a React application that allows users to see not only who else is currently viewing the grid, but using a Flowbite Avatar Stack component, what row each user currently has selected.

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

    InfluxDB logo

  • gotenberg

    A developer-friendly API for converting numerous document formats into PDF files, and more!

    • Project mention: Create PDFs with Tailwind | dev.to | 2024-03-21

    Use a server-side headless browser such as puppeteer to convert the HTML to PDF. This is the most reliable free option, but requires a server. If you need to use it in production, we recommend you use Gotenberg.

  • Jspreadsheet CE

    Jspreadsheet is a lightweight vanilla javascript plugin to create amazing web-based interactive tables and spreadsheets compatible with other spreadsheet software.

  • tabula

    Tabula is a tool for liberating data tables trapped inside PDF files

    • Project mention: Automatisches Auslesen von PDFs | /r/de_EDV | 2023-05-16

  • xlsx

    Go library for reading and writing XLSX files.

  • NPOI

    a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.

  • ClosedXML

    ClosedXML is a .NET library for reading, manipulating and writing Excel 2007+ (.xlsx, .xlsm) files. It aims to provide an intuitive and user-friendly interface to dealing with the underlying OpenXML API.

    • Project mention: When XML in Word Became Illegal | news.ycombinator.com | 2023-10-12

    It's also country specific.

    I work on Excel library and the text to number/date feature was one of less fun things to implement at least semi-correctly.

    I remember my comment on the PR back then:

    https://github.com/ClosedXML/ClosedXML/pull/1899

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

    • Project mention: Ask HN: Why hasn't OnlyOffice see higher adoption than LibreOffice? | news.ycombinator.com | 2024-02-24

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

  • unioffice

    Pure go library for creating and processing Office Word (.docx), Excel (.xlsx) and Powerpoint (.pptx) documents

    • Project mention: Mastering Document Manipulation in Go: Empowering Your Workflow | /r/u_Shahab_Golang | 2023-07-03

    In this groundbreaking book, we dive deep into document manipulation using Go, empowering you to take control of your workflow like never before. Whether you're dealing with PDFs, spreadsheets, or other document formats, this resource will equip you with the knowledge and skills to master the art of document manipulation.

  • ExcelDataReader

    Lightweight and fast library written in C# for reading Microsoft Excel files

  • dsq

    Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.

    • Project mention: Tracking SQLite Database Changes in Git | news.ycombinator.com | 2023-11-02

    You might want to look at tsv-utils, or a similar project: https://github.com/eBay/tsv-utils

    For the SQL part, but maybe a lot heavier, you can use one of the projects listed on this page: https://github.com/multiprocessio/dsq (No longer maintained, but has links to lots of other projects)

  • vue-easytable

    A powerful data table based on vuejs. You can use it as data grid、Microsoft Excel or Google sheets. It supports virtual scroll、cell edit etc.

  • tbls

    tbls is a CI-Friendly tool for document a database, written in Go.

    • Project mention: FLaNK 25 December 2023 | dev.to | 2023-12-26

  • docxtemplater

    Generate docx, pptx, and xlsx from templates (Word, Powerpoint and Excel documents), from Node.js or the browser. Demo: https://www.docxtemplater.com/demo. #docx #office #generator #templating #report #json #generate #generation #template #create #pptx #docx #xlsx #react #vuejs #angularjs #browser #typescript #image #html #table #chart

  • xlwings

    xlwings is a Python library that makes it easy to call Python from Excel and vice versa. It works with Excel on Windows and macOS as well as with Google Sheets and Excel on the web.

    • Project mention: Python in Excel: Combining the Power of Python and the Flexibility of Excel | news.ycombinator.com | 2023-08-23

    Reading the headline, I initially thought that Microsoft bought the company behind XLWings [1], which also enables you to use Excel directly within Excel, even locally. Not affiliated in any kind to that company, just used it in the past.

    [1] https://www.xlwings.org/

  • revo-grid

    Powerful virtual data grid smartsheet with advanced customization. Best features from excel plus incredible performance 🔋

  • univer

    Univer is a set of enterprise document and data collaboration solutions, integrating spreadsheets, documents, and slides.

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

    WorkOS logo
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).

Excel related posts

Index

What are some of the best open-source Excel projects? This list will help you:

Project Stars
1 SheetJS js-xlsx 34,479
2 easyexcel 30,889
3 HANDSONTABLE 19,029
4 excelize 17,279
5 x-spreadsheet 13,763
6 PhpSpreadsheet 12,970
7 ag-Grid 11,762
8 gotenberg 6,693
9 Jspreadsheet CE 6,618
10 tabula 6,511
11 xlsx 5,750
12 NPOI 5,510
13 ClosedXML 4,407
14 ONLYOFFICE 4,351
15 unioffice 4,189
16 ExcelDataReader 3,792
17 dsq 3,619
18 vue-easytable 3,590
19 tbls 3,057
20 docxtemplater 2,854
21 xlwings 2,836
22 revo-grid 2,650
23 univer 2,563

Sponsored
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.
workos.com