Repository files navigation

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

• https://github.com/zdavatz/spreadsheet/blob/master/Excel97-2007BinaryFileFormatSpecification.pdf
• https://github.com/zdavatz/spreadsheet/blob/master/excelfileformat.pdf

The Spreadsheet Library is designed to read and write Spreadsheet Documents.As of version 0.6.0, only Microsoft Excel compatible spreadsheets aresupported. Spreadsheet is a combination/complete rewrite of theSpreadsheet::Excel Library by Daniel J. Berger and the ParseExcel Library byHannes Wyss. Spreadsheet can read, write and modify Spreadsheet Documents.

• Alfred: The library doesn't recognize cell formats in Excelcreated documents, which results in Floats returned for any number.
• Tom: This libraryonly supports XLS format;it doesnot support XLSX format.

• 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
• 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 Ruby1.9.3. So replacing iconv is on the Roadmap as well ;).

• ruby-ole

• Have a look at theGUIDE
• Also look at:https://gist.github.com/phollyer/1214475

UsingRubyGems:

• sudo gem install spreadsheet

If you don't likeRubyGems, let me know whichinstallation 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.

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 (ngiger@ywesee.com,mhatakeyama@ywesee.com,zdavatz@ywesee.com)

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