Resources

Excel Export

duckdb.org

Installing the Extension To export the data from a table to an Excel file, install and load the spatial extension. This is only needed once per DuckDB connection. INSTALL spatial; LOAD spatial; Exporting Excel Sheets Then use the COPY statement. The file will contain one worksheet with the same name as the file, but without the .xlsx extension: COPY tbl TO 'output.xlsx' WITH (FORMAT GDAL, DRIVER 'xlsx'); The result…

Visit Site