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.
When importing an excel file (either xls or xlsx) that contains large numbers, they are converted to scientific notation.
For instance
159001810629457000is 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 is123and the parsed data will be123.0This is very similar if not the same error. It might seem that is not a problem but when I'm expecting a string that.0creates a mess.Thanks