Best way to generate complex spreadsheets with rails

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.

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

http://jakarta.apache.org/poi/