Results of 1 - 10 of about 12 for excel (0.001 sec.)
- Excel Import 12204
- 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 pass options to control the import behavior, you should use the read_xlsx functi...on. One such option is the sheet parameter, which allows specifying the name of the Excel worksheet: SELECT * FROM read_xlsx('test_excel.xlsx', sheet = 'Sheet1'); By default, the first sheet is loaded if no sheet...string in the format A1:B2 , where A1 is the top-left cell and B2 is the bottom-right cell: SELECT * FROM read_xlsx('test_excel.xlsx', range = 'A1:B2'); For example, to skip the first 5 rows: SELECT * FROM read_xlsx('test_excel.xlsx', range = 'A5:Z')... - https://man.mtool.work/duckdb/2.0/guides/file_formats/excel_import.html
- Excel Export 12063
- 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 Excel
...ORMAT 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 writ...e the column names as the first row in the Excel file, use the HEADER option: COPY tbl TO 'output.xlsx' WITH (FORMAT xlsx, HEADER true); To name the worksheet in the resul...ting Excel file, use the SHEET option: COPY tbl TO 'output.xlsx' WITH (FORMAT xlsx, SHEET 'Sheet1'); Type Conversions Because Excel o... - https://man.mtool.work/duckdb/2.0/guides/file_formats/excel_export.html
- Excel Extension 11337
- 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
...he excel extension will be transparently autoloaded on first use from the official extension repository. If you would like to insta...ll and load it manually, run: INSTALL AND LOAD excel; Excel Scalar Functions Function Description excel_text(number, format_string) Format the given number per the rules given...in the format_string text(number, format_string) Alias for excel_text Examples SELECT excel_text(1_234_567.897, 'h:mm AM/PM') AS timestamp; timestamp 9:31 PM SELECT excel_text(1_234_567.8... - https://man.mtool.work/duckdb/2.0/core_extensions/excel.html
- Guides 8154
- The guides section contains compact how-to guides that are focused on achieving a single goal. For API references and examples, see the rest of the documentation. Note that there are many tools using DuckDB, which are not covered in the off
...to a DuckDB database over HTTPS or S3 JSON Files How to load a JSON file into a table How to export a table to a JSON file Excel Files How to load an Excel file into a table How to export a table to an Excel file Querying Other Database Systems Databa... - https://man.mtool.work/duckdb/2.0/guides/overview.html
- Core Extensions 8065
- 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
...elta Delta Lake 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... - https://man.mtool.work/duckdb/2.0/core_extensions/overview.html
- Data Sources 7994
- DuckDB supports several data sources, including file formats, network protocols, and database systems: AWS S3 buckets and storage with S3-compatible API Azure Blob Storage Blob files Cloudflare R2 CSV Delta Lake DuckLake Excel httpfs Iceber
... - https://man.mtool.work/duckdb/2.0/data/data_sources.html
- Safe Mode 7800
- The DuckDB CLI client supports “safe mode”. Safe mode can be enabled from the command line using the -safe argument : duckdb -safe Alternatively, it can be activated during a session using the .safe_mode dot command . In safe mode, the CLI
...from interacting with the host file system. This has the following effects: The following dot commands are disabled: .cd .excel .import .log .once .open .output .read .sh .system Auto-complete no longer scans the file system for files to suggest as a... - https://man.mtool.work/duckdb/2.0/clients/cli/safe_mode.html
- Rust Client 7800
- Installation To use the DuckDB Rust client, visit the Rust installation page . The latest stable version of the DuckDB Rust client is 2.0.0. The DuckDB Rust client, duckdb-rs , is an ergonomic wrapper over the DuckDB C API that exposes an i
...ions for uuid::Uuid . Umbrella Features Feature Enables vtab-full vtab-arrow and appender-arrow , plus the deprecated vtab-excel . extensions-full json , parquet and vtab-full . modern-full chrono , serde_json , url , r2d2 , uuid , polars and rust_dec...imal . Deprecated Features Feature Enables vtab-excel A no-op retained for feature compatibility. vtab-loadable Superseded by loadable-extension . Further Reading Connect — ope... - https://man.mtool.work/duckdb/2.0/clients/rust/overview.html
- Load Extensions 7800
- Overview DuckDB-Wasm's (dynamic) extension loading is modeled after regular DuckDB's extension loading, with a few relevant differences due to the difference in platform. A growing subset of core, community, and external extensions is suppo
...used with DuckDB-Wasm include: Extension name Description Aliases autocomplete Adds support for autocomplete in the shell excel Adds support for Excel-like format strings fts Adds support for Full-Text Search indexes icu Adds support for time zones,... - https://man.mtool.work/duckdb/2.0/clients/wasm/extensions.html
- Dot Commands 7623
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...off .edit Open an external text editor to edit a query. \e can be used as an alias. See the external editor mode section .excel Display the output of the next command in a spreadsheet. Equivalent to .once -x .exit ⟨CODE⟩ Exit this program with return.... This is useful for more detailed inspection of query results, especially if there is a relatively large result set. The .excel command is equivalent to .once -x . .once -e SELECT 'quack' AS hello; The results then open in the default text file edito... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
DuckDB 2.0 Documentation / man.mtool.work