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