Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Is it possible to force the library to ignore all the data types that XLSX ..? #20

Open
EOM opened this issue Jun 26, 2024 · 1 comment

Comments

@EOM
Copy link

EOM commented Jun 26, 2024

Hi, very good library, it works very well.
My question is, is it possible to force the library to ignore all the data types that XLSX has, so that all the cells are taken as a literal string, regardless of whether it was saved as a date, currency, decimal, etc.
Since I did not find a way to do it.
Thanks

@adirfische
Copy link
Contributor

Greetings,

First off: No, this is not an option right now.

The main reason for it is that XLSX file editors generally like storing everything as a number internally; even including strings.
So while the reader could just hand you the raw cell value "42", that wouldn't really tell you anything without any further context. "42" could mean "The string with the id 42, which is 'Hello World'", or it could mean "the datetime corresponding to 42, which is 1900-02-11 00:00:00", or it could actually just be the number 42. So it always seemed ill-advised to allow outputting the raw value like that.

Maybe it'd help if you described your use-case. What are you trying to accomplish?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants