Read data from an Excel (.xlsx) file.

Args:

• filePath (string): Absolute or relative path to the Excel file

• sheetName (string, optional): Name of the sheet to read. Defaults to first sheet

• range (string, optional): Cell range to read, e.g. "A1:C10". Reads all data if not specified

Returns: { "sheetName": string, "headers": string[], "rows": object[], "totalRows": number, "totalColumns": number }

Examples:

• Use when: "Read the sales data from report.xlsx"

• Use when: "What are the column headers in Sheet2 of data.xlsx?"

• Don't use when: You need to write data to Excel (use office_write_excel instead)

Write or append data to an existing Excel (.xlsx) file.

Args:

• filePath (string): Path to the Excel file

• data (array of arrays): 2D array of values to write

• sheetName (string, optional): Target sheet name (default: "Sheet1")

• startCell (string, optional): Starting cell, e.g. "A1" (default: "A1")

Examples:

• Use when: "Add these numbers to the existing budget.xlsx"

• Use when: "Write the updated inventory list to Sheet2 of data.xlsx starting at B3"

• Don't use when: You need to create a new Excel file (use office_create_excel instead)

Create a new Excel (.xlsx) file with headers and data.

Args:

• filePath (string): Path where the new Excel file will be created

• headers (array of strings): Column headers

• rows (array of arrays): Data rows

• sheetName (string, optional): Sheet name (default: "Sheet1")

• columnWidths (array of numbers, optional): Custom column widths

Examples:

• Use when: "Create a new spreadsheet for the project budget"

• Use when: "Generate an Excel report with employee data"

• Don't use when: The file already exists and you want to append data (use office_write_excel instead)

Get information about an Excel file, including all sheet names and dimensions.

Args:

• filePath (string): Path to the Excel file

Returns: { "sheets": [ { "name": string, "rowCount": number, "columnCount": number } ] }

Examples:

• Use when: "What sheets are in this Excel file?"

• Use when: "How big is the data in report.xlsx?"

• Use when: "List all sheets in the workbook"

Create a new Word (.docx) document with rich content (headings, paragraphs, lists, tables).

Args:

• filePath (string): Path where the document will be created

• contents (array of content objects): Document content. Each content object has:

  • type: "paragraph" | "heading" | "bullet" | "numbered" | "table"

  • text: string (for paragraph, heading, bullet, numbered)

  • level: number (for heading: 1-3, for lists: 0-based level)

  • rows: string[][] (for table type)

  • bold: boolean (optional)

  • italic: boolean (optional)

• title (string, optional): Document title

• author (string, optional): Document author

Examples:

• Use when: "Create a report document with headings and bullet points"

• Use when: "Generate a Word document with a table of data"

• Use when: "Write a meeting notes document"

Get basic information about a Word (.docx) file.

Args:

• filePath (string): Path to the Word document

Returns basic file info (name, size, path).

Examples:

• Use when: "Check if the Word document exists and how large it is"

• Use when: "Get info about the report.docx file"

Create a new PowerPoint (.pptx) with one slide containing a chart.

Args:

• filePath (string): Path where the presentation will be created

• chart (object): Chart configuration

  • type (string): Chart type: "area" | "bar" | "bar3D" | "bubble" | "doughnut" | "line" | "pie" | "radar" | "scatter"

  • data (array): Data series. Each series has:

    • labels (string[]): Category labels

    • name (string): Series name

    • values (number[]): Data values

  • options (object, optional):

    • showLegend (boolean): Show legend

    • showTitle (boolean): Show title

    • chartColors (string[]): Custom color palette

    • barDirection ("bar" | "col"): Bar direction (for bar charts)

    • barGrouping ("clustered" | "stacked" | "percentStacked"): Bar grouping

    • dataLabelFormat (string): Data label format code (e.g. "#,##0")

Examples:

• Use when: "Create a bar chart showing quarterly sales data"

• Use when: "Generate a pie chart of market share distribution"

• Use when: "Make a line chart of revenue trends over time"

• Not for: Simple text slides with bullets (use office_create_powerpoint instead)

Create a new PowerPoint (.pptx) with one slide containing a shape.

Args:

• filePath (string): Path where the presentation will be created

• shape (string): Shape type name (e.g. 'rect', 'ellipse', 'triangle', 'star5', 'heart', 'cloud', 'lightningBolt', 'smileyFace', 'chevron', 'pentagon', 'hexagon', 'octagon', 'diamond', 'moon', 'sun', 'pie', 'arc', 'frame', 'cube', 'plus', 'wave', 'funnel', 'bevel', 'donut', 'corner', 'heart', 'plaque', 'ribbon', 'line', etc.)

• options (object, optional):

  • x (number): Left position (inches)

  • y (number): Top position (inches)

  • w (number): Width (inches)

  • h (number): Height (inches)

  • fillColor (string): Fill color (hex, e.g. "4472C4")

  • lineColor (string): Line/border color (hex)

  • lineSize (number): Line width (points)

  • rotate (number): Rotation (degrees, -360 to 360)

Examples:

• Use when: "Draw a red rectangle" or "Create a slide with a blue circle"

• Use when: "Add a star shape to the presentation"

• Use when: "Create a flowchart shape like a diamond or process box"

Create a new PowerPoint (.pptx) with one slide containing an image.

Args:

• filePath (string): Path where the presentation will be created

• image (object): Image configuration

  • path (string): Path to the image file

  • options (object, optional):

    • x (number): Left position (inches)

    • y (number): Top position (inches)

    • w (number): Width (inches)

    • h (number): Height (inches)

    • rotate (number): Rotation (degrees)

    • sizing ("cover" | "contain" | "stretch"): Image sizing mode

Examples:

• Use when: "Create a slide with the company logo"

• Use when: "Add a screenshot image to a presentation slide"

• Not for: Creating slides without images

Create a new PowerPoint (.pptx) with one slide containing a formatted table.

Args:

• filePath (string): Path where the presentation will be created

• table (object): Table configuration

  • headers (string[]): Column headers

  • rows (string[][]): Data rows

  • options (object, optional):

    • fontSize (number): Font size

    • fontFace (string): Font name

    • borderColor (string): Border color (hex)

    • colW (number[]): Column widths (inches)

Examples:

• Use when: "Create a slide with a sales data table"

• Use when: "Make a comparison table slide"

• Use when: "Generate a KPI dashboard table slide"

• Not for: Simple text slides (use office_create_powerpoint instead)

Create a new PowerPoint (.pptx) presentation with slides containing titles, subtitles, and bullet content.

Args:

• filePath (string): Path where the presentation will be created

• slides (array of slide objects): Each slide has:

  • title (string, optional): Slide title

  • subtitle (string, optional): Slide subtitle

  • content (array of strings, optional): Bullet points for the slide

Examples:

• Use when: "Create a presentation about the quarterly results"

• Use when: "Generate a slide deck for the project kickoff meeting"

• Use when: "Make a 5-slide summary presentation"

Add slides to an existing PowerPoint (.pptx) presentation.

Args:

• filePath (string): Path to the existing presentation

• slides (array of slide objects): Slides to add

Each slide can have:

• title (string, optional): Slide title

• subtitle (string, optional): Slide subtitle

• content (array of strings, optional): Bullet points

Examples:

• Use when: "Add a summary slide to the existing presentation"

• Use when: "Append more slides to the quarterly report deck"