Export JSP page to Excel

[dheepak kumar]

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.