duckdb / duckdb/duckdb-java

duckdb read_xlsx new line

Open
#297 1 comment 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.