duckdb read_xlsx new line
- Dominant language
- C++
- Stars
- 127
- Forks
- 80
- Avg merge
- 13h 49m
- Merged PRs (30d)
- 48
Description
Dzień dobry.
I have the report file in xlsx. in which there are column names with a newline character e.g. : "Data ważności
od","Data ważności
do"
when I try to read the file using sql duckdb in dbeaver:
SELECT "Data ważności
od", "Data ważności
do"
FROM read_xlsx('Raport_20250621233652.xlsx', sheet='Personel');
I get this message.
SQL Error: java.sql.SQLException: Binder Error: Referenced column "Data ważności
od" not found in FROM clause!
Candidate bindings: "Data ważności
od", "Data ważności
do", "Zawód/specjalność
Kod", "Typ dostępności", "Numer pozycji
umowy"
LINE 1: SELECT "Data ważności
^
duckdb itself using cli reads the indicated sql command properly. I think this is a JDBC driver problem.
Have any of you encountered such a problem and solved it?
Pozdrawiam
[Raport_20250621233652.xlsx](https://github.com/user-attachments/files/21068262/Raport_20250621233652.xlsx)
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.