[SOLVED] jExcel getting cell content missing

jExcel getting cell content missing

I read excel file correctly.For example my cell content is 0,987654321 in excel file.When I read it with jExcel api i reads just few chars of cell.For example 0,987.

here is my read excel code part:

 Cell A = sheet.getCell(1, 1);
 String stringA = A.getContents().toString();

How can I fix that problem.I want all content of cell.

Solution

getContents() is a basic routine to get the cell's content as a string. By casting the cell to the appropriate type (after testing that it's the expected type) you get access to the raw numeric value contained, like this

if (A.getType() == CellType.NUMBER) {
    NumberCell nc = (NumberCell) A;
    double doubleA = nc.getValue();
    // this is a double containing the exact numeric value that was stored 
    // in the spreadsheet
}

The key message here is: you can access any type of cell by casting to the appropriate subtype of Cell.
All this and a lot more is explained in the jexcelapi tutorial