Skip to content

read_xlsx column names with new line #59

@dareklima

Description

@dareklima

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 in dbeawer:
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: 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"
Have any of you encountered such a problem and solved it?
Pozdrawiam

Raport_20250621233652.xlsx

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions