I need to read and write to Excelx file with ruby code, Tried with spreadsheet it does not support xlsx format, Roo is also to read the file and not write to xlsx.
Is there any gem/plugin which will write to Excelx?
-
See also Ruby Toolbox for a list of related libraries.Franklin Yu– Franklin Yu2019-02-19 16:26:17 +00:00Commented Feb 19, 2019 at 16:26
Add a comment
|
9 Answers
For the task of writing/exporting xlsx files, Axlsx is the most feature complete library I've found. It does not support reading/importing xlsx files, though.
https://github.com/randym/axlsx
Here's the author's description:
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.
6 Comments
Jedidiah Hurt
Morgan Christiansson
The library is write only and doesn't support reading existing xlsx files at all. :-(
Jedidiah Hurt
@morganchristiansson You're right. I hadn't noticed as I only need writing. Sorry for the confusion :(
Akash Kumar
Axlsx gem is very good and seems fully feature
Stéphane
This gem doesn't seem to be supported any more, last version was in 2015. Pay attention that it exposes your project to a vulnerability in rubyzip gem. See github.com/randym/axlsx/issues/536
|
You can try this gem
And
1 Comment
jwadsack
As a note,
simple_xlsx_writer has "no formatting or styles included". writeexcel write old-style xls files, not xlsx format.seems RubyXL does both, read AND write https://github.com/gilt/rubyXL haven't used it yet though..
Comments
An XLSX file is essentially a zipped collection of XML files. If you don't find suitable gem, you may try generating them manually using Ruby, possibly using an empty template saved from Excel. We used to do that, worked pretty well, unfortunately that code is not open-sourced.
But eventually, we needed more control over how the result looks so we made .NET based solution with Excel automation.
answered Jan 10, 2011 at 13:08
Mladen Jablanović
44.2k13 gold badges92 silver badges113 bronze badges
Comments
I have found a lot of success utilizing WIN32OLE with excel. I always find myself back at rubyonwindows.blogspot.com for examples.
Comments
Adding to the list of above gems, Roo(https://github.com/roo-rb/roo) is a popular ruby gem that is used to manage and work with excel and xlsx files.
1 Comment
Sergio Tulentsev
Judging from their readme, it's read-only access.
I found the interfaces of all the existing ruby excel libraries to be very un-ruby-like, and especially inaccurate when determining cell types when reading files.
So, if you're looking for something that's (IMO) simpler, I've successfully used the combination of simple_xlsx_reader and simple_xlsx_writer.
I'm the author of simple_xlsx_reader, and as of the time of this writing I don't have tests in simple_xlsx_reader that assert all use cases for reading files generated by simple_xlsx_writer, so I can't say it's fully supported, but I can say I've deployed a production application that used both libraries back-to-back for various integration tests, without issue.
Comments
Check with this gem, i is very useful to generate any difficult format/layout gem 'axlsx' , github: 'randym/axlsx', branch: 'master' and refer these link's for Documentationaxlsx-documentation
Comments
To export (csv & xslx) without any gem we can use-
https://gorails.com/episodes/export-to-csv
This link shows how to export in csv, below is how we can get xlsx.
- open controller
find method which calling to_csv method,
send_data @models.to_csv, filename: "Contract-#{Date.today}.csv"
write as-
send_data @models.to_csv, filename: "Contract-#{Date.today}.xlsx"
That worked for me!!!
Comments
