87 best open source spreadsheet projects.

We have collection of more than 1 Million open source products ranging from Enterprise product to small libraries in all platforms. We aggregate information from all open source repositories. Search and find the best for your needs. Check out projects section.

Displaying 1 to 20 from 87 results

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-components windowing virtualization list grid listview tabular-data performance reactjs react-component virtual scrolling infinite virtualized table fixed header flexbox spreadsheet table-view infinite-scroll

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

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

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

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

drive-db - :bar_chart: A Google Drive spreadsheet simple database

Javascript

A Google Drive spreadsheet simple database. Stop wasting your time when a simple table is enough. Perfect for collaboration with multiple people editing the same spreadsheet.

google drive database db table spreadsheet mongodb

node-google-spreadsheet - Google Spreadsheets Data API for Node.js

Javascript

A simple Node.js module for reading and manipulating data in Google Spreadsheets. This example is simply meant to show some of the things you can do.

google-spreadsheets google spreadsheet spreadsheets sheets gdata api google-sheets

GridView - Reusable GridView with excellent performance and customization that can be time table, spreadsheet, paging and more

Swift

GridView can tile the view while reusing it. It has an API like UIKit that works fast. Even when device rotates it smoothly relayout. ⚠️ WARNING : If you want to install from CocoaPods, must add G3GridView to Podfile because there is a GridView different from this GridView.

gridview grid-layout timetable spreadsheet ios

core - A canvas-based super high performant grid renderer API

Javascript

Hypergrid 3.0 includes a revised data model with some breaking changes. For a complete list of changes, see the release notes.

hypergrid fin-hypergrid grid canvas graphics spreadsheet

googlesheets - Google Spreadsheets R API

Access and manage Google spreadsheets from R with googlesheets. googlesheets is inspired by gspread, a Google Spreadsheets Python API.

r google-sheets google-drive cran spreadsheet

readxl - Read excel files (.xls and .xlsx) into R 🖇

The readxl package makes it easy to get data out of Excel and into R. Compared to many of the existing packages (e.g. gdata, xlsx, xlsReadWrite) readxl has no external dependencies, so it’s easy to install and use on all operating systems. It is designed to work with tabular data. readxl supports both the legacy .xls format and the modern xml-based .xlsx format. The libxls C library is used to support .xls, which abstracts away many of the complexities of the underlying binary format. To parse .xlsx, we use the RapidXML C++ library.

r excel xlsx xls spreadsheet