Results of 1 - 4 of about 4 for xlsx (0.001 sec.)
- Excel Import 10855
- 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 r
...ead_xlsx function and let DuckDB infer it from the extension: SELECT * FROM 'test_excel.xlsx'; However, if you want to be able to p...ass options to control the import behavior, you should use the read_xlsx function. One such option is the sheet parameter, which allows specifying the name of the Excel worksheet: SELECT * FROM r...ead_xlsx('test_excel.xlsx', sheet = 'Sheet1'); By default, the first sheet is loaded if no sheet is specified. Importing a Specific... - https://man.mtool.work/duckdb/2.0/guides/file_formats/excel_import.html
- Excel Extension 10004
- The excel extension provides functions to format numbers per Excel's formatting rules by wrapping the i18npool library and to read/write Excel ( .xlsx ) files. However, please note that .xls files are not supported. Installing and Loading T
...m AM/PM') AS timestamp; timestamp 9:31 PM SELECT excel_text(1_234_567.897, 'h AM/PM') AS timestamp; timestamp 9 PM Reading XLSX Files Reading a .xlsx file is as simple as just SELECT ing from it immediately, e.g.: SELECT * FROM 'test.xlsx'; a b 1.0 2....0 3.0 4.0 However, if you want to set additional options to control the import process, you can use the read_xlsx function instead. The following named parameters are supported. Option Type Default Description header BOOLEAN automatical...st row as containing the names of the resulting columns. sheet VARCHAR automatically inferred The name of the sheet in the xlsx file to read. Default is the first sheet. all_varchar BOOLEAN false Whether to read all cells as containing VARCHAR s. ign... - https://man.mtool.work/duckdb/2.0/core_extensions/excel.html
- Excel Export 10004
- DuckDB supports exporting data to Excel .xlsx files via the excel extension. Please note that .xls files are not supported. To install and load the extension, run: INSTALL excel; LOAD excel; Exporting Excel Sheets To export a table to an Ex
...cel file, use the COPY statement with the FORMAT xlsx option: COPY tbl TO 'output.xlsx' WITH (FORMAT xlsx); The result of a query can also be directly exported to an Excel file...: COPY (SELECT * FROM tbl) TO 'output.xlsx' WITH (FORMAT xlsx); Or: COPY (SELECT * FROM tbl) TO 'output.xlsx'; To write the column names as the first row in the Exce...l file, use the HEADER option: COPY tbl TO 'output.xlsx' WITH (FORMAT xlsx, HEADER true); To name the worksheet in the resulting Excel file, use the SHEET option: COPY tbl TO 'ou... - https://man.mtool.work/duckdb/2.0/guides/file_formats/excel_export.html
- Core Extensions 6084
- List of Core Extensions Name Description Maintainer Support tier Aliases autocomplete Autocompletion for CLI client DuckDB team avro Avro files reading DuckDB team aws AWS S3 functionality DuckDB team azure Filesystem abstraction for Azure
...format DuckDB team ducklake DuckLake format DuckDB team encodings Read CSVs in 1000+ encodings DuckDB team excel Excel ( .xlsx ) read/write DuckDB team fts Full-text search DuckDB team httpfs HTTP(S) and S3 - file read/write operations DuckDB team h... - https://man.mtool.work/duckdb/2.0/core_extensions/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work