You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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 ;).