Tool reference
All 28 MCP tools organized by category.
Session management
create_session
Create a new workbook session. Returns a session ID for subsequent calls.
close_session
Close a session and release all associated resources.
session_idstring— Session to closesession_status
Get session info including open workbook count.
session_idstring— Session to queryWorkbook operations
create_workbook
Create a new .xlsx workbook within a session.
session_idstring— Target sessionopen_workbook
Open an existing .xlsx file from disk.
session_idstring— Target sessionfile_pathstring— Path to .xlsx filesave_workbook
Save workbook to disk.
session_idstring— Target sessionworkbook_idstring— Workbook to savefile_pathstring— Output pathclose_workbook
Close a workbook within a session.
session_idstring— Target sessionworkbook_idstring— Workbook to closeSheet management
add_sheet
Add a new worksheet to a workbook.
session_idstring— workbook_idstring— sheet_namestring— Name for the new sheetlist_sheets
List all sheets in a workbook.
session_idstring— workbook_idstring— rename_sheet
Rename a worksheet.
session_idstring— workbook_idstring— old_namestring— Current namenew_namestring— New nameCell & range
write_cell
Write a value to a single cell.
session_idstring— workbook_idstring— sheet_namestring— cell_referencestring— e.g. A1valueany— string, number, boolean, or dateread_cell
Read a value from a single cell.
session_idstring— workbook_idstring— sheet_namestring— cell_referencestring— e.g. A1write_range
Write values to a cell range (2D array).
session_idstring— workbook_idstring— sheet_namestring— rangestring— e.g. A1:C10valuesunknown[][]— 2D array of valuesread_range
Read values from a cell range.
session_idstring— workbook_idstring— sheet_namestring— rangestring— e.g. A1:C10Formatting
apply_format
Apply font, fill, border, and alignment to a range.
session_idstring— workbook_idstring— sheet_namestring— rangestring— formatobject— Format optionsset_column_width
Set column width.
session_idstring— workbook_idstring— sheet_namestring— columnstring— Column letterwidthnumber— Width in charactersset_row_height
Set row height.
session_idstring— workbook_idstring— sheet_namestring— rownumber— Row numberheightnumber— Height in pointsmerge_cells
Merge a cell range.
session_idstring— workbook_idstring— sheet_namestring— rangestring— unmerge_cells
Unmerge a cell range.
session_idstring— workbook_idstring— sheet_namestring— rangestring— Formulas
set_formula
Set a formula on a cell.
session_idstring— workbook_idstring— sheet_namestring— cell_referencestring— formulastring— e.g. SUM(A1:A10)get_formula
Read the formula text from a cell.
session_idstring— workbook_idstring— sheet_namestring— cell_referencestring— calculate
Trigger formula recalculation.
session_idstring— workbook_idstring— Data validation
add_data_validation
Add a validation rule to a range.
session_idstring— workbook_idstring— sheet_namestring— rangestring— validation_typestring— list, number, date, customcriteriaobject— Validation criteriaremove_data_validation
Remove validation from a range.
session_idstring— workbook_idstring— sheet_namestring— rangestring— Charts
add_chart
Add a chart to a sheet.
session_idstring— workbook_idstring— sheet_namestring— chart_typestring— bar, line, pie, scatterdata_rangestring— Range containing datatitlestring— Chart titlelist_charts
List all charts in a sheet.
session_idstring— workbook_idstring— sheet_namestring— remove_chart
Remove a chart from a sheet.
session_idstring— workbook_idstring— sheet_namestring— chart_idstring— Chart to remove