Last Update: 06.02.2013 - Zeno R.R. Davatz
github.com/zdavatz/spreadsheet
The Mailing List can be found here:
groups.google.com/group/rubyspreadsheet
The code can be found here:
github.com/zdavatz/spreadsheet
For a viewable directory of all recent changes, please see:
scm.ywesee.com/?p=spreadsheet/.git;a=summary
To get a graphical overview of the Library please see
For Non-GPLv3 commercial licencing, please see:
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.
Supported outline (grouping) functions
Significantly improved memory-efficiency when reading large Excel Files
Limited Spreadsheet modification support
Improved handling of String Encodings
Improved Format support/Styles
Document Modification: Formats/Styles
Formula Support
Document Modification: Formulas
Write-Support: BIFF5
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 ;).
ruby 1.8
Have a look at the GUIDE. Also look at: gist.github.com/phollyer/1214475
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.
Bundler support added. Running tests:
bundle install
./test/suite.rb
Original Code:
Spreadsheet::Excel: Copyright (c) 2005 by Daniel J. Berger (djberg96@gmail.com)
ParseExcel: Copyright (c) 2003 by Hannes Wyss (hannes.wyss@gmail.com)
New Code: Copyright (c) 2010 ywesee GmbH (mhatakeyama@ywesee.com, zdavatz@ywesee.com)
This library is distributed under the GPLv3. Please see the LICENSE file.
Generated with the Darkfish Rdoc Generator 2.