Meaningless Drivel is fun!
The moose likes JDBC and Relational Databases and the fly likes problem in retrieving data from excel Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "problem in retrieving data from excel" Watch "problem in retrieving data from excel" New topic

problem in retrieving data from excel

aminur rashid
Ranch Hand

Joined: Sep 21, 2001
Posts: 79
Hi . I am reading an excel file by jdbc dbc connection.While retrieving the data i am using the method resultSet.getString(column); But the problem is that if any column (say column 2)has data as String at any row(say row 3 column 2) and data as number e.g 345 in another row(row 5 column 2) then the method

is returning value null for the row 5 i.e row containing numerical data,time data etc.The data type of all the column is Text(Varchar) Can any one help me how to retrieve data from a column of Excel sheet having such datas. I have used getDouble() and all other methods of resultSet also. For more information i should say that datatype of meta data is VARCHAR(=text) Regards Aminur

Regards<br />Aminur
I agree. Here's the link:
subject: problem in retrieving data from excel
It's not a secret anymore!