• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Storing into an Xcel sheet

 
Asrita Saran
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 90
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I've found another option called ActiveXLS, but this one isn't open source.

http://www.activexls.com/
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic