Storing into an Xcel sheet

[Asrita Saran]

Hi,
I want to know how data entered in a form can be stored in an excel sheet.

Can anyone help me?
[ August 05, 2008: Message edited by: Asrita Saran ]

[R Ben Parsons]

This isn't really a JSF question... JSF will capture the input and it's up to you what you code your action to do. It's probably quite complicated to put it into an actual Excel spreadsheet, as this would require some sort of Java/COM bridge in order to access the Excel API. It would be far easier to output the date into a text file in comma separated format (.csv), which could then be opened in Excel.

[Ganesan Ramakrishnan]

Hi,
You can use the poi.jar for writing the text into excel file. This is the open source jar from apache.

Regards
Ganesan

[R Ben Parsons]

Thanks Ganesan, I didn't know that.

Having read up, apparently POI is a Java API to access microsoft file formats, although seems to just work for Excel at the moment. You can find it at:

http://poi.apache.org/

[R Ben Parsons]

I've found another option called ActiveXLS, but this one isn't open source.

http://www.activexls.com/