I have an excel
*.xlsx with a cell of type
Número , the value I have in the excel is
0,0794497914814776 but the value returned by the method
I have tried to convert the cell into text before reading it, but it throws an exception:
celda.setCellType(CellType.STRING); String a = celda.getStringCellValue();
This I show was useful to read another excel, with a custom cell format.
The main problem I have is that the cell can contain 5, 10 or 15 decimals and we need to respect the value that comes in the excel.
Can you read the exact value of the cell?