https://github.com/zdavatz/spreadsheet
The Ruby Spreadsheet by ywesee GmbH
https://github.com/zdavatz/spreadsheet
Keywords
excel gplv3 ruby ruby-spreadsheet spreadsheet xls
Keywords from Contributors
activerecord activejob mvc rspec crash-reporting feature-flag ruby-gem rubocop code-formatter static-code-analysis
Last synced: about 11 hours ago
JSON representation
Repository metadata
The Ruby Spreadsheet by ywesee GmbH
- Host: GitHub
- URL: https://github.com/zdavatz/spreadsheet
- Owner: zdavatz
- License: gpl-3.0
- Created: 2012-04-13T15:44:37.000Z (almost 14 years ago)
- Default Branch: master
- Last Pushed: 2026-02-27T09:15:51.000Z (5 days ago)
- Last Synced: 2026-03-02T01:52:01.176Z (2 days ago)
- Topics: excel, gplv3, ruby, ruby-spreadsheet, spreadsheet, xls
- Language: Ruby
- Homepage: http://spreadsheet.ch
- Size: 5.29 MB
- Stars: 1,147
- Watchers: 34
- Forks: 237
- Open Issues: 13
- Releases: 0
-
Metadata Files:
- Readme: README.md
- Changelog: History.md
- Funding: .github/FUNDING.yml
- License: LICENSE.txt
README.md
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 requires Ruby 2.6+ and is tested against Ruby 2.6 through 3.4, JRuby, and ruby-head.
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
Running tests:
bundle installbundle exec ruby test/suite.rb
Linting:
bundle exec rake standardbundle exec standardrb --fixto auto-fix issues
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 file.
Owner metadata
- Name: Zeno R.R. Davatz
- Login: zdavatz
- Email:
- Kind: user
- Description: Taking care of public domain drug data in Switzerland.
- Website: just.do
- Location: Zürich
- Twitter:
- Company: ywesee GmbH
- Icon url: https://avatars.githubusercontent.com/u/4953?v=4
- Repositories: 86
- Last ynced at: 2024-05-01T10:40:34.428Z
- Profile URL: https://github.com/zdavatz
GitHub Events
Total
- Pull request event: 5
- Fork event: 4
- Issues event: 2
- Watch event: 16
- Issue comment event: 20
- Push event: 7
- Create event: 3
Last Year
- Pull request event: 1
- Fork event: 2
- Issues event: 1
- Watch event: 9
- Issue comment event: 5
- Push event: 3
- Create event: 1
Committers metadata
Last synced: 2 days ago
Total Commits: 440
Total Committers: 73
Avg Commits per committer: 6.027
Development Distribution Score (DDS): 0.586
Commits in past year: 11
Committers in past year: 2
Avg Commits per committer in past year: 5.5
Development Distribution Score (DDS) in past year: 0.364
| Name | Commits | |
|---|---|---|
| Zeno R.R. Davatz | z****z@y****m | 182 |
| Hannes Wyss | h****s@y****m | 70 |
| Niklaus Giger | n****r@m****g | 19 |
| Mina Naguib | m****t@n****a | 12 |
| Malcolm Blyth | t****t@c****k | 11 |
| Artem Ignatiev | z****k@g****m | 9 |
| Kenichi Kamiya | k****1@g****m | 9 |
| taichi | t****0@g****m | 9 |
| Masaomi Hatakeyama | m****a@y****m | 8 |
| DeTeam | t****m@g****m | 6 |
| Nick Weiland | n****d@g****m | 6 |
| jsaak | j****k@n****u | 5 |
| Morgan Christiansson | c****e@m****e | 5 |
| VitaliyAdamkov | a****v@t****a | 4 |
| Pavel | p****t@g****m | 4 |
| Ben Woosley | b****y@g****m | 3 |
| Guillermo Guerrero | g****s@g****m | 3 |
| Leopoldo Lee Agdeppa III | l****a@g****m | 3 |
| Uraki | u****6@m****m | 3 |
| cantin | c****0@g****m | 3 |
| tom-lord | l****m@g****m | 2 |
| tetsuya-ogawa | t****7@g****m | 2 |
| b123400 | i@b****t | 2 |
| Todd Hambley | t****y@t****m | 2 |
| PikachuEXE | p****e@g****m | 2 |
| Mark Young | m****g@a****o | 2 |
| Mark Edmondson | m****n@g****m | 2 |
| Jacob Atzen | j****b@j****k | 2 |
| Alexandre Bini | a****i@g****m | 2 |
| 545ch4 | s@r****g | 2 |
| and 43 more... | ||
Committer domains:
- ywesee.com: 4
- gitter.im: 1
- infotechfl.com: 1
- garin-studio.ru: 1
- doctolib.com: 1
- rprojekt.org: 1
- jacobatzen.dk: 1
- atg.auto: 1
- travelleaders.com: 1
- b123400.net: 1
- mac.com: 1
- tex.ua: 1
- mog.se: 1
- napalm.hu: 1
- co.ck: 1
- naguib.ca: 1
- puujaa.com: 1
- murb.nl: 1
- bebanjo.com: 1
- kurioscreative.com: 1
- crowdtap.com: 1
- nestegg.com: 1
- ecoworkinc.com: 1
- benjaminfleischer.com: 1
- gilt.jp: 1
- spaghetticode.it: 1
- parelio.com: 1
- reenhanced.com: 1
- adtegrity.com: 1
- finn.de: 1
- crowdcompass.com: 1
- list.ru: 1
- member.fsf.org: 1
Issue and Pull Request metadata
Last synced: 2 months ago
Total issues: 80
Total pull requests: 37
Average time to close issues: 3 months
Average time to close pull requests: 27 days
Total issue authors: 76
Total pull request authors: 24
Average comments per issue: 5.1
Average comments per pull request: 1.68
Merged pull request: 34
Bot issues: 0
Bot pull requests: 0
Past year issues: 2
Past year pull requests: 6
Past year average time to close issues: 4 minutes
Past year average time to close pull requests: about 4 hours
Past year issue authors: 2
Past year pull request authors: 3
Past year average comments per issue: 1.5
Past year average comments per pull request: 0.33
Past year merged pull request: 5
Past year bot issues: 0
Past year bot pull requests: 0
Top Issue Authors
- dangnlg2 (2)
- MatthiasRMS (2)
- AhmedKamal20 (2)
- ghost (2)
- pomartel (1)
- dunn (1)
- brunobrgs (1)
- verboEse (1)
- shatle (1)
- Yv-vY (1)
- NySiya (1)
- varunDM (1)
- eccentricyan (1)
- gertjeza (1)
- cprodhomme (1)
Top Pull Request Authors
- ngiger (4)
- mark-young-atg (4)
- taichi-ishitani (4)
- edouard (2)
- andrew (2)
- weilandia (2)
- tom-lord (2)
- PikachuEXE (1)
- VitaliyAdamkov (1)
- 4geru (1)
- markedmondson (1)
- manxingxing (1)
- spacepotato (1)
- thambley (1)
- cyrilchampier (1)
Top Issue Labels
Top Pull Request Labels
Package metadata
- Total packages: 6
-
Total downloads:
- rubygems: 152,000,251 total
- Total docker downloads: 54,890,262
- Total dependent packages: 180 (may contain duplicates)
- Total dependent repositories: 4,920 (may contain duplicates)
- Total versions: 226
- Total maintainers: 6
gem.coop: spreadsheet
As of version 0.6.0, only Microsoft Excel compatible spreadsheets are supported
- Homepage: https://github.com/zdavatz/spreadsheet/
- Documentation: http://www.rubydoc.info/gems/spreadsheet/
- Licenses: GPL-3.0
- Latest release: 1.3.4 (published 11 months ago)
- Last Synced: 2026-03-02T06:02:54.485Z (1 day ago)
- Versions: 95
- Dependent Packages: 0
- Dependent Repositories: 0
- Downloads: 75,999,117 Total
- Docker Downloads: 27,445,131
-
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 0.284%
- Downloads: 0.388%
- Docker downloads count: 0.747%
- Maintainers (5)
-
Funding:
- https://github.com/sponsors/zdavatz
rubygems.org: spreadsheet
As of version 0.6.0, only Microsoft Excel compatible spreadsheets are supported
- Homepage: https://github.com/zdavatz/spreadsheet/
- Documentation: http://www.rubydoc.info/gems/spreadsheet/
- Licenses: GPL-3.0
- Latest release: 1.3.4 (published 11 months ago)
- Last Synced: 2026-03-02T01:02:35.010Z (2 days ago)
- Versions: 95
- Dependent Packages: 180
- Dependent Repositories: 4,920
- Downloads: 75,993,056 Total
- Docker Downloads: 27,445,131
-
Rankings:
- Dependent packages count: 0.202%
- Downloads: 0.395%
- Dependent repos count: 0.452%
- Docker downloads count: 0.847%
- Average: 0.909%
- Forks count: 1.743%
- Stargazers count: 1.815%
- Maintainers (5)
-
Funding:
- https://github.com/sponsors/zdavatz
proxy.golang.org: github.com/zdavatz/spreadsheet
- Homepage:
- Documentation: https://pkg.go.dev/github.com/zdavatz/spreadsheet#section-documentation
- Licenses: gpl-3.0
- Latest release: v1.1.3 (published over 9 years ago)
- Last Synced: 2026-02-28T11:02:43.737Z (4 days ago)
- Versions: 33
- Dependent Packages: 0
- Dependent Repositories: 0
-
Rankings:
- Forks count: 1.805%
- Stargazers count: 1.979%
- Average: 6.031%
- Dependent packages count: 9.56%
- Dependent repos count: 10.779%
gem.coop: keeguon-spreadsheet
As of version 0.6.0, only Microsoft Excel compatible spreadsheets are supported
- Homepage: https://github.com/zdavatz/spreadsheet/
- Documentation: http://www.rubydoc.info/gems/keeguon-spreadsheet/
- Licenses: GPLv3
- Latest release: 0.9.3 (published over 12 years ago)
- Last Synced: 2026-02-28T11:02:41.739Z (4 days ago)
- Versions: 1
- Dependent Packages: 0
- Dependent Repositories: 0
- Downloads: 4,039 Total
-
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 25.825%
- Downloads: 77.476%
- Maintainers (1)
rubygems.org: keeguon-spreadsheet
As of version 0.6.0, only Microsoft Excel compatible spreadsheets are supported
- Homepage: https://github.com/zdavatz/spreadsheet/
- Documentation: http://www.rubydoc.info/gems/keeguon-spreadsheet/
- Licenses: GPLv3
- Latest release: 0.9.3 (published over 12 years ago)
- Last Synced: 2026-02-28T11:02:41.718Z (4 days ago)
- Versions: 1
- Dependent Packages: 0
- Dependent Repositories: 0
- Downloads: 4,039 Total
-
Rankings:
- Forks count: 1.562%
- Stargazers count: 1.655%
- Dependent packages count: 15.706%
- Average: 28.848%
- Dependent repos count: 46.782%
- Downloads: 78.537%
- Maintainers (1)
debian-13: ruby-spreadsheet
- Homepage: https://github.com/zdavatz/spreadsheet
- Documentation: https://packages.debian.org/trixie/ruby-spreadsheet
- Licenses:
- Latest release: 1.3.3-1 (published 19 days ago)
- Last Synced: 2026-02-13T13:20:03.068Z (18 days ago)
- Versions: 1
- Dependent Packages: 0
- Dependent Repositories: 0
-
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
Dependencies
- rake >= 0 development
- simplecov >= 0 development
- test-unit >= 0 development
- ruby-ole >= 0
- actions/checkout v2 composite
- ruby/setup-ruby v1 composite
Score: 30.49435998326123