Excel Integration

Create a workbook session for persistent or non-persistent changes

2 fields

Close a workbook session

2 fields

Refresh a workbook session to keep it alive

2 fields

Recalculate all formulas in the workbook

2 fields

Execute built-in Excel function (300+ functions available)

3 fields

List all worksheets in a workbook

1 field

Get worksheet details by name

2 fields

Add a new worksheet to the workbook

2 fields

Update worksheet properties (name, visibility, position)

5 fields

Delete a worksheet from the workbook

2 fields

Get the used range of a worksheet (all cells with data)

3 fields

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

4 fields

Insert blank cells and shift existing cells down or right

4 fields

Delete cells and shift remaining cells up or left

4 fields

Merge cells into a single region

4 fields

Unmerge merged cells

3 fields

Sort a range by column

6 fields

Apply formatting to a range (font, fill, borders, alignment)

10 fields

List all tables in the workbook

1 field

Get table details by name

2 fields

Create a new table from a range

5 fields

Delete a table (converts back to range)

2 fields

Convert table to normal range (keeps data, removes table structure)

2 fields

List all rows in a table

2 fields

Add a row to a table

4 fields

Delete a row from a table by index

3 fields

List all columns in a table

2 fields

Add a column to a table

5 fields

Delete a column from a table

3 fields

Sort a table by column

4 fields

Apply auto-filter to a table column

4 fields

Clear filter from a table column

3 fields

List all charts in a worksheet

2 fields

Get chart details by name

3 fields

Create a new chart from data range

5 fields

Update chart properties (title, size, position)

7 fields

Delete a chart from worksheet

3 fields

Get chart as base64-encoded PNG image

5 fields

List all named ranges and items in the workbook

1 field

Get value of a named range or item

2 fields

Create a named range or constant

4 fields