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
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads