Skip to content

Big numbers are converted to Scientific Notation #44

@nriesco

Description

@nriesco

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions