Excel connector
Query an .xlsx workbook with SQL. Each sheet is loaded into an in-memory DuckDB
(NaN → NULL) and becomes a view, so spreadsheets answer the same SQL as a real
database.
# sources.yaml
book:
type: excel
path: data/report.xlsx
header: true # first row is the header (default true)
sheets: # optional: limit/rename which sheets load
- Sheet1
- Summary
| Key | Purpose |
|---|---|
path |
Path to the .xlsx file. |
sheets |
Which sheets to load (default: all). |
header |
Boolean: is the first row the column header? (default true). Set false to auto-name columns col0…colN. |
Then SELECT … FROM Sheet1. Install: uv add 'dashdown-md[excel]' (openpyxl).