spreadsheet - The Ruby Spreadsheet by ywesee GmbH

  •        57

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.

http://spreadsheet.ch
https://github.com/zdavatz/spreadsheet

Tags
Implementation
License
Platform

   




Related Projects

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.

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.

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

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.


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.

Fast Excel Spreadsheet Writer

  •    CSharp

The Fast Excel Spreadsheet Writer makes it easier for developers to write 2007 / 2010 Excel spreadsheets containing large sets of raw data. It can write hundreds of thousands of records in seconds. It is developed in C# and uses the Packaging namespace and Xml writers.

jquery-table2excel - jQuery Plugin to export HTML tabled to Excel Spreadsheet Compatible Files

  •    Javascript

This plugin is a hack on a hack. The .xls extension is the only way [some versions] of excel will even open it, and you will get a warning about the contents which can be ignored. The plugin was developed against Chrome and other have contributed code that should allow it to work in Firefox and Safari, but inconsistently since it's a hack that's not well supported anywhere but Chrome. I would not use this in public production personally and it was developed for an Intranet application where users are on Chrome and had known versions of Excel installed and the users were educated about the warning. These users also save-as in Excel so that when the files are distributed, the end-users don't get the warning message. Contains a simple HTML file to demonstrate your plugin.

Import Excel data to SharePoint List

  •    

Import from Spreadsheet is a tool developed for MOSS x86 and x64 platform allowing mapping fields and import data into SharePoint lists.

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

DB2/400 to Excel via POI

  •    

Convert DB2/400 Table data into Excel Spreadsheet via POI. XLDFT is where you setup your default information. XLCRT generates XLS files. XLMAINT allows you to enter custom headings for a file.

xlrd - Library for developers to extract data from Microsoft Excel (tm) spreadsheet files

  •    Python

Library for developers to extract data from Microsoft Excel (tm) spreadsheet files

Excel Query

  •    

Provides methods to query an Excel spreadsheet as well as update the spreadsheet cells.

Excel Spreadsheet C# Import Using Typed Datasets and TableAdapters

  •    

We will examine how to import data from a Microsoft Excel spreadsheet into a database from a web page. Specifically, we will build a tiered application architecture using Typed DataSets and TableAdapters. This version is in C#. Step by step tutorials included.

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.

spreadsheet - The Ruby Spreadsheet by ywesee GmbH

  •    Ruby

The Ruby Spreadsheet by ywesee GmbH

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.

React-Spreadsheet-Component - :clipboard: Spreadsheet Component for ReactJS

  •    Javascript

This is a spreadsheet component built in Facebook's ReactJS. You can see a demo here. The component is initialized with a configuration object. If desired, initial data for the spreadsheet can be passed in as an array of rows. In addition, you can pass in a second array filled with class names for each cell, allowing you to style each cell differently.

xlwt

  •    Python

Library to create spreadsheet files compatible with MS Excel 97/2000/XP/2003 XLS files, on any platform, with Python 2.3 to 2.6