How to fetch integer data from excel

[nehakuls]

Hi All,

I have used following query to fetch data from excel file:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection( "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=" + "C:\\file1.xls" +";"+ "DriverID=22;READONLY=false" );
Statement st = con.createStatement();
ResultSet rs = st.executeQuery( "Select * from [Sheet1$]" );
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
while (rs.next()) {
for (int i = 1; i <= numberOfColumns; i++) {
if (i > 1) System.out.print(", ");
String columnValue = rs.getString(i);
System.out.print(columnValue);
}
System.out.println("");
}

Its retrieving data from excel. But the problem is it returns decimal data even if u hv integer data in excel file.
For example I have Year as 2001 in my excel file and it returns 2001.0.

I tried to type cast it into integer but at run I can not get whether column has ineteger data or deciamal or alphanumeric data. the column id for year may change.

plz help me.

[masijade]

Use POI or jxl. Otherwise Excel has essentially 3 formats, text, date, and number (which is decimal). If you know what is "suppossed" to be in the column, and you insist on using the Bridge, then call the proper method, i.e. getInteger rather than getString.

[Tolls]

Yep.
Excel is not a database.
Don't treat it like one...

[nehakuls]

I am using jxl itself...but as we have to apply some filter criteria at run time....its quite a long process...if we have a choice using sql queries then we can do it very easily.....thats y i asked for this.....

[raqman]

In my opinion, you have to change the format of cell.

[masijade]

I am using jxl itself...but as we have to apply some filter criteria at run time....its quite a long process

Not when designed right, but that's another question/problem.