You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When importing an excel file (either xls or xlsx) that contains large numbers, they are converted to scientific notation.
For instance 159001810629457000 is transformed into 1.5900181062945699E+17. It might seem reasonable but it is a code not a number and I loose information. Sometimes I know there will be a (small) number in a cell and I get as a result a decimal number. Say the input is 123 and the parsed data will be 123.0 This is very similar if not the same error. It might seem that is not a problem but when I'm expecting a string that .0 creates a mess.
Thanks
The text was updated successfully, but these errors were encountered:
When importing an excel file (either xls or xlsx) that contains large numbers, they are converted to scientific notation.
For instance
159001810629457000
is transformed into1.5900181062945699E+17
. It might seem reasonable but it is a code not a number and I loose information. Sometimes I know there will be a (small) number in a cell and I get as a result a decimal number. Say the input is123
and the parsed data will be123.0
This is very similar if not the same error. It might seem that is not a problem but when I'm expecting a string that.0
creates a mess.Thanks
The text was updated successfully, but these errors were encountered: