Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

GDAL IO Error when processing XLSX file with st_read #3

Open
CHRISCARLON opened this issue Jan 1, 2025 · 1 comment
Open

GDAL IO Error when processing XLSX file with st_read #3

CHRISCARLON opened this issue Jan 1, 2025 · 1 comment
Assignees
Labels
bug Something isn't working help wanted Extra attention is needed

Comments

@CHRISCARLON
Copy link
Member

Loading fails for XLSX files with invalid row error.

CMC duckdb-gridwalk (main ✎2) -> cargo run
    Finished `dev` profile [unoptimized + debuginfo] target(s) in 0.57s
     Running `target/debug/duckdb-postgis`
Detected file type: Excel for file: 'ukpn-secondary-sites.xlsx'
Error: Custom { kind: Other, error: "Error processing Excel file 'ukpn-secondary-sites.xlsx': IO Error: GDAL Error (1): Invalid row: 0" }

Next steps:

  • Reproduce this error with other xlsx files
  • Raise issue with duckdb

Solutions attempted:

  • I have already attempted to set the open_optios to "FORCE" in the duckdb cli and this does not work - same error occurs.
create table ukpn as
    select * from st_read(
      'ukpn-secondary-sites.xlsx',
      open_options=['HEADERS=FORCE']
  );

IO Error: GDAL Error (1): Invalid row: 0
@CHRISCARLON CHRISCARLON added bug Something isn't working help wanted Extra attention is needed labels Jan 1, 2025
@CHRISCARLON CHRISCARLON self-assigned this Jan 1, 2025
@CHRISCARLON
Copy link
Member Author

Raised issued here on duckdb-rs repo: duckdb/duckdb-rs#419 (comment)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working help wanted Extra attention is needed
Projects
None yet
Development

No branches or pull requests

1 participant