Excel automation
Create a workbook session for persistent or non-persistent changes
2 fields
Close a workbook session
Refresh a workbook session to keep it alive
Recalculate all formulas in the workbook
Execute built-in Excel function (300+ functions available)
3 fields
List all worksheets in a workbook
1 field
Get worksheet details by name
Add a new worksheet to the workbook
Update worksheet properties (name, visibility, position)
5 fields
Delete a worksheet from the workbook
Get the used range of a worksheet (all cells with data)
Get data from a specific cell range
4 fields
Update cell values, formulas, or formatting in a range
6 fields
Clear content, format, or both from a range
Insert blank cells and shift existing cells down or right
Delete cells and shift remaining cells up or left
Merge cells into a single region
Unmerge merged cells
Sort a range by column
Apply formatting to a range (font, fill, borders, alignment)
10 fields
List all tables in the workbook
Get table details by name
Create a new table from a range
Delete a table (converts back to range)
Convert table to normal range (keeps data, removes table structure)
List all rows in a table
Add a row to a table
Delete a row from a table by index
List all columns in a table
Add a column to a table
Delete a column from a table
Sort a table by column
Apply auto-filter to a table column
Clear filter from a table column
List all charts in a worksheet
Get chart details by name
Create a new chart from data range
Update chart properties (title, size, position)
7 fields
Delete a chart from worksheet
Get chart as base64-encoded PNG image
List all named ranges and items in the workbook
Get value of a named range or item
Create a named range or constant
Start building workflows in minutes with our visual builder. No code required.