feature request: na_filter/na_values equivalent

tafia / calamine

A pure Rust Excel/OpenDocument SpreadSheets file reader: rust on metal sheets

MIT License

1.6k stars 155 forks source link

feature request: na_filter/na_values equivalent #410

Open jsimon1080 opened 4 months ago

jsimon1080 commented 4 months ago

Hi,

I am using the calamine engine with the Polars python Library and I noticed that "None" values in my Excel files are being converted to null values. This is probably fine in general, but in my case I need to preserve "None" as a string value and actually only interpret empty cells as null values.

Is there any plan to add some options to control the interpretation of null values, for example "na_filter" and "na_values" as with pandas and openpyxl?

Thank you.

tafia commented 3 months ago

There is no such plan but I'd be happy to merge such PR if anyone wants it.