duckdb-wasm
duckdb-wasm copied to clipboard
Cannot export files to xlsx using spatial extension
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
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');"
But does it work on WASM?
it not work on wasp verrsion