4

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?

Improve this question
1

4 Answers 4

Reset to default
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.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

that, my friend, is an awesome idea I somehow hadn't thought of! My thanks.
3

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

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

Improve this answer

Comments

1

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

Improve this answer

Comments

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.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.