dimastbk / python-calamine

Python binding for Rust's library for reading excel and odf file - calamine.
https://pypi.org/project/python-calamine/
MIT License
279 stars 6 forks source link

Some suggestions #90

Open Rex859619 opened 2 weeks ago

Rex859619 commented 2 weeks ago

I'm not familiar with rust and having some problems with this proj.

Sometimes an integer in a table is incorrectly converted to a floating point number. Are there future plans to provide a string-only schema without data conversion?

Also, can I skip the empty lines in the middle of the sheet?

dimastbk commented 2 weeks ago

Hi.

Sometimes an integer in a table is incorrectly converted to a floating point number.

All numbers in Excel are stored as floats, so it's hard to detect the type of number with 100% success. Could you give an example file with this problem?

Also, can I skip the empty lines in the middle of the sheet?

No, and I don't have a plan to add this feature.