Results of 1 - 6 of about 6 for cells (0.001 sec.)
- Excel Extension 11808
- 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
...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. ignore_errors BOOLEAN false Whether to ignore errors and silently replace cells that can't be cas...t to the corresponding inferred column type with NULL 's. range VARCHAR automatically inferred The range of cells to read, in spreadsheet notation. For example, A1:B2 reads the cells from A1 to B2. If not specified the resulting range w...ill be inferred as rectangular region of cells between the first row of consecutive non-empty cells and the first empty row spanning the same columns. stop_at_empty BOOL... - https://man.mtool.work/duckdb/2.0/core_extensions/excel.html
- Excel Import 10857
- 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
...; By default, the first sheet is loaded if no sheet is specified. Importing a Specific Range To select a specific range of cells, use the range parameter with a string in the format A1:B2 , where A1 is the top-left cell and B2 is the bottom-right cell...sx', range = 'E:Z'); If no range parameter is provided, DuckDB automatically infers the range as the rectangular region of cells between the first row of consecutive non-empty cells and the first empty row spanning the same columns. By default, if no...an Excel file into an existing table, the types of the columns in the target table will be used to coerce the types of the cells in the Excel sheet. Importing a Sheet with/without a Header To treat the first row as containing the names of the resultin... - https://man.mtool.work/duckdb/2.0/guides/file_formats/excel_import.html
- marimo Notebooks 9962
- marimo is an open-source reactive notebook for Python and SQL that's tightly integrated with DuckDB's Python client, letting you mix and match Python and SQL in a single git-versionable notebook. Unlike traditional notebooks, when you run a
...cell or interact with a UI element, marimo automatically (or lazily) runs affected cells, keeping code and outputs consistent. Its integration with DuckDB makes it well-suited to interactively working with data,...tutorial: marimo tutorial sql SQL in marimo Create a notebook from your terminal with marimo edit notebook.py . Create SQL cells in one of three ways: Right-click the + button and pick SQL cell Convert any empty cell to SQL via the cell menu Hit the S...QL button at the bottom of your notebook In marimo, SQL cells give the appearance of writing SQL while being serialized as standard Python code using the mo.sql() function, which keeps... - https://man.mtool.work/duckdb/2.0/guides/python/marimo.html
- Excel Export 7457
- 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
...rmat" applied to make them appear as TRUE and FALSE in Excel. All other types are cast to VARCHAR and then written as text cells. But you can of course also explicitly cast columns to a different type before exporting them to Excel: COPY (SELECT CAST(... - https://man.mtool.work/duckdb/2.0/guides/file_formats/excel_export.html
- Agent Mode 7421
- New Agent mode was introduced in DuckDB 2.0. Agent mode renders the CLI's output for consumption by an AI coding agent rather than a human at a terminal. It produces compact Markdown tables with explicit result limits, machine-readable erro
...10,000 bytes is rendered whole; a larger result is rendered as its first and last rows together with the total row count. Cells are truncated at 500 characters. These limits can be adjusted with dot commands : Dot command Description .maxrows ⟨count⟩... - https://man.mtool.work/duckdb/2.0/clients/cli/agent_mode.html
- Jupyter Notebooks 7275
- DuckDB's Python client can be used directly in Jupyter notebooks with no additional configuration, as the first section shows. Additional libraries can simplify SQL query development; the rest of this guide uses the JupySQL package. See oth
...upysql will auto-detect the driver needed based on the connection string! # Import jupysql Jupyter extension to create SQL cells %load_ext sql Either connect to a new in-memory DuckDB or a file-backed database: %sql duckdb:///:memory: %sql duckdb:///p... - https://man.mtool.work/duckdb/2.0/guides/python/jupyter.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work