# Microsoft Excel

> Manage and edit Excel workbooks stored in OneDrive or SharePoint.

App · Spreadsheets · 58 actions. Web page: https://docs.lodol.com/docs/integrations/microsoft-excel

## Actions

### Add chart

Add a chart over a range of data.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Chart type (`chart_type`, text, required): Excel chart type, for example 'ColumnClustered', 'Line', 'Pie' or 'BarStacked'.
- Source data (`source_data`, text, required): Range the chart plots, in A1 notation, for example 'A1:C4'.
- Series by (`series_by`, text): Whether rows or columns become the data series. One of: `Auto`, `Columns`, `Rows`. Default: `Auto`.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `height` (number): Height in points.
- `id` (text): Chart ID.
- `left` (number): Distance from the left of the worksheet, in points.
- `name` (text): Chart name.
- `top` (number): Distance from the top of the worksheet, in points.
- `width` (number): Width in points.

**Example output**

```json
{
  "height": 216.0,
  "id": "{2D421098-FA19-41F7-8528-EE7B00E4BB42}",
  "left": 0.0,
  "name": "Chart 1",
  "top": 0.0,
  "width": 360.0
}
```

### Add named item

Define a named range or named formula.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Name (`name`, text, required): The name to define, for example 'SalesData'.
- Reference (`reference`, text, required): What the name points at, as a formula-style reference, for example '=Sheet1!$A$1:$D$10'.
- Comment (`comment`, text): A note stored with the name.
- Worksheet ID (`worksheet_id`, text): Scope the name to one worksheet. Leave empty to scope it to the whole workbook.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `comment` (text): The comment stored with the name.
- `name` (text): The item's name.
- `scope` (text): Either 'Workbook' or the owning worksheet's name.
- `type` (text): What the name refers to, for example 'Range'.
- `value` (text): The formula or range the name resolves to.
- `visible` (true/false): Whether the name is visible in Excel's name manager.

**Example output**

```json
{
  "comment": "Source for the Q3 report",
  "name": "SalesData",
  "scope": "Workbook",
  "type": "Range",
  "value": "Sheet1!$A$1:$D$10",
  "visible": true
}
```

### Add table column

Add a column to a table.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Table (`table_id`, text, required): The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
- Values (`values`, list): Column-shaped grid whose first row is the header, for example [["Status"], ["Open"], ["Closed"]].
- Index (`index`, number): Zero-based position to insert at. Leave empty to append at the end. At least 0.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `id` (text): Column ID.
- `index` (number): Zero-based column position in the table.
- `name` (text): Column header text.

**Example output**

```json
{
  "id": "4",
  "index": 2,
  "name": "Status"
}
```

### Add worksheet

Add a new worksheet to an Excel workbook.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Name (`name`, text, required): Name for the new worksheet.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `id` (text): Worksheet ID. Use as worksheet_id in the range, table, chart and worksheet actions.
- `name` (text): Worksheet name.

**Example output**

```json
{
  "id": "{75A18F35-34AA-4F44-97CC-FDC3C05D9F40}",
  "name": "Sheet2"
}
```

### Append table rows

Append rows to the end of a table.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Table (`table_id`, text, required): The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
- Rows (`rows`, list, required): Rows to append, for example [["2026-01-15", 49, 37]].
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `rows_added` (number): Number of rows appended.

**Example output**

```json
{
  "rows_added": 1
}
```

### Auto-fit columns

Resize every column in a range to fit its widest cell.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Range address (`range_address`, text, required): The range in A1 notation, for example 'A1:D10'.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `autofitted` (true/false): Always true when the columns were resized.

**Example output**

```json
{
  "autofitted": true
}
```

### Clear range

Clear the contents, the formatting, or both, from a cell range.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Range address (`range_address`, text, required): The range in A1 notation, for example 'A1:D10'.
- Apply to (`apply_to`, text): What to clear. One of: `All` (Contents and formatting), `Contents` (Contents only), `Formats` (Formatting only). Default: `All`.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `cleared` (true/false): Always true when the range was cleared.

**Example output**

```json
{
  "cleared": true
}
```

### Clear table filters

Clear every column filter on a table.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Table (`table_id`, text, required): The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `cleared` (true/false): Always true when the filters were cleared.

**Example output**

```json
{
  "cleared": true
}
```

### Convert table to range

Turn a table back into ordinary cells, keeping the data.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Table (`table_id`, text, required): The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `address` (text): The resulting range in A1 notation.

**Example output**

```json
{
  "address": "Sheet1!A1:C7"
}
```

### Create table

Create a table over an existing cell range.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Table name (`table_name`, text, required): Name for the new table.
- Range address (`address`, text, required): Range the table covers, in A1 notation, for example 'A1:D5'.
- Has headers (`has_headers`, true/false): The first row of the range holds column labels. Default: `true`.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `id` (text): Table ID. Use as table_id in the table, row and column actions.
- `name` (text): Table name.

**Example output**

```json
{
  "id": "2",
  "name": "Sales"
}
```

### Delete cells

Delete a range of cells, pulling the remaining cells into the gap.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Range address (`range_address`, text, required): The range in A1 notation, for example 'A1:D10'.
- Shift (`shift`, text, required): Which way the remaining cells move. One of: `Up`, `Left`.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `shift` (text): The direction the remaining cells were shifted.

**Example output**

```json
{
  "shift": "Up"
}
```

### Delete chart

Delete a chart from a worksheet.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Chart (`chart_id`, text, required): The chart's ID or name. Pick it from the dropdown, or chain it from the 'Add chart' action.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `deleted` (true/false): Always true when the chart was removed.

**Example output**

```json
{
  "deleted": true
}
```

### Delete table

Delete a table. Its cells and their values stay on the worksheet.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Table (`table_id`, text, required): The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `deleted` (true/false): Always true when the table was removed.

**Example output**

```json
{
  "deleted": true
}
```

### Delete table column

Delete a column from a table.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Table (`table_id`, text, required): The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
- Column ID (`column_id`, text, required): The column's ID or its header text.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `deleted` (true/false): Always true when the column was removed.

**Example output**

```json
{
  "deleted": true
}
```

### Delete table row

Delete one row of a table. Rows below it shift up, so their indexes change.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Table (`table_id`, text, required): The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
- Row index (`row_index`, number, required): Zero-based row index, excluding the header row. At least 0.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `deleted_index` (number): The row index that was deleted.

**Example output**

```json
{
  "deleted_index": 0
}
```

### Delete worksheet

Delete a worksheet from an Excel workbook.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `deleted` (true/false): Always true when the worksheet was removed.

**Example output**

```json
{
  "deleted": true
}
```

### Format range

Set a range's column width, row height, alignment and text wrapping.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Range address (`range_address`, text, required): The range in A1 notation, for example 'A1:D10'.
- Column width (`column_width`, number): Width of every column in the range, in points. At least 0.
- Row height (`row_height`, number): Height of every row in the range, in points. At least 0.
- Horizontal alignment (`horizontal_alignment`, text): Horizontal alignment. One of: `General`, `Left`, `Center`, `Right`, `Fill`, `Justify`, `CenterAcrossSelection`, `Distributed`.
- Vertical alignment (`vertical_alignment`, text): Vertical alignment. One of: `Top`, `Center`, `Bottom`, `Justify`, `Distributed`.
- Wrap text (`wrap_text`, true/false): Wrap text within each cell.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `column_width` (number): Column width in points.
- `horizontal_alignment` (text): Horizontal alignment.
- `row_height` (number): Row height in points.
- `vertical_alignment` (text): Vertical alignment.
- `wrap_text` (true/false): Whether text wraps within each cell.

**Example output**

```json
{
  "column_width": 135,
  "horizontal_alignment": "Left",
  "row_height": 18,
  "vertical_alignment": "Bottom",
  "wrap_text": false
}
```

### Get chart image

Render a chart to a base64-encoded PNG.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Chart (`chart_id`, text, required): The chart's ID or name. Pick it from the dropdown, or chain it from the 'Add chart' action.
- Width (`width`, number): Image width in pixels. At least 1.
- Height (`height`, number): Image height in pixels. At least 1.
- Fitting mode (`fitting_mode`, text): How the chart fits the requested size. Only applies when both a width and a height are given. One of: `Fit`, `FitAndCenter` (Fit and center), `Fill`.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `image_base64` (text): The chart as a base64-encoded PNG.

**Example output**

```json
{
  "image_base64": "iVBORw0KGgoAAAANSUhEUgAA..."
}
```

### Get named item range

Resolve a named item to its address and current values.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Name (`name`, text, required): The named item to resolve.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `address` (text): The range in A1 notation, including the sheet name.
- `column_count` (number): Number of columns.
- `row_count` (number): Number of rows.
- `values` (list): Row-major grid of cell values.

**Example output**

```json
{
  "address": "Sheet1!A1:D10",
  "column_count": 4,
  "row_count": 10,
  "values": [
    [
      "Region",
      "Q1",
      "Q2",
      "Q3"
    ]
  ]
}
```

### Get range values

Read the values of a cell range.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Range address (`range_address`, text, required): The range in A1 notation, for example 'A1:D10'.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `values` (list): Row-major grid of cell values.

**Example output**

```json
{
  "values": [
    [
      "Region",
      "Revenue"
    ],
    [
      "West",
      1200
    ]
  ]
}
```

### Get table

Read a table's name, style and header/total row settings.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Table (`table_id`, text, required): The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `id` (text): Table ID.
- `name` (text): Table name.
- `show_headers` (true/false): Whether the header row is shown.
- `show_totals` (true/false): Whether the totals row is shown.
- `style` (text): Built-in table style name.

**Example output**

```json
{
  "id": "2",
  "name": "Sales",
  "show_headers": true,
  "show_totals": false,
  "style": "TableStyleMedium4"
}
```

### Get table range

Resolve a table to a range address and values, so the range actions can act on it.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Table (`table_id`, text, required): The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
- Range type (`range_type`, text): Which part of the table to resolve. One of: `All` (Whole table, including headers), `Body` (Data rows only), `Header` (Header row only), `Totals` (Totals row only). Default: `All`.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `address` (text): The range in A1 notation, including the sheet name.
- `column_count` (number): Number of columns.
- `row_count` (number): Number of rows.
- `values` (list): Row-major grid of cell values.

**Example output**

```json
{
  "address": "Sheet1!A1:C7",
  "column_count": 3,
  "row_count": 7,
  "values": [
    [
      "Date",
      "High",
      "Low"
    ],
    [
      "2026-01-15",
      49,
      37
    ]
  ]
}
```

### Get used range

Read every populated cell on a worksheet without knowing its address.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Values only (`values_only`, true/false): Ignore cells that only carry formatting, so the range covers just the cells holding values. Default: `false`.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `address` (text): The used range in A1 notation, including the sheet name.
- `column_count` (number): Number of columns.
- `row_count` (number): Number of rows.
- `text` (list): The same cells as Excel displays them, after number formatting.
- `values` (list): Row-major grid of cell values.

**Example output**

```json
{
  "address": "Sheet1!A1:B2",
  "column_count": 2,
  "row_count": 2,
  "text": [
    [
      "Region",
      "Revenue"
    ],
    [
      "West",
      "1,200"
    ]
  ],
  "values": [
    [
      "Region",
      "Revenue"
    ],
    [
      "West",
      1200
    ]
  ]
}
```

### Get worksheet

Read a worksheet's name, position and visibility.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `id` (text): Worksheet ID.
- `name` (text): Worksheet name.
- `position` (number): Zero-based position in the tab strip.
- `visibility` (text): One of 'Visible', 'Hidden' or 'VeryHidden'.

**Example output**

```json
{
  "id": "{00000000-0001-0000-0000-000000000000}",
  "name": "Sheet1",
  "position": 0,
  "visibility": "Visible"
}
```

### Insert cells

Insert blank cells into a range, shifting the existing cells out of the way.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Range address (`range_address`, text, required): The range in A1 notation, for example 'A1:D10'.
- Shift (`shift`, text, required): Which way the existing cells move. One of: `Down`, `Right`.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `address` (text): Address of the inserted range.
- `shift` (text): The direction the existing cells were shifted.

**Example output**

```json
{
  "address": "Sheet1!A1:B2",
  "shift": "Down"
}
```

### List charts

List the charts on a worksheet.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `charts` (list)

**Example output**

```json
{
  "charts": [
    {
      "height": 216.0,
      "id": "{2D421098-FA19-41F7-8528-EE7B00E4BB42}",
      "left": 0.0,
      "name": "Chart 1",
      "top": 0.0,
      "width": 360.0
    }
  ]
}
```

### List comments

List the comments in a workbook. Excel's Graph API is read-only for comments, so they cannot be created or replied to.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `comments` (list)

**Example output**

```json
{
  "comments": [
    {
      "content": "Check this number against the invoice.",
      "content_type": "Plain",
      "id": "{1C...}"
    }
  ]
}
```

### List drives

List the OneDrive and SharePoint drives this account can reach. Every other Excel action needs one of these drive IDs.

**Inputs**: None.

**Outputs**

- `drives` (list)

**Example output**

```json
{
  "drives": [
    {
      "drive_type": "business",
      "id": "b!driveid",
      "name": "Documents",
      "owner": "Avery Chen",
      "web_url": "https://contoso-my.sharepoint.com/personal/x/Documents"
    }
  ]
}
```

### List named items

List a workbook's named ranges and named formulas.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `named_items` (list)

**Example output**

```json
{
  "named_items": [
    {
      "comment": "Source for the Q3 report",
      "name": "SalesData",
      "scope": "Workbook",
      "type": "Range",
      "value": "Sheet1!$A$1:$D$10",
      "visible": true
    }
  ]
}
```

### List pivot tables

List the pivot tables on a worksheet.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `pivot_tables` (list)

**Example output**

```json
{
  "pivot_tables": [
    {
      "id": "{A1B2C3}",
      "name": "PivotTable1"
    }
  ]
}
```

### List site drives

List a SharePoint site's document libraries. Each one is a drive whose ID the other Excel actions take.

**Inputs**

- SharePoint site (`site_id`, text, required): The site's ID. Pick it from the dropdown, or chain it from the 'List sites' action.

**Outputs**

- `drives` (list)

**Example output**

```json
{
  "drives": [
    {
      "drive_type": "documentLibrary",
      "id": "b!sitedriveid",
      "name": "Documents",
      "owner": null,
      "web_url": "https://contoso.sharepoint.com/sites/marketing/Shared%20Documents"
    }
  ]
}
```

### List sites

Search the tenant's SharePoint sites. Use it to find the site whose document library holds a workbook.

**Inputs**

- Query (`query`, text): Keywords to match against site names. Defaults to '*', which lists every site the account can see.
- Limit (`limit`, number): Maximum number of sites to return. From 1 to 200.

**Outputs**

- `sites` (list)

**Example output**

```json
{
  "sites": [
    {
      "id": "contoso.sharepoint.com,8a1f...,7c2b...",
      "name": "Marketing",
      "web_url": "https://contoso.sharepoint.com/sites/marketing"
    }
  ]
}
```

### List table columns

List a table's columns and their positions.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Table (`table_id`, text, required): The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `columns` (list)

**Example output**

```json
{
  "columns": [
    {
      "id": "1",
      "index": 0,
      "name": "Date"
    }
  ]
}
```

### List table rows

Read the data rows of a table.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Table (`table_id`, text, required): The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
- Top (`top`, number): Maximum number of rows to return. At least 1.
- Skip (`skip`, number): Number of rows to skip before returning results. At least 0.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `rows` (list)

**Example output**

```json
{
  "rows": [
    {
      "index": 0,
      "values": [
        "2026-01-15",
        49,
        37
      ]
    }
  ]
}
```

### List tables

List the tables in a workbook, or in a single worksheet.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet ID (`worksheet_id`, text): Limit the result to one worksheet. Leave empty to list every table in the workbook.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `tables` (list)

**Example output**

```json
{
  "tables": [
    {
      "id": "2",
      "name": "Sales",
      "show_headers": true,
      "show_totals": false,
      "style": "TableStyleMedium4"
    }
  ]
}
```

### List workbooks

Find Excel workbooks in a OneDrive or SharePoint drive.

**Inputs**

- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.
- Query (`query`, text): Text to search file names for. Defaults to 'xlsx', which lists every workbook the drive search returns.
- Limit (`limit`, number): Maximum number of workbooks to return. From 1 to 200.

**Outputs**

- `workbooks` (list)

**Example output**

```json
{
  "workbooks": [
    {
      "drive_id": "b!driveid",
      "id": "01ABCWORKBOOK",
      "last_modified": "2026-09-01T10:14:00Z",
      "name": "Q3 forecast.xlsx",
      "size": 18422,
      "web_url": "https://contoso-my.sharepoint.com/personal/x/_layouts/15/Doc.aspx?sourcedoc=%7B...%7D"
    }
  ]
}
```

### List worksheets

List all worksheets in an Excel workbook.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `worksheets` (list): List of worksheet names.

**Example output**

```json
{
  "worksheets": [
    "Sheet1"
  ]
}
```

### Merge cells

Merge a range of cells into one.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Range address (`range_address`, text, required): The range in A1 notation, for example 'A1:D10'.
- Across (`across`, true/false): Merge each row of the range separately instead of merging the whole block. Default: `false`.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `merged` (true/false): Always true when the cells were merged.

**Example output**

```json
{
  "merged": true
}
```

### Protect worksheet

Protect a worksheet against edits.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Options (`options`, object): Optional protection exceptions, for example {"allowSort": true, "allowAutoFilter": true}. Omit to lock the sheet down entirely.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `protected` (true/false): Always true when protection was applied.

**Example output**

```json
{
  "protected": true
}
```

### Reapply table filters

Re-run a table's existing column filters against its current data.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Table (`table_id`, text, required): The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `reapplied` (true/false): Always true when the filters were reapplied.

**Example output**

```json
{
  "reapplied": true
}
```

### Recalculate workbook

Force Excel to recalculate the workbook's formulas.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Calculation type (`calculation_type`, text): How much to recalculate. One of: `Recalculate` (Recalculate (changed cells only)), `Full` (Full (every formula)), `FullRebuild` (Full rebuild (every formula, rebuilding dependencies)). Default: `Recalculate`.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `calculation_type` (text): The calculation mode that was applied.

**Example output**

```json
{
  "calculation_type": "Recalculate"
}
```

### Refresh all pivot tables

Refresh every pivot table on a worksheet.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `refreshed` (true/false): Always true when the pivot tables were refreshed.

**Example output**

```json
{
  "refreshed": true
}
```

### Refresh pivot table

Refresh one pivot table against its current source data.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Pivot table ID (`pivot_table_id`, text, required): The pivot table's ID or name, from the 'List pivot tables' action.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `refreshed` (true/false): Always true when the pivot table was refreshed.

**Example output**

```json
{
  "refreshed": true
}
```

### Rename worksheet

Rename an existing worksheet in an Excel workbook.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- New name (`new_name`, text, required): New name for the worksheet.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `name` (text): New worksheet name.

**Example output**

```json
{
  "name": "RenamedSheet"
}
```

### Run workbook function

Evaluate one of Excel's worksheet functions (VLOOKUP, SUM, PMT, ...) without writing it into a cell.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Function name (`function_name`, text, required): The function to call, lowercase, for example 'vlookup', 'sum' or 'pmt'.
- Arguments (`arguments`, object): The function's own named arguments, for example {"lookupValue": "pear", "tableArray": {"Address": "Sheet1!B2:C7"}, "colIndexNum": 2, "rangeLookup": false}.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `error` (text): Excel's error name when the function failed, otherwise null.
- `value`: The function's result.

**Example output**

```json
{
  "error": null,
  "value": 5
}
```

### Set chart data

Repoint an existing chart at a different range.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Chart (`chart_id`, text, required): The chart's ID or name. Pick it from the dropdown, or chain it from the 'Add chart' action.
- Source data (`source_data`, text, required): New range the chart plots, in A1 notation.
- Series by (`series_by`, text): Whether rows or columns become the data series. One of: `Auto`, `Columns`, `Rows`. Default: `Auto`.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `source_data` (text): The range the chart now plots.

**Example output**

```json
{
  "source_data": "A1:C4"
}
```

### Set chart position

Anchor a chart to a cell.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Chart (`chart_id`, text, required): The chart's ID or name. Pick it from the dropdown, or chain it from the 'Add chart' action.
- Start cell (`start_cell`, text, required): Cell the chart's top-left corner sits on, for example 'E2'.
- End cell (`end_cell`, text): Cell the chart's opposite corner covers. Give one to size the chart to that block.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `start_cell` (text): The cell the chart is now anchored to.

**Example output**

```json
{
  "start_cell": "E2"
}
```

### Set range formulas

Write formulas into a cell range.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Range address (`range_address`, text, required): The range in A1 notation, for example 'A1:D10'.
- Formulas (`formulas`, list, required): Row-major grid of formulas, for example [["=SUM(B2:B9)"]]. A null leaves that cell untouched.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `formulas` (list): The grid of formulas that was written.

**Example output**

```json
{
  "formulas": [
    [
      "=SUM(B2:B9)"
    ]
  ]
}
```

### Set range number format

Apply Excel number formats to a cell range.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Range address (`range_address`, text, required): The range in A1 notation, for example 'A1:D10'.
- Number format (`number_format`, list, required): Row-major grid of format codes, for example [["m/d/yyyy", "0.00%"]]. Use "General" to reset a cell.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `number_format` (list): The grid of format codes that was applied.

**Example output**

```json
{
  "number_format": [
    [
      "m/d/yyyy",
      "0.00%"
    ]
  ]
}
```

### Sort range

Sort a cell range on one or more columns.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Range address (`range_address`, text, required): The range in A1 notation, for example 'A1:D10'.
- Fields (`fields`, list, required): Sort conditions, for example [{"key": 0, "ascending": true}]. 'key' is the zero-based column offset within the range, not the sheet column.
- Has headers (`has_headers`, true/false): Treat the first row of the range as headers and leave it in place. Default: `false`.
- Match case (`match_case`, true/false): Let letter casing affect the ordering. Default: `false`.
- Orientation (`orientation`, text): Sort rows (the usual case) or columns. One of: `Rows`, `Columns`.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `fields_applied` (number): Number of sort conditions applied.

**Example output**

```json
{
  "fields_applied": 1
}
```

### Sort table

Sort a table on one or more of its columns.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Table (`table_id`, text, required): The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
- Fields (`fields`, list, required): Sort conditions, for example [{"key": 0, "ascending": true}]. 'key' is the zero-based column offset within the table.
- Match case (`match_case`, true/false): Let letter casing affect the ordering. Default: `false`.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `fields_applied` (number): Number of sort conditions applied.

**Example output**

```json
{
  "fields_applied": 1
}
```

### Unmerge cells

Split previously merged cells back apart.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Range address (`range_address`, text, required): The range in A1 notation, for example 'A1:D10'.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `unmerged` (true/false): Always true when the cells were unmerged.

**Example output**

```json
{
  "unmerged": true
}
```

### Unprotect worksheet

Remove protection from a worksheet.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `protected` (true/false): Always false once protection was removed.

**Example output**

```json
{
  "protected": false
}
```

### Update chart

Rename or resize a chart.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Chart (`chart_id`, text, required): The chart's ID or name. Pick it from the dropdown, or chain it from the 'Add chart' action.
- Name (`name`, text): New chart name.
- Height (`height`, number): Height in points. At least 0.
- Width (`width`, number): Width in points. At least 0.
- Top (`top`, number): Distance from the top of the worksheet, in points. At least 0.
- Left (`left`, number): Distance from the left of the worksheet, in points. At least 0.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `height` (number): Height in points.
- `id` (text): Chart ID.
- `left` (number): Distance from the left of the worksheet, in points.
- `name` (text): Chart name.
- `top` (number): Distance from the top of the worksheet, in points.
- `width` (number): Width in points.

**Example output**

```json
{
  "height": 216.0,
  "id": "{2D421098-FA19-41F7-8528-EE7B00E4BB42}",
  "left": 0.0,
  "name": "Chart 1",
  "top": 0.0,
  "width": 360.0
}
```

### Update range values

Write literal values into a cell range.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Range address (`range_address`, text, required): The range in A1 notation, for example 'A1:D10'.
- Values (`values`, list, required): Row-major grid of values, for example [["Region", "Revenue"], ["West", 1200]]. A null leaves that cell untouched.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `values` (list): The grid that was written.

**Example output**

```json
{
  "values": [
    [
      "Region",
      "Revenue"
    ],
    [
      "West",
      1200
    ]
  ]
}
```

### Update table

Rename a table or change its style, header row or totals row.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Table (`table_id`, text, required): The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
- Name (`name`, text): New table name.
- Show headers (`show_headers`, true/false): Show the header row.
- Show totals (`show_totals`, true/false): Show the totals row.
- Style (`style`, text): Built-in table style name, for example 'TableStyleMedium4'.
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `id` (text): Table ID.
- `name` (text): Table name.
- `show_headers` (true/false): Whether the header row is shown.
- `show_totals` (true/false): Whether the totals row is shown.
- `style` (text): Built-in table style name.

**Example output**

```json
{
  "id": "2",
  "name": "Sales",
  "show_headers": true,
  "show_totals": false,
  "style": "TableStyleMedium4"
}
```

### Update table row

Overwrite one row of a table.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Table (`table_id`, text, required): The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
- Row index (`row_index`, number, required): Zero-based row index, excluding the header row. At least 0.
- Values (`values`, list, required): The row's new cell values, for example ["2026-01-15", 49, 37].
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `index` (number): The row index that was written.
- `values` (list): The row's cell values.

**Example output**

```json
{
  "index": 0,
  "values": [
    "2026-01-15",
    49,
    37
  ]
}
```

### Update worksheet

Move a worksheet in the tab strip or change whether it is visible. Use 'Rename worksheet' to change its name.

**Inputs**

- Workbook (`item_id`, text, required): The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
- Worksheet (`worksheet_id`, text, required): The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
- Position (`position`, number): Zero-based position in the tab strip. At least 0.
- Visibility (`visibility`, text): Whether the worksheet is shown. One of: `Visible`, `Hidden`, `VeryHidden` (Very hidden (only unhideable through code)).
- Drive (`drive_id`, text, required): The drive holding the workbook. OneDrive for Business, a SharePoint document library or a group drive: Excel's API cannot open workbooks on consumer OneDrive.

**Outputs**

- `id` (text): Worksheet ID.
- `name` (text): Worksheet name.
- `position` (number): Zero-based position in the tab strip.
- `visibility` (text): One of 'Visible', 'Hidden' or 'VeryHidden'.

**Example output**

```json
{
  "id": "{00000000-0001-0000-0100-000000000000}",
  "name": "Archive",
  "position": 3,
  "visibility": "Hidden"
}
```