How to load excel data to jsp/java?

[wayne]

Hi,

Does anyone know how to load (input) one or 2 catagories of MS Excel
data (1 is id, 2 is value for example) into HTML (jsp) forms to serve
as text input, so that the next page can receive and process
parameters?

Or alternatively, direct load the data to the java code to process?

The purpose is to substitute the current multiple text inputs (some
times goes with hundreds of them), which is annoy and inaccurate.

Thanks a lot,
Wayne

 

[Marko Lahma]

Have a look at http://jakarta.apache.org/poi/ for excel file reading
with Java.

-Marko

 

[Marco Schmidt]

wayne:

Does anyone know how to load (input) one or 2 catagories of MS Excel
data (1 is id, 2 is value for example) into HTML (jsp) forms to serve
as text input, so that the next page can receive and process
parameters?

See
<http://www.geocities.com/marcoschmidt.geo/java-libraries-excel.html>.

Regards,
Marco

 

[RGonzalez]

I have done this using Apache POI at

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