# QueryTables

Use `querytable` for worksheet QueryTables backed by the desktop Excel COM object model.

## Choose the Right Import Surface

| Need | Tool |
|------|------|
| Direct text/CSV import with delimiter and encoding control | `querytable create-text` |
| Legacy HTML page/table import through Excel's web-query engine | `querytable create-web` |
| Modern connectors, transformations, APIs, JSON, or reusable M | `powerquery` |
| Existing OLEDB/ODBC workbook connection | `connection` |

## Text Import

```text
querytable(action: 'create-text',
    queryTableName: 'OrdersCsv',
    sourcePath: 'C:\Data\orders.csv',
    sheetName: 'Orders',
    destinationAddress: 'A1',
    delimiter: ',',
    textQualifier: 'double-quote',
    encoding: 65001,
    hasHeaders: true)
```

- `delimiter` is exactly one character.
- `textQualifier` is `double-quote`, `single-quote`, or `none`.
- `encoding` is a Windows code page; use `65001` for UTF-8.
- Creation refreshes synchronously so imported data is ready when the call returns.

## Legacy Web Import

```text
querytable(action: 'create-web',
    queryTableName: 'RatesHtml',
    url: 'https://example.com/rates.html',
    sheetName: 'Rates',
    destinationAddress: 'A1',
    selectionType: 'specified-tables',
    webTables: '1',
    formatting: 'none')
```

- `selectionType` is `entire-page`, `all-tables`, or `specified-tables`.
- `webTables` is required with `specified-tables`.
- `formatting` is `none`, `rich-text`, or `all`.
- This is Excel's legacy HTML web-query engine, not a general HTTP or browser automation API.

## Lifecycle and Refresh

Use `list`, `view`, `set-properties`, `refresh`, `get-refresh-status`, `cancel-refresh`, and `delete` for existing QueryTables.

## Hard Exclusions

Local QueryTable COM automation cannot access Microsoft 365 cloud service state or APIs:

- No workbook sharing or permissions
- No coauthor presence, cursors, conflicts, or live collaboration state
- No comment @mentions, assignments, reactions, or notification delivery
- No authenticated Graph, SharePoint, Teams, or OneDrive service operations
- No Power Query M definition or modern connector configuration

Use the relevant Microsoft 365 service API for cloud workflows and `powerquery` for modern data transformation.