Spreadsheet
Roo
Our great sponsors
Spreadsheet | Roo | |
---|---|---|
1 | 2 | |
1,121 | 2,760 | |
- | 0.3% | |
5.2 | 4.1 | |
3 months ago | 18 days ago | |
Ruby | Ruby | |
GNU General Public License v3.0 only | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Spreadsheet
-
I need help..an old firm has cobol system with terminals, is there a way to extract data in that to Excell or anything?
"spreadsheet" to write to Excel. See https://rubygems.org/gems/spreadsheet
Roo
-
Question for WPS
For reading Excel files, we use roo. Our needs are more focused on simply extracting data from the files, so we don't need anything that can modify the files directly.
-
Massive SQL import from csv file, nulls, best practices.
Have you tried the Roo gem?
What are some alternatives?
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.
rubyXL - Ruby lib for reading/writing/modifying .xlsx and .xlsm files
write_xlsx - Rubygem for create excel xlsx file
Creek - Ruby library for parsing large Excel files.
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.
Fastsheet - Fast XLSX reader for ruby
Yomu - Read text and metadata from files and documents (.doc, .docx, .pages, .odt, .rtf, .pdf)
docx - a ruby library/gem for interacting with .docx files
xsv - High performance, lightweight .xlsx parser for Ruby that provides nothing a CSV parser wouldn't