Connect Hermes to Excel

Create a workbook session for persistent or non-persistent changes

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)

List all worksheets in a workbook

Get worksheet details by name

Add a new worksheet to the workbook

Update worksheet properties (name, visibility, position)

Delete a worksheet from the workbook

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

Get data from a specific cell range

Update cell values, formulas, or formatting in a range

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)

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)

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