Workbook Operations
create_workbook
Creates a new Excel workbook
get_workbook_metadata
Get metadata about workbook including sheets and ranges
Data Operations
write_data_to_excel
Write data to Excel worksheet with intelligent header handling
read_data_from_excel
Read data from Excel worksheet with optional preview mode
Formatting Operations
format_range
Apply comprehensive formatting to cell ranges including fonts, colors, borders, alignment, and conditional formatting
merge_cells
Merge a range of cells
unmerge_cells
Unmerge a previously merged range of cells
Formula Operations
apply_formula
Apply Excel formula to cell
validate_formula_syntax
Validate Excel formula syntax without applying it
Chart Operations
create_chart
Create charts in worksheet supporting line, bar, pie, scatter, and area chart types
Pivot Table Operations
create_pivot_table
Create pivot table in worksheet with multiple aggregation functions (sum, count, average, max, min)
Worksheet Operations
create_worksheet
Creates a new worksheet in an existing workbook
copy_worksheet
Copy worksheet within workbook
delete_worksheet
Delete worksheet from workbook
rename_worksheet
Rename worksheet in workbook
Range Operations
copy_range
Copy a range of cells to another location
delete_range
Delete a range of cells and shift remaining cells
validate_excel_range
Validate if a range exists and is properly formatted
