openpyxl
openpyxl copied to clipboard
OpenPyxl understands big number strings ending in 0 as float
I have a few sheets containing phone numbers, and some are written without the proper format (e.g. 10912345678
instead of (10)91234-5678
). When I load the sheet from openpyxl
, strings ended in 0
(e.g. 10912345670
) are read as float (1091234567.0
) instead of an integer or simply leaving them as strings.
(I'll provide more details/example, just opening quickly so I don't forget about it later.)