How to read and map xls columns

[plsHelpMe]

Hi,

I need to implement something like allowing the user to browse an xls r which is having some data and then allow the user to map the columns of that xls such that the data from a particular column is read under a predefined category, I mean something what appears when we try to import the xls data in the TOAD. Please refer the snapshot attached. In simple terms say i want to map coumns of the uploaded xls say with the fields on the html form. I am using struts 1.1. Please help me if anyone is having any input on the same.

TIA

[samido]

there is a JDBC drivers that can connect to spreadsheed like database's, google them and they will help you a lot ...? you will simply have to create DAO that can acts as a layer between your struts classes and spread sheet doc

[pronerd]

The POI project will let you access MS Office files with Java.
Apache POI - Java API To Access Microsoft Format Files

[plsHelpMe]

Hi,

Thanks for your quick reply.
For the first reply, if i would use the JDBC drivers for reading xls i wont be able to let the user supply his own xls on the fly (am i right here?).

For the second reply, i tried going to the mentioned POI website but i could not be able to download the needed Jars. Can you be pls more specific from where i can get the jars. Moreover i am using "WSAD" for the development. Would i need to have some other configurations also in order to use the POI JARS.

Thanks