Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

problem in retrieving data from excel

 
aminur rashid
Ranch Hand
Posts: 79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic