wood burning stoves 2.0*
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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "problem in retrieving data from excel" Watch "problem in retrieving data from excel" New topic
Author

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: http://aspose.com/file-tools
 
subject: problem in retrieving data from excel
 
Similar Threads
CallableStatement resultset returns only columns and no data, where data exists.
Read Excel from JDBC.
retrieving data from a databse into an excelsheet
Download it in different sheets in Excel
what is the limitation of getString(column name)?