How to read Raw value rather then the formatted value from the excel sheet using POI library using XSSFReader class

32 Views Asked by At

They are using the XSSFReader to read the sheet:

XSSFReader.SheetIterator iterator = (XSSFReader.SheetIterator)xssfReader.getSheetsData();

And then they are using override method:

@Override
public void cell(String cellReference, String formattedValue, XSSFComment comment) {
    parseCell(cellReference, formattedValue, currentRow, currentData, sheetName);
}

In this formattedValue is getting the value 1.12.

I need to get 1.1234 instead. How to get that?

I need to read the raw data.

0

There are 0 best solutions below