List all sheets and metadata of an Excel workbook

Read complete data from a sheet (with optional range)

Read a specific range of cells

Read value from a specific cell

Read the formula from a specific cell

Create a new Excel file with data

Update value of a specific cell

Write multiple cells simultaneously

Add a row at the end of the sheet

Set or modify a formula in a cell

Change cell formatting (color, font, borders, alignment)

Adjust width of a column

Adjust height of a row

Merge cells in a range

Create a new sheet in the workbook

Delete a sheet from the workbook

Rename a sheet

Duplicate a complete sheet

Delete specific rows

Delete specific columns

Copy range to another location

Search for a value in sheet/range

Filter rows by condition

Create a chart (line, bar, column, pie, scatter, area)

Create a pivot table for data analysis

Convert a range to an Excel table with formatting

Validate Excel formula syntax without applying it

Validate if a range string is valid

Get data validation rules for a cell

Insert rows at a specific position

Insert columns at a specific position

Unmerge previously merged cells

List all merged cell ranges in a sheet

Apply conditional formatting to a range