read_xlsx with "all_varchar = true" appends ".0" to integers.

[Miguel-Alonso]

I have an excel file with with strings ids (numbers, dots and hyphens, mostly).
Some of those ids are only numbers and, when reading the file, DuckDB appends a ".0" to those.

Is there a way to avoid this? I need the ids to stay unchanged.

For reference, I have a file with a columns like:

reference
12-3455
34-5678
12345

Doing data = DuckDbQuery("SELECT * FROM read_xlsx(?, header = true, all_varchar = true)") returns:

reference
12-3455
34-5678
12345.0

[DanIronsTR]

This issue also vexes me.