Option to retain special symbols/ errors in excel as a string

ToucanToco / fastexcel

A Python wrapper around calamine

http://fastexcel.toucantoco.dev/

MIT License

120 stars 6 forks source link

Option to retain special symbols/ errors in excel as a string #229

Open durgeksh opened 7 months ago

durgeksh commented 7 months ago

Hi team, in excel, we have special symbols like #VALUE!, #DIV/0! etc. As of now, these symbols are turned into null. Can we have an option to retain them as it is as a string?

Thank you for the wonderful and performant wrapper.

PrettyWood commented 7 months ago

https://github.com/ToucanToco/fastexcel/issues/220#issuecomment-2042627835 for reference

PrettyWood commented 1 month ago

Hello @durgeksh I pushed https://github.com/ToucanToco/fastexcel/pull/293 to showcase the current behavior, which seems ok to me. If it's not can you please share a file and explain the current behavior and the desired one?