JXL api issue: Standard out displays rounded off decimal instead of actual number

Question

When I try and print out the content in a cell containing a number with five decimal places, the number is automatically rounded off to 3 d.p. This is what I have so far:

Cell cellNum = sheet1.getCell(col,row);
            WritableCell cell = sheet1.getWritableCell(col, row); 
            if (cell.getType() == CellType.NUMBER){
                cellNum = sheet1.getCell(col,row);
                NumberFormat fivedps = new NumberFormat("#.#####"); 
                WritableCellFormat cellFormat = new WritableCellFormat(fivedps); 
                cell.setCellFormat(cellFormat);


                String cellContent = cellNum.getContents();
                System.out.print(cellContent + "\t");
            }
            else{
              //  Cell cellNum = sheet1.getCell(col,row);

                String cellContent = cellNum.getContents();
                System.out.print(cellContent + "\t");

score 0 · Accepted Answer · answered Dec 30 '17 at 07:32

After checking for the Cell type and if it is of type number, then cast the Cell to NumberCell for reading it's value. For the example you shared, it should be something like this:

if (cell.getType() == CellType.NUMBER){
    NumberCell cellNum = (NumberCell) sheet1.getCell(col,row);
    System.out.println(cellNum.getValue()); //this will return a double value 
 }

You can use similar techniques to read other values such as Date by casting it to DateCell. Hope this helps!

Thank you so much. It worked! The values displayed are same as those in the spreadsheet. — Paul O., Dec 30 '17 at 09:35

JXL api issue: Standard out displays rounded off decimal instead of actual number

1 Answers1