List Table ColumnsRetrieve a list of table column objects.
List Table RowsRetrieve a list of table row objects.
List TablesRetrieve a list of table objects.
List WorksheetRetrieve a list of worksheet objects.
List Worksheet NamesRetrieve a list of named item associated with the worksheet.
List Worksheet TablesRetrieve a list of tables in a worksheets.
Retrieve a Header Row RangeGets the range object associated with the header row of the column.
Retrieve a TableRetrieve a single table object.
Retrieve a Table ColumnRequest a single table column object.
Retrieve a Table Column Body RangeGets the range object associated with the data body of the column.
Retrieve a Table Column ItemGets a column based on its position in the collection.
Retrieve a Table Column RangeGets the range object associated with the entire column.
Retrieve a Table RowRequest a single row of a table.
Retrieve a Table Row ItemGets a row based on its position in the collection.
Retrieve a Table Row RangeReturns the range object associated with the entire row.
Retrieve a Table SortRetrieve a of table sort object.
Retrieve a Total Row RangeGets the range object associated with the totals row of the column.
Retrieve a WorksheetRetrieve a single worksheet.
Retrieve a Worksheet CellGets the range object containing the single cell based on row and column numbers.
Retrieve a Worksheet RangeGets the range object specified by the address or name.
Add a Table ColumnAdds a new column to the table.
Add a Table RowAdds rows to the end of the table.
Apply a Table SortPerform a sort operation.
Clear a Table SortClears the sorting that is currently on the table.
Close a Workbook SessionClose an existing workbook session.
Create a TableCreates a new table.
Create a Workbook SessionCreate a new workbook session.
Create a WorksheetAdd a new worksheet to the workbook.
Create a Worksheet TableCreate a new table in a worksheet.
Delete a TableDeletes the table.
Delete a Table ColumnDeletes the column from the table.
Delete a Table RowDeletes a row from the table.
Delete a WorksheetDeletes the worksheet from the workbook.
Make an API CallPerform an arbitrary authorized API request.
Re-Apply a Table SortRe-applies the current sorting parameters to the table.
Refresh a Workbook SessionRefresh an existing workbook session.
Update a TableUpdate the properties of table object.
Update a Table ColumnUpdate the properties of table column object.
Update a Table RowUpdate the properties of a table row object.
Update a WorksheetUpdate the properties of worksheet object.
When to use Microsoft Excel
Common scenarios where Microsoft Excel automation saves time and reduces manual work.
Automate "List Table Columns" in Microsoft Excel as a workflow step — combine it with triggers, filters, and AI steps for full-pipeline coverage.
Run "List Table Rows" in Microsoft Excel from any upstream event — map fields once and let the automation handle the rest.
Layer "List Tables" from Microsoft Excel with filters, transforms, and AI steps to build automations that match your exact business logic.
Frequently asked questions
Common questions about automating Microsoft Excel in your workflows.
Microsoft Excel has no triggers, but it provides 40 actions including "List Table Columns", "List Table Rows", and "List Tables". Pair them with triggers from other apps to automate Microsoft Excel tasks.
Connect Microsoft Excel to any app in workflows
Search apps and open an app-to-app integration page in one click.