caxlsx - xlsx generation with charts, images, automated column width, customizable styles and full schema validation

•    Ruby

---

Axlsx is an Office Open XML Spreadsheet generator for the Ruby programming language. With Axlsx you can create excel worksheets with charts, images (with links), automated and fixed column widths, customized styles, functions, tables, conditional formatting, print options, comments, merged cells, auto filters, file and stream serialization as well as full schema validation. Axlsx excels at helping you generate beautiful Office Open XML Spreadsheet documents without having to understand the entire ECMA specification. Author xlsx documents: Caxlsx is made to let you easily and quickly generate professional xlsx based reports that can be validated before serialization.

ruby-gem excelwriter excel-export

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

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

LibreOffice - The Document foundation

•    C

---

LibreOffice is the free power-packed Open Source personal productivity suite for Windows, Macintosh and Linux. LibreOffice is the perfect choice for home users, businesses, government and other organizations. It's native file format is the ISO standardized ODF (Open Document Format), but LibreOffice can open and save Microsoft Word, PowerPoint and Excel files, as well as many other formats, bringing you the widest-available compatibility with other products.

office-suite document office word excel graphics-editor

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

CoreXLSX - Excel spreadsheet (XLSX) format parser written in pure Swift

•    Swift

---

CoreXLSX is a library focused on representing the low-level structure of XML-based XLSX spreadsheet format. It allows you to open a spreadsheet archive and map its XML structure into model types expressed directly in Swift. To run the example project, clone the repo, and run pod install from the Example directory first.

excel excelreader excel-import excelparser xml office ios tvos watchos parser

sheetfu - Python library to interact with Google Sheets V4 API

•    Python

---

Sheetfu was built to interacts with Google Sheets with a simple, intuitive, and fast API. The primary goal of this library is to adapt the Google App Script API for spreadsheets, to Python. With Sheetfu, you can easily get or set cell values, background colors, font colors or any other cell attributes. For better security, you can also create your SpreadsheetApp object with environment variables instead of the secrets.json file.

google-spreadsheet python-library google-sheets-api google-sheets-api-v4 spreadsheets spreadsheet-mapper spreadsheet-manipulation python-data sheetfu spreadsheet-orm

ONLYOFFICE Desktop Editors - An office suite that combines text, spreadsheet and presentation editors allowing to create, view and edit local documents

•    C

---

ONLYOFFICE Desktop Editors is a free and open source office suite comprises text documents, spreadsheets and presentations allowing to create, view and edit documents of any size and complexity, to easily switch to the online mode for real-time co-editing and collaboration. Features as reviewing, commenting and chat are available as well. Deal with multiple files within one and the same window thanks to the tab-based user interface

onlyoffice office word excel spreadsheet presentation desktop docx xlsx pptx doc xls ppt odt ods odp collaboration node nodejs office-suite document-editor

pivot.js - Build Pivot Tables from CSV/JSON Data

•    Javascript

---

Pivot.js is a simple way for you to get to your data. It allows for the creation of highly customizable unique table views from your browser. In data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. Among other functions, pivot-table tools can automatically sort, count, total or give the average of the data stored in one table or spreadsheet. It displays the results in a second table (called a "pivot table") showing the summarized data.

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

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

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

•    C++

---

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

docjure - Read and write Office documents from Clojure

•    Clojure

---

Docjure makes reading and writing Office documents in Clojure easy. This example creates a spreadsheet with a single sheet named "Price List". It has three rows. We apply a style of yellow background colour and bold font to the top header row, then save the spreadsheet.

excel spreadsheet xlsx xls

Corrupt XLSX Salvager

•    

---

Recover Data for Excel XLSX Files Excel Won't Open

Open Door Logistics Studio - Intelligient software for Vechile routing and Territory mangement

•    Java

---

Open Door Logistics Studio is an easy-to-use standalone open source desktop application for performing (a) analysis of your customer locations, (b) sales territory design and mapping and (c) vehicle fleet routing & scheduling - all using an Excel spreadsheet. It supports Territory design, Territory mapping, Vehicle routing & scheduling.

logistics territory-design territory-management territory-mapping

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

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

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

x-spreadsheet - A web-based JavaScript（canvas） spreadsheet

•    Javascript

---

Open your browser and visit http://127.0.0.1:8080. Modern browsers(chrome, firefox, Safari).

canvas js es6 excel spreadsheet

datasheets - Read data from, write data to, and modify the formatting of Google Sheets

•    Python

---

datasheets is a library for interfacing with Google Sheets, including reading data from, writing data to, and modifying the formatting of Google Sheets. It is built on top of Google's google-api-python-client and oauth2client libraries using the Google Drive v3 and Google Sheets v4 REST APIs. It can be installed with pip via pip install datasheets.

google pandas dataframe data-science data data-analytics