Resources

Excel Import

duckdb.org

DuckDB supports reading Excel .xlsx files. However, .xls files are not supported. Importing Excel Sheets Use the read_xlsx function in the FROM clause of a query: SELECT * FROM read_xlsx('test_excel.xlsx'); Alternatively, you can omit the read_xlsx function and let DuckDB infer it from the extension: SELECT * FROM 'test_excel.xlsx'; However, if you want to be able to pass options to control the import behavior, you…

Visit Site

Resources duckdb.org