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
Greenhorn
Joined: Aug 05, 2008
Posts: 9
posted
0
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.
R. Ben Parsons<br />SCJA
Ganesan Ramakrishnan
Ranch Hand
Joined: Mar 18, 2008
Posts: 84
posted
0
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
Greenhorn
Joined: Aug 05, 2008
Posts: 9
posted
0
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:
0
