Skip to content


Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
The Ruby Spreadsheet by ywesee GmbH

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.


Last Update: 08.12.2011 - Zeno R.R. Davatz

= Spreadsheet

The Mailing List can be found here:

The code can be found here:

For a viewable directory of all recent changes, please see:;a=summary

To get a graphical overview of the Library please see

For Non-GPLv3 commercial licencing, please see:

== 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: 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.

== 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

== Roadmap

0.7.0:: Improved Format support/Styles
0.7.1:: Document Modification: Formats/Styles
0.8.0:: Formula Support
0.8.1:: Document Modification: Formulas
0.9.0:: Write-Support: BIFF5
1.0.0:: Ruby 1.9 Support;
        Remove backward compatibility code

Note: Spreadsheet supports Ruby 1.8.6, 1.8.7, 1.9.2, 1.9.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

* ruby 1.8
* ruby-ole[]

== Examples

Have a look at the GUIDE[link://files/GUIDE_txt.html].

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

If you can use 'rake' and 'hoe' library is also installed, you can 
build a gem package as follows:

* rake gem 

The gem package is built in pkg directory.

== Authors

Original Code:

Copyright (c) 2005 by Daniel J. Berger (

Copyright (c) 2003 by Hannes Wyss (

New Code:
Copyright (c) 2010 ywesee GmbH (,

== License

This library is distributed under the GPLv3.
Please see the LICENSE[link://files/LICENSE_txt.html] file.

Something went wrong with that request. Please try again.