Resources

Excel Import

duckdb.org

Installing the Extension To read data from an Excel file, install and load the spatial extension. This is only needed once per DuckDB connection. INSTALL spatial; LOAD spatial; Importing Excel Sheets Use the st_read function in the FROM clause of a query: SELECT * FROM st_read('test_excel.xlsx'); The layer parameter allows specifying the name of the Excel worksheet. SELECT * FROM st_read('test_excel.xlsx', layer = '…

Visit Site

Resources duckdb.org