Entering edit mode
2.2 years ago
Kubendra
•
0
Loading instrument data into a Java application using Excel (XLSX format) - the actual value in XLSX file and the value being loaded is different say for example value in file is 81.6 but loaded value to the application is 81.5999999999999
Right now we're taking the java object and doing (""+object) which honestly should be the same thing as toString except it handles nulls better.
if we convert XLSX file into CSV it's working as expected. if we open TSV/CSV file in Microsoft excel , excel auto detects and assign data type (Numeric, Scientific, General etc..) and assign to each cell. Even after formatting all cells to Text still the cell type is decimal instead of text when reading through java code. Any thoughts/Recommendations?
this is not really related to the subject of this forum. You should ask stackoverflow.