Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Export JSP page to Excel

 
dheepak kumar
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ,

I have a reqirement wherein there is an export to excel funcationlity provided to users. The users can modify the downloaded excel and then upload the same.But when I click on Export to excel and then on SAve, the only file type that appears is Microsoft Excel WorkSheet.

For uploading I am using the JXL API.However it dosent seem to support Microsoft Excel WorkSheet format in excel. There is a jxl.read.BiffException thrown saying that it cannot recognize the OLE stream.It requires the Microsoft Excel WorkBook format.

Can anyone let me know if I can add the Microsoft Excel WorkBook format to the types shown when exporting to Excel.

Alternatively is there any class that I need to make use of in JXL API which will help resolve the above.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic