Topic: Problem Using Jakarta POI project in Rails


I am very new to RoR. In my project I need to create Excel with some rich formatting like grouping of cells and stuff like that. I got hold of YAJB (Yet Another Java Bridge - a wrapper over Jakarta POI project). It requires static .rxls files in views.

I have to generate excel and populate it from the database based on user selection. So static .rxls files will not fulfil my need.

I have found few Plugins that help me generate excel based on User Selection but they dont have grouping of rows functionality.

Any suggestions or ideas doing that will be great help.

Thanks in advance.