Popularity
6.6
Stable
Activity
5.2
Growing
1,129
37
240

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.

Code Quality Rank: L2
Monthly Downloads: 907,728
Programming language: Ruby
License: GNU General Public License v3.0 only
Latest version: v1.2.9

Spreadsheet alternatives and similar gems

Based on the "Spreadsheets and Documents" category.
Alternatively, view Spreadsheet alternatives based on common mentions on social networks and blogs.

Do you think we are missing an alternative of Spreadsheet or a related project?

Add another 'Spreadsheets and Documents' Gem

README

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

Using RubyGems:

  • sudo gem install spreadsheet

If you don't like RubyGems, let me know which installation solution you prefer and I'll include it in the future.

Tu build the gem you can do:

  • gem build spreadsheet

The gem package is built in pkg directory.

Testing

Bundler support added. Running tests:

  • bundle install
  • ./test/suite.rb

Authors

Original Code:

Spreadsheet::Excel: Copyright (c) 2005 by Daniel J. Berger ([email protected])

ParseExcel: Copyright (c) 2003 by Hannes Wyss ([email protected])

New Code: Copyright (c) 2010 ywesee GmbH ([email protected], [email protected], [email protected])

License

This library is distributed under the GPLv3. Please see the LICENSE file.


*Note that all licence references and agreements mentioned in the Spreadsheet README section above are relevant to that project's source code only.