Microsoft Excel

Actions

Action	What it does
Add chart	Add a chart over a range of data.
Add named item	Define a named range or named formula.
Add table column	Add a column to a table.
Add worksheet	Add a new worksheet to an Excel workbook.
Append table rows	Append rows to the end of a table.
Auto-fit columns	Resize every column in a range to fit its widest cell.
Clear range	Clear the contents, the formatting, or both, from a cell range.
Clear table filters	Clear every column filter on a table.
Convert table to range	Turn a table back into ordinary cells, keeping the data.
Create table	Create a table over an existing cell range.
Delete cells	Delete a range of cells, pulling the remaining cells into the gap.
Delete chart	Delete a chart from a worksheet.
Delete table	Delete a table.
Delete table column	Delete a column from a table.
Delete table row	Delete one row of a table.
Delete worksheet	Delete a worksheet from an Excel workbook.
Format range	Set a range's column width, row height, alignment and text wrapping.
Get chart image	Render a chart to a base64-encoded PNG.
Get named item range	Resolve a named item to its address and current values.
Get range values	Read the values of a cell range.
Get table	Read a table's name, style and header/total row settings.
Get table range	Resolve a table to a range address and values, so the range actions can act on it.
Get used range	Read every populated cell on a worksheet without knowing its address.
Get worksheet	Read a worksheet's name, position and visibility.
Insert cells	Insert blank cells into a range, shifting the existing cells out of the way.
List charts	List the charts on a worksheet.
List comments	List the comments in a workbook.
List drives	List the OneDrive and SharePoint drives this account can reach.
List named items	List a workbook's named ranges and named formulas.
List pivot tables	List the pivot tables on a worksheet.
List site drives	List a SharePoint site's document libraries.
List sites	Search the tenant's SharePoint sites.
List table columns	List a table's columns and their positions.
List table rows	Read the data rows of a table.
List tables	List the tables in a workbook, or in a single worksheet.
List workbooks	Find Excel workbooks in a OneDrive or SharePoint drive.
List worksheets	List all worksheets in an Excel workbook.
Merge cells	Merge a range of cells into one.
Protect worksheet	Protect a worksheet against edits.
Reapply table filters	Re-run a table's existing column filters against its current data.
Recalculate workbook	Force Excel to recalculate the workbook's formulas.
Refresh all pivot tables	Refresh every pivot table on a worksheet.
Refresh pivot table	Refresh one pivot table against its current source data.
Rename worksheet	Rename an existing worksheet in an Excel workbook.
Run workbook function	Evaluate one of Excel's worksheet functions (VLOOKUP, SUM, PMT, ...) without writing it into a cell.
Set chart data	Repoint an existing chart at a different range.
Set chart position	Anchor a chart to a cell.
Set range formulas	Write formulas into a cell range.
Set range number format	Apply Excel number formats to a cell range.
Sort range	Sort a cell range on one or more columns.
Sort table	Sort a table on one or more of its columns.
Unmerge cells	Split previously merged cells back apart.
Unprotect worksheet	Remove protection from a worksheet.
Update chart	Rename or resize a chart.
Update range values	Write literal values into a cell range.
Update table	Rename a table or change its style, header row or totals row.
Update table row	Overwrite one row of a table.
Update worksheet	Move a worksheet in the tab strip or change whether it is visible.

Add chart

Add a chart over a range of data.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Chart typechart_typetextRequired: Excel chart type, for example 'ColumnClustered', 'Line', 'Pie' or 'BarStacked'.
Source datasource_datatextRequired: Range the chart plots, in A1 notation, for example 'A1:C4'.
Series byseries_bytext: Whether rows or columns become the data series.One of: Auto, Columns, Rows. Default: Auto.
Drivedrive_idtextRequired: 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

heightnumber: Height in points.
idtext: Chart ID.
leftnumber: Distance from the left of the worksheet, in points.
nametext: Chart name.
topnumber: Distance from the top of the worksheet, in points.
widthnumber: Width in points.

Example output

{
  "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

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
NamenametextRequired: The name to define, for example 'SalesData'.
ReferencereferencetextRequired: What the name points at, as a formula-style reference, for example '=Sheet1!$A$1:$D$10'.
Commentcommenttext: A note stored with the name.
Worksheet IDworksheet_idtext: Scope the name to one worksheet. Leave empty to scope it to the whole workbook.
Drivedrive_idtextRequired: 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

commenttext: The comment stored with the name.
nametext: The item's name.
scopetext: Either 'Workbook' or the owning worksheet's name.
typetext: What the name refers to, for example 'Range'.
valuetext: The formula or range the name resolves to.
visibletrue/false: Whether the name is visible in Excel's name manager.

Example output

{
  "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

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Tabletable_idtextRequired: The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
Valuesvalueslist: Column-shaped grid whose first row is the header, for example [["Status"], ["Open"], ["Closed"]].
Indexindexnumber: Zero-based position to insert at. Leave empty to append at the end.At least 0.
Drivedrive_idtextRequired: 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

idtext: Column ID.
indexnumber: Zero-based column position in the table.
nametext: Column header text.

Example output

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

Add worksheet

Add a new worksheet to an Excel workbook.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
NamenametextRequired: Name for the new worksheet.
Drivedrive_idtextRequired: 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

idtext: Worksheet ID. Use as worksheet_id in the range, table, chart and worksheet actions.
nametext: Worksheet name.

Example output

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

Append table rows

Append rows to the end of a table.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Tabletable_idtextRequired: The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
RowsrowslistRequired: Rows to append, for example [["2026-01-15", 49, 37]].
Drivedrive_idtextRequired: 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_addednumber: Number of rows appended.

Example output

{
  "rows_added": 1
}

Auto-fit columns

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

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Range addressrange_addresstextRequired: The range in A1 notation, for example 'A1:D10'.
Drivedrive_idtextRequired: 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

autofittedtrue/false: Always true when the columns were resized.

Example output

{
  "autofitted": true
}

Clear range

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

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Range addressrange_addresstextRequired: The range in A1 notation, for example 'A1:D10'.
Apply toapply_totext: What to clear.One of: All (Contents and formatting), Contents (Contents only), Formats (Formatting only). Default: All.
Drivedrive_idtextRequired: 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

clearedtrue/false: Always true when the range was cleared.

Example output

{
  "cleared": true
}

Clear table filters

Clear every column filter on a table.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Tabletable_idtextRequired: The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
Drivedrive_idtextRequired: 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

clearedtrue/false: Always true when the filters were cleared.

Example output

{
  "cleared": true
}

Convert table to range

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

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Tabletable_idtextRequired: The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
Drivedrive_idtextRequired: 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

addresstext: The resulting range in A1 notation.

Example output

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

Create table

Create a table over an existing cell range.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Table nametable_nametextRequired: Name for the new table.
Range addressaddresstextRequired: Range the table covers, in A1 notation, for example 'A1:D5'.
Has headershas_headerstrue/false: The first row of the range holds column labels.Default: true.
Drivedrive_idtextRequired: 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

idtext: Table ID. Use as table_id in the table, row and column actions.
nametext: Table name.

Example output

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

Delete cells

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

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Range addressrange_addresstextRequired: The range in A1 notation, for example 'A1:D10'.
ShiftshifttextRequired: Which way the remaining cells move.One of: Up, Left.
Drivedrive_idtextRequired: 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

shifttext: The direction the remaining cells were shifted.

Example output

{
  "shift": "Up"
}

Delete chart

Delete a chart from a worksheet.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Chartchart_idtextRequired: The chart's ID or name. Pick it from the dropdown, or chain it from the 'Add chart' action.
Drivedrive_idtextRequired: 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

deletedtrue/false: Always true when the chart was removed.

Example output

{
  "deleted": true
}

Delete table

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

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Tabletable_idtextRequired: The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
Drivedrive_idtextRequired: 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

deletedtrue/false: Always true when the table was removed.

Example output

{
  "deleted": true
}

Delete table column

Delete a column from a table.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Tabletable_idtextRequired: The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
Column IDcolumn_idtextRequired: The column's ID or its header text.
Drivedrive_idtextRequired: 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

deletedtrue/false: Always true when the column was removed.

Example output

{
  "deleted": true
}

Delete table row

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

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Tabletable_idtextRequired: The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
Row indexrow_indexnumberRequired: Zero-based row index, excluding the header row.At least 0.
Drivedrive_idtextRequired: 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_indexnumber: The row index that was deleted.

Example output

{
  "deleted_index": 0
}

Delete worksheet

Delete a worksheet from an Excel workbook.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Drivedrive_idtextRequired: 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

deletedtrue/false: Always true when the worksheet was removed.

Example output

{
  "deleted": true
}

Format range

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

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Range addressrange_addresstextRequired: The range in A1 notation, for example 'A1:D10'.
Column widthcolumn_widthnumber: Width of every column in the range, in points.At least 0.
Row heightrow_heightnumber: Height of every row in the range, in points.At least 0.
Horizontal alignmenthorizontal_alignmenttext: Horizontal alignment.One of: General, Left, Center, Right, Fill, Justify, CenterAcrossSelection, Distributed.
Vertical alignmentvertical_alignmenttext: Vertical alignment.One of: Top, Center, Bottom, Justify, Distributed.
Wrap textwrap_texttrue/false: Wrap text within each cell.
Drivedrive_idtextRequired: 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_widthnumber: Column width in points.
horizontal_alignmenttext: Horizontal alignment.
row_heightnumber: Row height in points.
vertical_alignmenttext: Vertical alignment.
wrap_texttrue/false: Whether text wraps within each cell.

Example output

{
  "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

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Chartchart_idtextRequired: The chart's ID or name. Pick it from the dropdown, or chain it from the 'Add chart' action.
Widthwidthnumber: Image width in pixels.At least 1.
Heightheightnumber: Image height in pixels.At least 1.
Fitting modefitting_modetext: 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.
Drivedrive_idtextRequired: 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_base64text: The chart as a base64-encoded PNG.

Example output

{
  "image_base64": "iVBORw0KGgoAAAANSUhEUgAA..."
}

Get named item range

Resolve a named item to its address and current values.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
NamenametextRequired: The named item to resolve.
Drivedrive_idtextRequired: 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

addresstext: The range in A1 notation, including the sheet name.
column_countnumber: Number of columns.
row_countnumber: Number of rows.
valueslist: Row-major grid of cell values.

Example output

{
  "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

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Range addressrange_addresstextRequired: The range in A1 notation, for example 'A1:D10'.
Drivedrive_idtextRequired: 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

valueslist: Row-major grid of cell values.

Example output

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

Get table

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

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Tabletable_idtextRequired: The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
Drivedrive_idtextRequired: 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

idtext: Table ID.
nametext: Table name.
show_headerstrue/false: Whether the header row is shown.
show_totalstrue/false: Whether the totals row is shown.
styletext: Built-in table style name.

Example output

{
  "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

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Tabletable_idtextRequired: The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
Range typerange_typetext: 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.
Drivedrive_idtextRequired: 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

addresstext: The range in A1 notation, including the sheet name.
column_countnumber: Number of columns.
row_countnumber: Number of rows.
valueslist: Row-major grid of cell values.

Example output

{
  "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

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Values onlyvalues_onlytrue/false: Ignore cells that only carry formatting, so the range covers just the cells holding values.Default: false.
Drivedrive_idtextRequired: 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

addresstext: The used range in A1 notation, including the sheet name.
column_countnumber: Number of columns.
row_countnumber: Number of rows.
textlist: The same cells as Excel displays them, after number formatting.
valueslist: Row-major grid of cell values.

Example output

{
  "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

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Drivedrive_idtextRequired: 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

idtext: Worksheet ID.
nametext: Worksheet name.
positionnumber: Zero-based position in the tab strip.
visibilitytext: One of 'Visible', 'Hidden' or 'VeryHidden'.

Example output

{
  "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

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Range addressrange_addresstextRequired: The range in A1 notation, for example 'A1:D10'.
ShiftshifttextRequired: Which way the existing cells move.One of: Down, Right.
Drivedrive_idtextRequired: 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

addresstext: Address of the inserted range.
shifttext: The direction the existing cells were shifted.

Example output

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

List charts

List the charts on a worksheet.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Drivedrive_idtextRequired: 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

chartslist

Example output

{
  "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

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Drivedrive_idtextRequired: 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

commentslist

Example output

{
  "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

driveslist

Example output

{
  "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

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Drivedrive_idtextRequired: 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_itemslist

Example output

{
  "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

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Drivedrive_idtextRequired: 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_tableslist

Example output

{
  "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 sitesite_idtextRequired: The site's ID. Pick it from the dropdown, or chain it from the 'List sites' action.

Outputs

driveslist

Example output

{
  "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

Queryquerytext: Keywords to match against site names. Defaults to '*', which lists every site the account can see.
Limitlimitnumber: Maximum number of sites to return.From 1 to 200.

Outputs

siteslist

Example output

{
  "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

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Tabletable_idtextRequired: The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
Drivedrive_idtextRequired: 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

columnslist

Example output

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

List table rows

Read the data rows of a table.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Tabletable_idtextRequired: The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
Toptopnumber: Maximum number of rows to return.At least 1.
Skipskipnumber: Number of rows to skip before returning results.At least 0.
Drivedrive_idtextRequired: 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

rowslist

Example output

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

List tables

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

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheet IDworksheet_idtext: Limit the result to one worksheet. Leave empty to list every table in the workbook.
Drivedrive_idtextRequired: 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

tableslist

Example output

{
  "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

Drivedrive_idtextRequired: 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.
Queryquerytext: Text to search file names for. Defaults to 'xlsx', which lists every workbook the drive search returns.
Limitlimitnumber: Maximum number of workbooks to return.From 1 to 200.

Outputs

workbookslist

Example output

{
  "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

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Drivedrive_idtextRequired: 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

worksheetslist: List of worksheet names.

Example output

{
  "worksheets": [
    "Sheet1"
  ]
}

Merge cells

Merge a range of cells into one.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Range addressrange_addresstextRequired: The range in A1 notation, for example 'A1:D10'.
Acrossacrosstrue/false: Merge each row of the range separately instead of merging the whole block.Default: false.
Drivedrive_idtextRequired: 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

mergedtrue/false: Always true when the cells were merged.

Example output

{
  "merged": true
}

Protect worksheet

Protect a worksheet against edits.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Optionsoptionsobject: Optional protection exceptions, for example {"allowSort": true, "allowAutoFilter": true}. Omit to lock the sheet down entirely.
Drivedrive_idtextRequired: 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

protectedtrue/false: Always true when protection was applied.

Example output

{
  "protected": true
}

Reapply table filters

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

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Tabletable_idtextRequired: The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
Drivedrive_idtextRequired: 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

reappliedtrue/false: Always true when the filters were reapplied.

Example output

{
  "reapplied": true
}

Recalculate workbook

Force Excel to recalculate the workbook's formulas.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Calculation typecalculation_typetext: How much to recalculate.One of: Recalculate (Recalculate (changed cells only)), Full (Full (every formula)), FullRebuild (Full rebuild (every formula, rebuilding dependencies)). Default: Recalculate.
Drivedrive_idtextRequired: 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_typetext: The calculation mode that was applied.

Example output

{
  "calculation_type": "Recalculate"
}

Refresh all pivot tables

Refresh every pivot table on a worksheet.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Drivedrive_idtextRequired: 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

refreshedtrue/false: Always true when the pivot tables were refreshed.

Example output

{
  "refreshed": true
}

Refresh pivot table

Refresh one pivot table against its current source data.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Pivot table IDpivot_table_idtextRequired: The pivot table's ID or name, from the 'List pivot tables' action.
Drivedrive_idtextRequired: 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

refreshedtrue/false: Always true when the pivot table was refreshed.

Example output

{
  "refreshed": true
}

Rename worksheet

Rename an existing worksheet in an Excel workbook.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
New namenew_nametextRequired: New name for the worksheet.
Drivedrive_idtextRequired: 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

nametext: New worksheet name.

Example output

{
  "name": "RenamedSheet"
}

Run workbook function

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

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Function namefunction_nametextRequired: The function to call, lowercase, for example 'vlookup', 'sum' or 'pmt'.
Argumentsargumentsobject: The function's own named arguments, for example {"lookupValue": "pear", "tableArray": {"Address": "Sheet1!B2:C7"}, "colIndexNum": 2, "rangeLookup": false}.
Drivedrive_idtextRequired: 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

errortext: Excel's error name when the function failed, otherwise null.
value: The function's result.

Example output

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

Set chart data

Repoint an existing chart at a different range.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Chartchart_idtextRequired: The chart's ID or name. Pick it from the dropdown, or chain it from the 'Add chart' action.
Source datasource_datatextRequired: New range the chart plots, in A1 notation.
Series byseries_bytext: Whether rows or columns become the data series.One of: Auto, Columns, Rows. Default: Auto.
Drivedrive_idtextRequired: 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_datatext: The range the chart now plots.

Example output

{
  "source_data": "A1:C4"
}

Set chart position

Anchor a chart to a cell.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Chartchart_idtextRequired: The chart's ID or name. Pick it from the dropdown, or chain it from the 'Add chart' action.
Start cellstart_celltextRequired: Cell the chart's top-left corner sits on, for example 'E2'.
End cellend_celltext: Cell the chart's opposite corner covers. Give one to size the chart to that block.
Drivedrive_idtextRequired: 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_celltext: The cell the chart is now anchored to.

Example output

{
  "start_cell": "E2"
}

Set range formulas

Write formulas into a cell range.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Range addressrange_addresstextRequired: The range in A1 notation, for example 'A1:D10'.
FormulasformulaslistRequired: Row-major grid of formulas, for example [["=SUM(B2:B9)"]]. A null leaves that cell untouched.
Drivedrive_idtextRequired: 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

formulaslist: The grid of formulas that was written.

Example output

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

Set range number format

Apply Excel number formats to a cell range.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Range addressrange_addresstextRequired: The range in A1 notation, for example 'A1:D10'.
Number formatnumber_formatlistRequired: Row-major grid of format codes, for example [["m/d/yyyy", "0.00%"]]. Use "General" to reset a cell.
Drivedrive_idtextRequired: 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_formatlist: The grid of format codes that was applied.

Example output

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

Sort range

Sort a cell range on one or more columns.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Range addressrange_addresstextRequired: The range in A1 notation, for example 'A1:D10'.
FieldsfieldslistRequired: Sort conditions, for example [{"key": 0, "ascending": true}]. 'key' is the zero-based column offset within the range, not the sheet column.
Has headershas_headerstrue/false: Treat the first row of the range as headers and leave it in place.Default: false.
Match casematch_casetrue/false: Let letter casing affect the ordering.Default: false.
Orientationorientationtext: Sort rows (the usual case) or columns.One of: Rows, Columns.
Drivedrive_idtextRequired: 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_appliednumber: Number of sort conditions applied.

Example output

{
  "fields_applied": 1
}

Sort table

Sort a table on one or more of its columns.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Tabletable_idtextRequired: The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
FieldsfieldslistRequired: Sort conditions, for example [{"key": 0, "ascending": true}]. 'key' is the zero-based column offset within the table.
Match casematch_casetrue/false: Let letter casing affect the ordering.Default: false.
Drivedrive_idtextRequired: 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_appliednumber: Number of sort conditions applied.

Example output

{
  "fields_applied": 1
}

Unmerge cells

Split previously merged cells back apart.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Range addressrange_addresstextRequired: The range in A1 notation, for example 'A1:D10'.
Drivedrive_idtextRequired: 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

unmergedtrue/false: Always true when the cells were unmerged.

Example output

{
  "unmerged": true
}

Unprotect worksheet

Remove protection from a worksheet.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Drivedrive_idtextRequired: 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

protectedtrue/false: Always false once protection was removed.

Example output

{
  "protected": false
}

Update chart

Rename or resize a chart.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Chartchart_idtextRequired: The chart's ID or name. Pick it from the dropdown, or chain it from the 'Add chart' action.
Namenametext: New chart name.
Heightheightnumber: Height in points.At least 0.
Widthwidthnumber: Width in points.At least 0.
Toptopnumber: Distance from the top of the worksheet, in points.At least 0.
Leftleftnumber: Distance from the left of the worksheet, in points.At least 0.
Drivedrive_idtextRequired: 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

heightnumber: Height in points.
idtext: Chart ID.
leftnumber: Distance from the left of the worksheet, in points.
nametext: Chart name.
topnumber: Distance from the top of the worksheet, in points.
widthnumber: Width in points.

Example output

{
  "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

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Range addressrange_addresstextRequired: The range in A1 notation, for example 'A1:D10'.
ValuesvalueslistRequired: Row-major grid of values, for example [["Region", "Revenue"], ["West", 1200]]. A null leaves that cell untouched.
Drivedrive_idtextRequired: 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

valueslist: The grid that was written.

Example output

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

Update table

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

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Tabletable_idtextRequired: The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
Namenametext: New table name.
Show headersshow_headerstrue/false: Show the header row.
Show totalsshow_totalstrue/false: Show the totals row.
Stylestyletext: Built-in table style name, for example 'TableStyleMedium4'.
Drivedrive_idtextRequired: 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

idtext: Table ID.
nametext: Table name.
show_headerstrue/false: Whether the header row is shown.
show_totalstrue/false: Whether the totals row is shown.
styletext: Built-in table style name.

Example output

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

Update table row

Overwrite one row of a table.

Inputs

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Tabletable_idtextRequired: The table's ID or name. Pick it from the dropdown, or chain it from the 'Create table' action.
Row indexrow_indexnumberRequired: Zero-based row index, excluding the header row.At least 0.
ValuesvalueslistRequired: The row's new cell values, for example ["2026-01-15", 49, 37].
Drivedrive_idtextRequired: 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

indexnumber: The row index that was written.
valueslist: The row's cell values.

Example output

{
  "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

Workbookitem_idtextRequired: The workbook's driveItem ID. Pick it from the dropdown, or chain it from the 'List workbooks' action or OneDrive's 'Create workbook'.
Worksheetworksheet_idtextRequired: The worksheet's ID or name. Pick it from the dropdown, or chain it from the 'Add worksheet' action.
Positionpositionnumber: Zero-based position in the tab strip.At least 0.
Visibilityvisibilitytext: Whether the worksheet is shown.One of: Visible, Hidden, VeryHidden (Very hidden (only unhideable through code)).
Drivedrive_idtextRequired: 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

idtext: Worksheet ID.
nametext: Worksheet name.
positionnumber: Zero-based position in the tab strip.
visibilitytext: One of 'Visible', 'Hidden' or 'VeryHidden'.

Example output

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

ActionsCopy Anchor Link

Add chartCopy Anchor Link

Inputs

Outputs

Add named itemCopy Anchor Link

Inputs

Outputs

Add table columnCopy Anchor Link

Inputs

Outputs

Add worksheetCopy Anchor Link

Inputs

Outputs

Append table rowsCopy Anchor Link

Inputs

Outputs

Auto-fit columnsCopy Anchor Link

Inputs

Outputs

Clear rangeCopy Anchor Link

Inputs

Outputs

Clear table filtersCopy Anchor Link

Inputs

Outputs

Convert table to rangeCopy Anchor Link

Inputs

Outputs

Create tableCopy Anchor Link

Inputs

Outputs

Delete cellsCopy Anchor Link

Inputs

Outputs

Delete chartCopy Anchor Link

Inputs

Outputs

Delete tableCopy Anchor Link

Inputs

Outputs

Delete table columnCopy Anchor Link

Inputs

Outputs

Delete table rowCopy Anchor Link

Inputs

Outputs

Delete worksheetCopy Anchor Link

Inputs

Outputs

Format rangeCopy Anchor Link

Inputs

Outputs

Get chart imageCopy Anchor Link

Inputs

Outputs

Get named item rangeCopy Anchor Link

Inputs

Outputs

Get range valuesCopy Anchor Link

Inputs

Outputs

Get tableCopy Anchor Link

Inputs

Outputs

Get table rangeCopy Anchor Link

Inputs

Outputs

Get used rangeCopy Anchor Link

Inputs

Outputs

Get worksheetCopy Anchor Link

Inputs

Outputs

Insert cellsCopy Anchor Link

Inputs

Outputs

List chartsCopy Anchor Link

Inputs

Outputs

Actions

Add chart

Add named item

Add table column

Add worksheet

Append table rows

Auto-fit columns

Clear range

Clear table filters

Convert table to range

Create table

Delete cells

Delete chart

Delete table

Delete table column

Delete table row

Delete worksheet

Format range

Get chart image

Get named item range

Get range values

Get table

Get table range

Get used range

Get worksheet

Insert cells

List charts

List comments

List drives

List named items

List pivot tables

List site drives

List sites

List table columns

List table rows

List tables

List workbooks

List worksheets

Merge cells

Protect worksheet

Reapply table filters

Recalculate workbook

Refresh all pivot tables

Refresh pivot table

Rename worksheet

Run workbook function

Set chart data

Set chart position

Set range formulas

Set range number format

Sort range