1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
|
# Spreadsheet
## Getting Started
[](https://gitter.im/zdavatz/spreadsheet?utm_source=badge&utm_medium=badge&utm_campaign=pr-badge&utm_content=badge)
[](https://github.com/zdavatz/spreadsheet/workflows/Ruby/badge.svg)
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
## 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](mailto:a@boxbot.org): The library doesn't recognize cell formats in Excel
created documents, which results in Floats returned for any number.
* [Tom](https://github.com/tom-lord): 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
* [ruby-ole](http://code.google.com/p/ruby-ole/)
## Examples
* Have a look at the [GUIDE](https://github.com/zdavatz/spreadsheet/blob/master/GUIDE.md)
* Also look at: https://gist.github.com/phollyer/1214475
## Installation
Using [RubyGems](http://www.rubygems.org):
* `sudo gem install spreadsheet`
If you don't like [RubyGems](http://www.rubygems.org), 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 (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)
## License
This library is distributed under the GPLv3.
Please see the [LICENSE](https://github.com/zdavatz/spreadsheet/blob/master/LICENSE.txt) file.
|
