Skip to content

zdavatz/spreadsheet

Repository files navigation

Spreadsheet

Getting Started

Join the chat at https://gitter.im/zdavatz/spreadsheet Build Status

The Mailing List can be found here:

http://groups.google.com/group/rubyspreadsheet

The code can be found here:

https://github.com/zdavatz/spreadsheet

For Non-GPLv3 commercial licensing, please see:

http://www.spreadsheet.ch

XLS Binary Documentation

Description

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.

Notes from Users

  • Alfred: The library doesn't recognize cell formats in Excel created documents, which results in Floats returned for any number.
  • Tom: This library only supports XLS format; it does not support XLSX format.

What's new?

  • Supported outline (grouping) functions
  • Significantly improved memory-efficiency when reading large Excel Files
  • Limited Spreadsheet modification support
  • Improved handling of String Encodings

On the Roadmap

  • Improved Format support/Styles
  • Document Modification: Formats/Styles
  • Formula Support
  • Document Modification: Formulas
  • Write-Support: BIFF5
  • Remove backward compatibility code

Note: Spreadsheet is tested against all minor ruby versions through: 1.8.7 - 2.6.3

You will get a deprecated warning about iconv when using spreadsheet with Ruby 1.9.3. So replacing iconv is on the Roadmap as well ;).

Dependencies

Examples

Installation