Generating Excel documents with Ruby

Question

I need to generate Excel documents with Ruby (from Rails) on a Linux machine. I know of Spreadsheet::Excel, but it doesn't support formulas, and uses a pretty old format.

Is there any other option, not necessarily free or open source, that is a bit more powerful?

http://stackoverflow.com/questions/6053240/how-should-i-capitalize-ruby — Andrew Grimm, Sep 06 '11 at 22:57

score 6 · Accepted Answer · answered Feb 09 '10 at 09:40

6

How about opening a spreadsheet (Spreadsheet::Excel) with the formulae already populated. Entering data into the referenced cells will cause them to display the result.

answered Feb 09 '10 at 09:40

tsdbrown

5,038
3
36
40

that, my friend, is an awesome idea I somehow hadn't thought of! My thanks. – luca Feb 09 '10 at 10:11

score 3 · Answer 2 · edited Oct 11 '15 at 17:29

3

How about https://github.com/randym/axlsx

This gem can easily generate spreadsheets in the OOXML format (Open Office XML)

edited Oct 11 '15 at 17:29

Igor Ševo

5,459
3
35
80

answered Aug 11 '12 at 21:54

Jeroen van Ingen

31
1

score 1 · Answer 3 · answered Aug 18 '12 at 05:30

1

I have come across the gem simple_xlsx_writer.

You can see the example of how to use it over here.

Hope it helps.

answered Aug 18 '12 at 05:30

maniempire

791
11
12

score 1 · Answer 4 · answered Sep 03 '11 at 20:46

1

https://github.com/cxn03651/writeexcel/

answered Sep 03 '11 at 20:46

fl00r

82,987
33
217
237

Generating Excel documents with Ruby

4 Answers4

Linked