read_xlsx with "all_varchar = true" appends ".0" to integers.
- Dominant language
- C++
- Stars
- 62
- Forks
- 24
- PR merge metrics
- No merged PRs in 30d
Description
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 |
Contributor guide
No contributing guide indexed for this repository
Research direction
Start at the read_xlsx entry point and reproduce the issue with the sample reference values and all_varchar = true. Check how numeric-only Excel cells are converted to strings, then verify that values such as 12345 remain unchanged while hyphenated references still work as shown.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- cpp
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 42/100