Java - Excel - Oracle

Hi,

I am working on a project in which i have to achieve the following :-

Excel sheet cells must be read and stored in an Oracle database.

Excel sheets are manual filled by users of concerned department

ex Excel sheet shows above column (Example.xls)

Fruit NameQuantityCost

Mango212

Pear 418

I want that on running java gui ther is a swing button.

On pressing this button an excel instance open.

User select the file say for ex as on top (Example.xls)

There is one more button "Process".

On pressing this button,cells are read and stored in database

having attributes and matching datatype.

Please give me start .... as i am not aware of any such class which can be used to pick excel cells.

[782 byte] By [Adi1000a] at [2007-10-2 15:58:16]
# 1
Any reply to this.
Adi1000a at 2007-7-13 16:22:32 > top of Java-index,Java Essentials,Java Programming...
# 2
See Tool at http://simtel.net/product.php[id]93010[SiteID]simtel.net
vitallisa at 2007-7-13 16:22:32 > top of Java-index,Java Essentials,Java Programming...
# 3
Hello I am working in java I want to convert excel data using oracel usingjsp.I want to validate excel data such as field is numeric or alpha numeric.please send me the code
deshpandeamitr@gmail.coma at 2007-7-13 16:22:32 > top of Java-index,Java Essentials,Java Programming...