Skip to content


Subversion checkout URL

You can clone with
Download ZIP
Latest commit 1a40355 @zdavatz zdavatz Merge pull request #3 from vanderhoorn/master
Fix bug in sanitize_worksheets if 'sheets' is empty + add a test


Last Update: 14.02.2011 - Zeno R.R. Davatz

= Spreadsheet

The Mailinglist 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.

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

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