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.
Spreadsheet alternatives and similar gems
Based on the "Spreadsheets and Documents" category.
Alternatively, view Spreadsheet alternatives based on common mentions on social networks and blogs.
-
AXLSX
xlsx generation with charts, images, automated column width, customizable styles and full schema validation. Axlsx excels at helping you generate beautiful Office Open XML Spreadsheet documents without having to understand the entire ECMA specification. Check out the README for some examples of how easy it is. Best of all, you can validate your xlsx file before serialization so you know for sure that anything generated is going to load on your client's machine. -
Spreadsheet Architect
Spreadsheet Architect is a library that allows you to create XLSX, ODS, or CSV spreadsheets super easily from ActiveRecord relations, plain Ruby objects, or tabular data. -
Xsv .xlsx reader
High performance, lightweight .xlsx parser for Ruby that provides nothing a CSV parser wouldn't -
Fastsheet
FastSheet is the fastest XLSX file parser for Ruby (at the time of release). It leverages a Rust library for high-performance parsing, making it significantly faster than other available solutions.
Scout Monitoring - Performance metrics and, now, Logs Management Monitoring with Scout Monitoring
* Code Quality Rankings and insights are calculated and provided by Lumnify.
They vary from L1 to L5 with "L5" being the highest.
Do you think we are missing an alternative of Spreadsheet or a related project?
README
Spreadsheet
Getting Started
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:
XLS Binary Documentation
- https://github.com/zdavatz/spreadsheet/blob/master/Excel97-2007BinaryFileFormatSpecification.pdf
- https://github.com/zdavatz/spreadsheet/blob/master/excelfileformat.pdf
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: 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 ;).
Dependencies
Examples
- Have a look at the GUIDE
- Also look at: https://gist.github.com/phollyer/1214475
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.
Tu build the gem you can do:
gem build spreadsheet
The gem package is built in pkg directory.
Testing
Bundler support added. Running tests:
bundle install
- ./test/suite.rb
Authors
Original Code:
Spreadsheet::Excel: Copyright (c) 2005 by Daniel J. Berger ([email protected])
ParseExcel: Copyright (c) 2003 by Hannes Wyss ([email protected])
New Code: Copyright (c) 2010 ywesee GmbH ([email protected], [email protected], [email protected])
License
This library is distributed under the GPLv3. Please see the LICENSE file.
*Note that all licence references and agreements mentioned in the Spreadsheet README section above
are relevant to that project's source code only.