duckdb-wasm icon indicating copy to clipboard operation
duckdb-wasm copied to clipboard

Cannot export files to xlsx using spatial extension

Open archiewood opened this issue 1 year ago • 3 comments

What happens?

load spatial;
COPY (SELECT 1) TO 'output.xlsx' WITH (FORMAT GDAL, DRIVER 'xlsx');

IO Error: GDAL Error (3): Failure when saving output.xlsx

To Reproduce

https://shell.duckdb.org/#queries=v0,load-spatial~,COPY-(SELECT-1)-TO-'output.xlsx'-WITH-(FORMAT-GDAL%2C-DRIVER-'xlsx')~

Browser/Environment:

Arc 1.69.0 (55816), Chromium Engine Version 131.0.6778.70

Device:

Mac OS 14

DuckDB-Wasm Version:

1.29.1-dev15.0

DuckDB-Wasm Deployment:

shell.duckdb.org

Full Name:

Archie Wood

Affiliation:

Evidence

archiewood avatar Nov 18 '24 16:11 archiewood

Just tested this and it works with the cli non wasm version

COPY table1 TO 'table1.xlsx'
WITH (FORMAT GDAL, DRIVER 'XLSX', LAYER_CREATION_OPTIONS 'WRITE_BBOX=YES');"

fkauker-fsq avatar Jan 03 '25 01:01 fkauker-fsq

But does it work on WASM?

archiewood avatar Jan 03 '25 02:01 archiewood

it not work on wasp verrsion

ausin107 avatar Mar 29 '25 02:03 ausin107