This is a test version of Biostars. For the public version, visit https://www.biostars.org.
Reading Instrument Data from XLSX and loading into an Application Using Java

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?

java data excel instrument
• 873 views • link
updated by Pierre Lindenbaum Pierre Lindenbaum • written by Kubendra • Kubendra

this is not really related to the subject of this forum. You should ask stackoverflow.

• 0 views • link
written by Pierre Lindenbaum Pierre Lindenbaum

0 answers

No answers yet.

Log in to answer this question.

More posts like this