# Best way to generate complex spreadsheets with rails

**URL:** <https://www.ruby-forum.com/t/best-way-to-generate-complex-spreadsheets-with-rails/86612>\
**Category:** Rails\
**Created:** [February 23, 2007, 7:39pm UTC](https://www.ruby-forum.com/t/best-way-to-generate-complex-spreadsheets-with-rails/86612 "2007-02-23T19:39:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![acras](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/f4b2a3/32.png) [@acras](https://www.ruby-forum.com/u/acras)\
**Post date:** [February 23, 2007, 7:39pm UTC](https://www.ruby-forum.com/t/best-way-to-generate-complex-spreadsheets-with-rails/86612/1 "2007-02-23T19:39:32Z")

</div>

Hi,

We are developing a rails app where the generation of complex excel  
documents is necessary. By complex I mean a spreadsheet with formulas,  
including cross-file and cross-tab references.  
The only ruby component we’ve found is way too simple to what we need.  
What do you recomend?

Really apreciate your help.

Thanks.

–  
Ricardo A.  
removed\_email\_address@domain.invalid  
Acras Desenvolvimento de Sistemas  
+55+41-3232-6404  
[www.acras.net](http://www.acras.net)

---

<div class="post-metadata">

**Author:** ![acras](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/f4b2a3/32.png) [@acras](https://www.ruby-forum.com/u/acras)\
**Post date:** [March 12, 2007, 12:36pm UTC](https://www.ruby-forum.com/t/best-way-to-generate-complex-spreadsheets-with-rails/86612/2 "2007-03-12T12:36:17Z")

</div>

Is JRuby an option? There is a great Java library called POI for doing  
what  
you need.

[http://jakarta.apache.org/poi/](http://jakarta.apache.org/poi/)

–  
James M.  
The Ruby Roundup  
[http://rubyroundup.com/](http://rubyroundup.com/)