Which gem support Import/Export to xlsx file in ruby

ruby excel export-to-excel xlsx
user569445 picture user569445 · Jan 10, 2011 · Viewed 29.2k times · Source

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?

Answer

Jedidiah Hurt picture Jedidiah Hurt · Mar 20, 2012

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.

Related questions

Writing to excel files in ruby using roo gem

I am parsing Excel and Excelx file using Roo gem. But I am not sure how to write in those files. set_value(row, column, text) method is not working. Code @oo = Excelx.new('tes.xlsx') @oo.default_sheet = @oo.…

Read More
How to convert MS excel date from float to date format in Ruby?

Trying to parse and XLSX file using roo gem in a ruby script. In excel dates are stored as floats or integers in the format DDDDD.ttttt, counting from 1900-01-00 (00 no 01). So in order to convert a date such …

Read More
Trim a trailing .0

I have an Excel column containing part numbers. Here is a sample As you can see, it can be many different datatypes: Float, Int, and String. I am using roo gem to read the file. The problem is that roo …

Read More