Hi friends,
an excel sheet consist of 3 column
NAME ID RS
Abhishek 10 5000
karthik 10 350.56
My questions is, By using Poi jar file i get value's form each cell by using switch case like
switch(c.getCellType()){
case Cell.CELL_TYPE_STRING:
return c.getStringCellValue();
case Cell.CELL_TYPE_NUMERIC:
return String.valueOf(c.getNumericCellValue());
default:
return "Cell not found";
}
if only one column means i will type cast it but -> just consider "n" number columns having decimal value and "n" number columns having Integer value's .
like this am getting my value from excel like
my output :
Abhishek 10.0 5000.0 --> karthik 10.0 350.56
am getting Integer value as decimal value ?
there 's any solution for this i need to get integer values as integer value and decimal values as decimal values