fetching data from excel

Light Poster
26Apr2007,14:53   #1
swaeded's Avatar
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...
Team Leader
26Apr2007,19:02   #2
pradeep's Avatar
Save the excel sheet as CSV and read it line by line!
Go4Expert Member
20May2007,15:54   #3
wrecker's Avatar
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...
Team Leader
20May2007,17:38   #4
pradeep's Avatar
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!
Newbie Member
28Jun2007,20:09   #5
AppleMan's Avatar
Use POI
http://www.javaworld.com/javaworld/j...-0322-poi.html