Thread: How to fetch integer data from excel

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.

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

// Json

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

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

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

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