aspose file tools*
The moose likes JSF and the fly likes Storing into an Xcel sheet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSF
Bookmark "Storing into an Xcel sheet" Watch "Storing into an Xcel sheet" New topic
Author

Storing into an Xcel sheet

Asrita Saran
Greenhorn

Joined: Jul 11, 2007
Posts: 14
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
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: 90
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
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
Greenhorn

Joined: Aug 05, 2008
Posts: 9
I've found another option called ActiveXLS, but this one isn't open source.

http://www.activexls.com/
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Storing into an Xcel sheet