| excel_get_metadataA | Get metadata from an Excel workbook (.xlsx/.xlsm). Returns sheet names, active sheet, dimensions (max rows/cols), and header preview.
Call this first before reading large sheets to inspect the structure.
Args:
file_path: Absolute or relative path to the Excel file.
|
| excel_read_sheetA | Read a rectangular cell range from an Excel sheet. Indices are 1-based (row 1 is first row, col 1 is 'A').
Args:
file_path: Path to the Excel file.
sheet_name: Target sheet name (defaults to active sheet).
start_row: Starting row index (1-based, inclusive, default 1).
end_row: Ending row index (1-based, inclusive, default 50).
start_col: Starting column index (1-based, inclusive, default 1).
end_col: Ending column index (1-based, inclusive, default 20).
evaluate_formulas: If True (default), returns calculated values. If False, returns raw formula strings.
format: 'markdown' (default formatted table) or 'raw' (2D list of values).
|
| excel_searchB | Search for a text query across Excel worksheet cells. Args:
file_path: Absolute or relative path to the Excel file.
query: Text to search for.
sheet_name: Specific sheet name to search in (searches all sheets if omitted).
case_sensitive: Whether matching is case-sensitive (default: False).
max_results: Maximum results to return (default: 50).
|
| excel_write_cellA | Write a value to a specific cell (e.g. 'A1', 'C10') in an Excel sheet. Args:
file_path: Path to the Excel file.
sheet_name: Target sheet name.
coordinate: Cell coordinate (e.g., 'A1', 'B5').
value: The value to write (string, number, boolean, or formula like '=SUM(A1:A5)').
backup: If True, create a backup of the original file before modifying.
|
| excel_write_rangeA | Write a 2D matrix of data starting from a designated top-left cell in an Excel sheet. Args:
file_path: Path to the Excel file.
sheet_name: Target sheet name.
start_cell: Top-left cell coordinate (e.g. 'A1').
data: 2D array of rows and column values to write.
backup: If True, create a backup of the original file before modifying.
|
| excel_append_rowsA | Append one or more rows to the end of an Excel sheet. Args:
file_path: Path to the Excel file.
sheet_name: Target sheet name.
rows: List of rows (each row being a list of cell values).
backup: If True, create a backup of the original file before modifying.
|
| excel_manage_sheetsA | Manage sheets in an Excel workbook (add, rename, delete, copy). Args:
file_path: Path to the Excel file.
action: Action to perform: 'add', 'rename', 'delete', or 'copy'.
sheet_name: Target sheet name.
new_name: New name for the sheet (required for 'rename' and 'copy').
backup: If True, create a backup of the original file before modifying.
|
| excel_create_workbookA | Create a new empty Excel workbook (.xlsx). Args:
file_path: Path where the new Excel file will be created.
sheet_names: Optional list of sheet names to initialize. Defaults to ['Sheet'].
|
| word_get_outlineA | Get the outline of a Word document (.docx). Returns total paragraph count, table count, and all headings with their levels.
Args:
file_path: Path to the Word document (.docx).
|
| word_read_paragraphsA | Read a chunk of paragraphs from a Word document (.docx). Indices are 0-based.
Args:
file_path: Path to the Word document.
start_idx: Starting paragraph index (0-based, default 0).
count: Number of paragraphs to retrieve (default 30).
|
| word_read_tableA | Read a table from a Word document (.docx). Args:
file_path: Path to the Word document.
table_idx: 0-based index of the table (default 0).
format: 'markdown' (default) or 'raw' (2D list of cell text).
|
| word_searchA | Search for a text query across Word paragraphs and tables. Args:
file_path: Path to the Word document (.docx).
query: Text to search for.
case_sensitive: Whether matching is case-sensitive (default: False).
max_results: Maximum results to return (default: 50).
|
| word_append_paragraphA | Append a paragraph or heading to the end of a Word document (.docx). Args:
file_path: Path to the Word document.
text: Text to append.
style: Optional style (e.g., 'Heading 1', 'Heading 2', 'List Bullet', or None for normal body).
backup: If True, create a backup of the original file before modifying.
|
| word_append_table_rowA | Append a new row of data to an existing table in a Word document. Args:
file_path: Path to the Word document.
table_idx: 0-based index of the table.
row_data: List of strings for each column in the new row.
backup: If True, create a backup of the original file before modifying.
|
| word_write_table_cellA | Update text in a specific cell of a table in a Word document. Args:
file_path: Path to the Word document.
table_idx: 0-based index of the table.
row_idx: 0-based row index.
col_idx: 0-based column index.
text: New text content for the cell.
backup: If True, create a backup of the original file before modifying.
|
| word_replace_textA | Find and replace text across paragraphs and tables in a Word document. Args:
file_path: Path to the Word document (.docx).
find_text: Text string to find.
replace_text: Replacement text string.
count: Maximum number of replacements (-1 for all occurrences).
backup: If True, create a backup of the original file before modifying.
|
| word_delete_paragraphA | Delete a specific paragraph from a Word document by its 0-based index. Args:
file_path: Path to the Word document (.docx).
paragraph_idx: 0-based index of the paragraph to delete.
backup: If True, create a backup of the original file before modifying.
|
| word_create_documentA | Create a new empty Word document (.docx) with an optional title. Args:
file_path: Path where the document will be saved.
title: Optional title text.
|
| ppt_get_outlineA | Get the outline of a PowerPoint presentation (.pptx). Returns total slide count and slide-by-slide titles and shape counts.
Args:
file_path: Path to the PowerPoint file.
|
| ppt_read_slideA | Read all text content and table data from a specific slide in a PowerPoint presentation. Args:
file_path: Path to the PowerPoint file.
slide_idx: 0-based index of the slide.
|
| ppt_searchA | Search for a text query across PowerPoint slides, shapes, tables, and notes. Args:
file_path: Path to the PowerPoint file (.pptx).
query: Text to search for.
case_sensitive: Whether matching is case-sensitive (default: False).
max_results: Maximum results to return (default: 50).
|
| ppt_read_notesC | Read the speaker notes of a specific slide in a PowerPoint presentation. Args:
file_path: Path to the PowerPoint file (.pptx).
slide_idx: 0-based index of the slide.
|
| ppt_update_notesA | Update speaker notes for a specific slide in a PowerPoint presentation. Args:
file_path: Path to the PowerPoint file (.pptx).
slide_idx: 0-based slide index.
notes_text: Text content to set as the speaker notes.
backup: If True, create a backup of the original file before modifying.
|
| ppt_add_slideA | Add a new slide to a PowerPoint presentation (.pptx). Args:
file_path: Path to the PowerPoint file.
title: Title for the slide.
content: Optional content text for the body placeholder.
layout_idx: Slide layout index (0=Title Slide, 1=Title and Content). Default 1.
backup: If True, create a backup of the original file before modifying.
|
| ppt_update_slide_textA | Update the text of a specific shape on a slide in a PowerPoint presentation. Args:
file_path: Path to the PowerPoint file.
slide_idx: 0-based slide index.
shape_idx: 0-based shape index within the slide.
text: New text content for the shape.
backup: If True, create a backup of the original file before modifying.
|
| ppt_add_tableA | Add a table to a specific slide in a PowerPoint presentation. Args:
file_path: Path to the PowerPoint file (.pptx).
slide_idx: 0-based index of the slide.
rows: Number of table rows.
cols: Number of table columns.
data: Optional 2D list of cell text values.
left: Left offset position in inches (default: 1.0).
top: Top offset position in inches (default: 2.0).
width: Table width in inches (default: 8.0).
height: Table height in inches (default: 4.0).
backup: If True, create a backup of the original file before modifying.
|
| ppt_add_chartA | Add a native Excel-backed chart to a slide in a PowerPoint presentation. Supported chart types:
- 'column_clustered', 'column_stacked', 'column_stacked_100'
- 'bar_clustered', 'bar_stacked', 'bar_stacked_100'
- 'line', 'line_markers', 'line_stacked'
- 'pie', 'pie_exploded', 'doughnut'
- 'area', 'area_stacked'
Args:
file_path: Path to the PowerPoint file (.pptx).
slide_idx: 0-based index of the slide.
chart_type: Chart type name (e.g., 'column_clustered', 'line', 'pie', 'bar_clustered').
categories: Category labels along the category axis (e.g. ['Q1', 'Q2', 'Q3', 'Q4']).
series_data: List of series dicts, each with 'name' (str) and 'values' (list of numbers).
Example: [{'name': 'Revenue', 'values': [100, 120, 140, 160]}]
title: Optional chart title.
left: Left offset position in inches (default: 1.0).
top: Top offset position in inches (default: 1.5).
width: Chart width in inches (default: 8.0).
height: Chart height in inches (default: 4.5).
backup: If True, create a backup of the original file before modifying.
|
| ppt_add_flowchartA | Add an editable flowchart or architecture diagram to a PowerPoint slide using Mermaid syntax. Nodes are rendered as native PowerPoint shapes (Rounded Rectangles, Diamonds for conditions,
Ovals/Stadiums) connected by native connector arrows with arrowheads.
All text, colors, shapes, and layouts remain 100% editable inside PowerPoint.
Supported Mermaid Syntax:
- Direction: 'graph TD' / 'flowchart TD' (Top-Down), 'graph LR' / 'flowchart LR' (Left-Right)
- Box node: `NodeID[Node Label]`
- Rounded node: `NodeID(Node Label)`
- Condition/Decision node: `NodeID{Condition Label}`
- Stadium/Pill node: `NodeID([Label])`
- Line breaks in labels: `<br/>` or `\n`
- Arrows: `A --> B`, `A -->|label| B`, `A --- B`, `A ==> B`, `A -.-> B`
- Chain connections: `A --> B --> C`
Args:
file_path: Path to the PowerPoint file (.pptx).
slide_idx: 0-based index of the slide (auto-creates slide if presentation is empty).
mermaid_code: Mermaid diagram code string.
title: Optional slide title to display at the top.
direction: Layout direction: 'auto' (detect from code), 'TD' (Top-Down), or 'LR' (Left-Right).
left: Left margin offset in inches (default: 0.8).
top: Top margin offset in inches (default: 1.6).
width: Total width allocated for diagram in inches (default: 8.4).
height: Total height allocated for diagram in inches (default: 5.0).
backup: If True, create a backup of the original file before modifying.
|
| ppt_create_presentationA | Create a new empty PowerPoint presentation (.pptx) with an optional title slide. Args:
file_path: Path where the presentation will be saved.
title: Optional title for the first slide.
|
