aspose file tools*
The moose likes JDBC 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

Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
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
It is sorta covered in the JavaRanch Style Guide.
subject: problem in retrieving data from excel