fetching data from excel

swaeded's Avatar
Light Poster
My Problem is:

I am having some datas in excel sheet...

I want to fetch each row then i have to enter those values in the html page to the respective boxes...

this i have to code in java...

How to link java & excel...
0
pradeep's Avatar, Join Date: Apr 2005
Team Leader
Save the excel sheet as CSV and read it line by line!
0
wrecker's Avatar, Join Date: Mar 2007
Go4Expert Member
Try using datbase connectivity. Execute query to read data from excel sheet and then i hope tat you will get idea to add to html pages...
0
pradeep's Avatar, Join Date: Apr 2005
Team Leader
If u r on a windows system, then add a DSN using the MS Excel drive and point to your Excel workbook. Using a ODBC connection, you can import the excel data to anywhere you want!
0
AppleMan's Avatar, Join Date: Jun 2007
Newbie Member
Use POI
http://www.javaworld.com/javaworld/j...-0322-poi.html