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 in my case, I have acolumn that has got both pure numeric(12345) and purely alphanumeric(testing) type of data.
resultSet.getString(column);
is returning value null for the cell 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. Regards
Aminur
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 in my case, I have acolumn that has got both pure numeric(12345) and purely alphanumeric(testing) type of data. resultSet.getString(column);
is returning value null for the cell 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. Regards
Aminur