How to process excel file using jsp?

[porkymin]

Hi all,

I have a scenario described as follows but i am not sure whether is there any solution for jsp on this:

1) Is it possible to upload excel file into web?
2) Upon uploading, can we display the contents in the excel file onto the web using jsp?
3) Suppose there are formulas in the excel sheet which computes certain values, are we able to display the results instead of the formulas?

Can the above be done using jsp?

Any kind help is greatly appreciated. Need some guidance on how to go abt doing this.

 

[Diancecht]

I think it's possible, take a look at this:

http://jakarta.apache.org/poi/

Cheers,
Dian

 

[lovekang]

actually I've done similar work a couple of months ago.
as Diancecht said, with apache poi you can parse MS Excel sheets.
visit

http://jakarta.apache.org/poi/hssf/quick-guide.html

and you can upload local files using apache common fileupload.
visit

http://jakarta.apache.org/commons/fileupload/

I haven't tried case3, but it's possible I think.

good luck