apply_formula
Apply Excel formula to cell.
Excel formula will write to cell with verification.
Try it
validate_formula_syntax
Validate Excel formula syntax without applying it.
Try it
format_range
Apply formatting to a range of cells.
Try it
read_data_from_excel
Read data from Excel worksheet with cell metadata including validation rules.
Args:
filepath: Path to Excel file
sheet_name: Name of worksheet
start_cell: Starting cell (default A1)
end_cell: Ending cell (optional, auto-expands if not provided)
preview_only: Whether to return preview only
Returns:
JSON string containing structured cell data with validation metadata.
Each cell includes: address, value, row, column, and validation info (if any).
Try it
write_data_to_excel
Write data to Excel worksheet.
Excel formula will write to cell without any verification.
PARAMETERS:
filepath: Path to Excel file
sheet_name: Name of worksheet to write to
data: List of lists containing data to write to the worksheet, sublists are assumed to be rows
start_cell: Cell to start writing to, default is "A1"
Try it
create_workbook
Create new Excel workbook.
Try it
create_worksheet
Create new worksheet in workbook.
Try it
create_chart
Create chart in worksheet.
Try it
create_pivot_table
Create pivot table in worksheet.
Try it
create_table
Creates a native Excel table from a specified range of data.
Try it
copy_worksheet
Copy worksheet within workbook.
Try it
delete_worksheet
Delete worksheet from workbook.
Try it
rename_worksheet
Rename worksheet in workbook.
Try it
get_workbook_metadata
Get metadata about workbook including sheets, ranges, etc.
Try it
merge_cells
Merge a range of cells.
Try it
unmerge_cells
Unmerge a range of cells.
Try it
get_merged_cells
Get merged cells in a worksheet.
Try it
copy_range
Copy a range of cells to another location.
Try it
delete_range
Delete a range of cells and shift remaining cells.
Try it
validate_excel_range
Validate if a range exists and is properly formatted.
Try it
get_data_validation_info
Get all data validation rules in a worksheet.
This tool helps identify which cell ranges have validation rules
and what types of validation are applied.
Args:
filepath: Path to Excel file
sheet_name: Name of worksheet
Returns:
JSON string containing all validation rules in the worksheet
Try it
insert_rows
Insert one or more rows starting at the specified row.
Try it
insert_columns
Insert one or more columns starting at the specified column.
Try it
delete_sheet_rows
Delete one or more rows starting at the specified row.
Try it
delete_sheet_columns
Delete one or more columns starting at the specified column.
Try it
