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

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.