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( "jdbcdbcriver={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.

[Json]

Could this be because the xls file has that cell formatted as a decimal number?

// Json

[nehakuls]

then how to change the cell format in excel file.....

[Json]

Is either make sure that the value you are reading is infact going to be an integer or if you want to be sneaky you can use a NumberFormat to parse the String.

NumberFormat.getIntegerInstance().parse("2001.0")

// Json

[tombstone]

I think it is better to use the JXL api for excel rather than using jdbc.
A link to the API tutorial - Java Excel API Tutorial

[jnthakar]

Hi use POI API. That is very good API for excel sheet Readign/Writing. I have used it so many time in the past.