spout - Read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way

•    PHP

---

Spout is a PHP library to read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way. Contrary to other file readers or writers, it is capable of processing very large files while keeping the memory usage really low (less than 3MB).Full documentation can be found at http://opensource.box.com/spout/.

xlsx ods csv spreadsheet writer reader memory-efficient fast scalable

SpreadsheetView - Full configurable spreadsheet view user interfaces for iOS applications

•    HTML

---

Full configurable spreadsheet view user interfaces for iOS applications. With this framework, you can easily create complex layouts like schedule, Gantt chart, timetable as if you are using Excel. The minimum requirement is connecting a data source to return the number of columns/rows, and each column width/row height.

spreadsheet timetable grid-layout gantt-chart schedule ios

spreadsheet - The Ruby Spreadsheet by ywesee GmbH

•    Ruby

---

The Spreadsheet Library is designed to read and write Spreadsheet Documents. As of version 0.6.0, only Microsoft Excel compatible spreadsheets are supported. Spreadsheet is a combination/complete rewrite of the Spreadsheet::Excel Library by Daniel J. Berger and the ParseExcel Library by Hannes Wyss. Spreadsheet can read, write and modify Spreadsheet Documents. Alfred: a@boxbot.org: I think it should be noted in the README file that the library doesn't recognize cell formats in Excel created documents, which results in Floats returned for any number.

excel xls spreadsheet ruby-spreadsheet gplv3

exceljs - Excel Workbook Manager

•    Javascript

---

Read, manipulate and write spreadsheet data and styles to XLSX and JSON. Reverse engineered from Excel spreadsheet files as a project.

xlsx json csv excel font border fill number format number-format alignment office spreadsheet workbook defined-names data-validations rich-text in-cell-format outlinelevel views frozen split pagesetup

PhpSpreadsheet - A pure PHP library for reading and writing spreadsheet files

•    PHP

---

PhpSpreadsheet is a library written in pure PHP and providing a set of classes that allow you to read from and to write to different spreadsheet file formats, like Excel and LibreOffice Calc. Read more about it, including install instructions, in the official documentation. Or check out the API documentation.

spreadsheet excel libreoffice xlsx ods xls phpexcel

Handsontable - JavaScript/HTML5 UI Spreadsheet library for web apps. Available for React, Vue and Angular

•    Javascript

---

Handsontable Community Edition (CE) is an open source JavaScript/HTML5 UI Spreadsheet component for web apps. It easily integrates with any data source and comes with a variety of useful features like data binding, validation, sorting or powerful context menu. It is available for Vue, React, Angular and Polymer.

spreadsheet data-grid grid-editor dynamic-table component data-binding data grid table editor data-table excel tabular-data edit-cell editable-table data-spreadsheet

react-window - React components for efficiently rendering large lists and tabular data

•    Javascript

---

React components for efficiently rendering large, scrollable lists and tabular data

react reactjs virtual window windowed list scrolling infinite virtualized table grid spreadsheet

EPPlus - Create advanced Excel spreadsheets using .NET

•    CSharp

---

Create advanced Excel spreadsheets using .NET, without the need of interop. All support is currently referred to Stack overflow. A tutorial is available in the wiki and the sample project can be downloaded with each version. The old site at Codeplex also contains material that can be helpful. Bugs and new feature requests can be added to the issues tracker.

excel ooxml spreadsheet

sheetsee.js - :eyes: :chart_with_upwards_trend: Visualize Data from a Google Spreadsheet

•    Javascript

---

This repository is for the project website and provides a compiled version sheetsee.js. Use the compiled version if you want all of what is available in Sheetsee. If you want just the parts that you're going to use in your project and nothing more, you can build a custom version. Each part of Sheetsee has its own repository and issues should be opened there. General issues/pull requests for the site are OK here.

spreadsheet data visualize google

spreadsheet_architect - Spreadsheet Architect is a library that allows you to create XLSX, ODS, or CSV spreadsheets super easily from ActiveRecord relations, plain Ruby objects, or tabular data

•    Ruby

---

Spreadsheet Architect is a library that allows you to create XLSX, ODS, or CSV spreadsheets super easily from ActiveRecord relations, plain Ruby objects, or tabular data. When NOT using the :data option, ie. on an AR Relation or using the :instances option, Spreadsheet Architect requires an instance method defined on the class to generate the data. It looks for the spreadsheet_columns method on the class. If you are using on an ActiveRecord model and that method is not defined, it would fallback to the models column_names method (not recommended). If using the :data option this is ignored.

spreadsheet xlsx ods csv export activerecord rails

unioffice - Pure go library for creating and processing Office Word (

•    Go

---

Announcement (2019/04/29): UniDoc aquires gooxml. UniDoc (https://unidoc.io and https://github.com/unidoc) has aquired gooxml from Baliance and we plan to add it to our suite of document format support for Go. The repository (gooxml) will be moving to a new home: https://github.com/unidoc/unioffice and the package name will be come unioffice.

ooxml openoffice docx pptx xlsx ecma-376 spreadsheet word powerpoint excel

Luckysheet - Luckysheet is an online spreadsheet like excel that is powerful, simple to configure, and completely open source

•    Javascript

---

🚀Luckysheet is an online spreadsheet like excel that is powerful, simple to configure, and completely open source. Detailed changes for each release are documented in the CHANGELOG.md.

formula chart canvas excel google-spreadsheet xlsx spreadsheet google-sheets office pivot-tables sparkline data-table web-based conditional-formatting

React Virtualized - React components for efficiently rendering large lists and tabular data

•    Javascript

---

React components for efficiently rendering large, scrollable lists and tabular data.

react react-component windowing virtualization list grid listview tabular-data performance reactjs virtual scrolling infinite virtualized table fixed header flexbox spreadsheet table-view infinite-scroll

Excelize - Golang library for reading and writing Microsoft Excel (XLSX) files

•    Go

---

Excelize is a library written in pure Go providing a set of functions that allow you to write to and read from XLSX / XLSM / XLTM / XLTX files. Supports reading and writing spreadsheet documents generated by Microsoft Excel™ 2007 and later. Supports complex components by high compatibility, and provided streaming API for generating or reading data from a worksheet with huge amounts of data

microsoft golang excel xlsx spreadsheet office openxml ooxml excelize xlsm excel-library

NocoDB - The Open Source Airtable alternative

•    Vue

---

NocoDB is an open source Airtable alternative. NocoDB works by connecting to any relational database and transforming them into a smart spreadsheet interface! This allows you to build no-code applications collaboratively with teams. NocoDB currently works with MySQL, PostgreSQL, Microsoft SQL Server, SQLite, Amazon Aurora & MariaDB databases.

mysql graphql rest-api sqlite postgresql swagger spreadsheet mariadb airtable sqlserver restful-api low-code no-code automatic-api no-code-database airtable-alternative workflow kanban-board

tui

•    TypeScript

---

The functionality of TOAST UI Grid is available when using the Plain javaScript, React, Vue Component. The TOAST UI Grid is a component that can display, edit, add, and delete multiple data. You can append units to the data shown and use html to represent images and links instead of textual data.

typescript grid preact excel tabular-data spreadsheet datatable treegrid reactivity datagrid toast-ui

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

•    Javascript

---

Jspreadsheet CE is a lightweight Vanilla JavaScript plugin to create amazing web-based interactive HTML tables and spreadsheets compatible with other spreadsheet software. You can create an online spreadsheet table from a JS array, JSON, CSV or XSLX files. You can copy from excel and paste straight to your Jspreadsheet CE spreadsheet and vice versa. It is very easy to integrate any third party JavaScript plugins to create your own custom columns, custom editors, and customize any feature into your application. Jspreadsheet CE has plenty of different input options through its native column types to cover the most common web-based application requirements. It is a complete solution for web data management. Create amazing applications with Jspreadsheet CE JavaScript spreadsheet. React Implementation A full example on how to integrate Jspreadsheet CE with React.

js datatables excel table spreadsheet spreadsheets jexcel jspreadsheet online-spreadsheet tables grid grid-editor data-table data-grid data-spreadsheet

SpreadsheetView - Full configurable spreadsheet view user interfaces for iOS applications

•    HTML

---

Full configurable spreadsheet view user interfaces for iOS applications. With this framework, you can easily create complex layouts like schedule, Gantt chart, timetable as if you are using Excel. The minimum requirement is connecting a data source to return the number of columns/rows, and each column width/row height.

ios schedule spreadsheet timetable grid-layout gantt-chart

ImportJSON - Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet

•    HTML

---

Review ImportJSON.gs for more info on how to use these in detail. Cryptocurrencies: Looking to import JSON for cryptocurrency price data? Try CryptocurrencySpreadsheetUtils instead which offers a useful getCoinPrice() function.

spreadsheet google-sheets importjson parsing cryptocurrencies

django-rest-pandas - 📊📈 Serves up Pandas dataframes via the Django REST Framework for use in client-side (i

•    Python

---

Django REST Pandas (DRP) provides a simple way to generate and serve pandas DataFrames via the Django REST Framework. The resulting API can serve up CSV (and a number of other formats) for consumption by a client-side visualization tool like d3.js. The design philosophy of DRP enforces a strict separation between data and presentation. This keeps the implementation simple, but also has the nice side effect of making it trivial to provide the source data for your visualizations. This capability can often be leveraged by sending users to the same URL that your visualization code uses internally to load the data.

dataviz pandas django rest-api django-rest-framework spreadsheet chart excel csv