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?

Answer 1

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

Answer 2

I have come across the gem simple_xlsx_writer.

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

Hope it helps.

Answer 3

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.

Answer 4

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

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