I have an xlsx file where the cells are "formatted" to show 2 decimal places.
When I read in this file via XlsxReadOptions, only 2 decimal places are being parsed. e.g. 12.123 -> 12.12
Code:
XlsxReadOptions options = XslxRaedOptions.builder(filePath)
.columnTypes(x -> ColumnType.STRING)
.missingValueIndicator(indicators)
.build();
Table table = Table.read().usingOptions(options);
I have an xlsx file where the cells are "formatted" to show 2 decimal places.
When I read in this file via XlsxReadOptions, only 2 decimal places are being parsed. e.g.
12.123->12.12Code: