Microsoft Office

List every pivot table in the workbook with its name and the worksheet it lives on. Use this to discover existing pivot tables before refreshing them with `rebel_office_excel_refresh_pivot_table`.

List all worksheets in the active workbook with their names, positions, visibility, and basic info (used range, row/column counts). Use this to discover available sheets before reading or writing data. Related tools: Use `rebel_office_excel_add_worksheet` to create new sheets.

Insert new rows or columns into a worksheet. Existing data shifts to accommodate the insertion. Use for adding space for new data, inserting summary rows, or expanding tables.

Merge or unmerge cells in a range. Merged cells combine into a single cell displaying the upper-left value. Use for headers spanning multiple columns or creating visual groupings. **Warning: merging discards values from all cells except the upper-left.**

Read cell values from a range in the active workbook. Returns data as a 2D array with column headers from the first row (if `hasHeaders` is true) or as raw arrays. For named ranges, provide the range name directly. For tables, prefer `rebel_office_excel_read_table`. Common use cases: reading data for analysis, extracting specific cells, getting a table snapshot. Related tools: Use `rebel_office_excel_get_worksheets` to discover available sheets, or `rebel_office_excel_get_named_ranges` to find named ranges.

Read data from a named Excel table (ListObject). Returns headers and rows with type information. Tables are structured ranges with automatic filtering and sorting capabilities. Preferred over `rebel_office_excel_read_range` for structured data. Related tools: Use `rebel_office_excel_get_named_ranges` to discover available tables.

Refresh a pivot table so it reflects the current source data. Pass `name` to refresh one pivot table, or omit it to refresh every pivot table in the workbook. Use `rebel_office_excel_get_pivot_tables` to list available names.

Set a formula in one or more cells. Supports standard Excel formulas (SUM, VLOOKUP, IF, etc.), array formulas, and dynamic array formulas. The formula is entered exactly as provided — include the leading `=`. For bulk formulas applied to a column, use the `fillDown` option. Common use cases: adding calculated columns, creating summary formulas, building dashboards.

Sort a range or table by one or more columns. Supports ascending/descending order and multi-level sorting. When sorting a table, use column names; when sorting a range, use column letters or indices. Related tools: Use `rebel_office_excel_filter_table` to filter without reordering data.

Write values to cells in the active workbook. Provide data as a 2D array of values. Supports numbers, strings, booleans, and null (for empty cells). Auto-expands the target range to fit the data dimensions. Use `rebel_office_excel_set_formula` for formula cells. Common use cases: populating a spreadsheet, updating existing data, bulk data entry.

Add an image to a slide from a file path or base64 data. Position and size the image precisely on the slide. Supports PNG, JPEG, GIF, and SVG formats.

Add a geometric shape to a slide. Supports rectangles, circles, arrows, stars, callouts, and more. Shapes can contain text and have fill colors and line styles.

Add a new slide to the presentation. Specify a layout and optional initial content (title, subtitle, body text). The slide is inserted at the specified position or at the end. The layout is resolved by name (case-insensitive) against the presentation's slide masters — theme layouts work, not just the defaults. Standard PowerPoint layouts: "Title Slide", "Title and Content", "Section Header", "Two Content", "Comparison", "Title Only", "Blank". Use `rebel_office_powerpoint_get_presentation_properties` to list the available layouts, and `rebel_office_powerpoint_apply_layout` to change the layout…

Add a text box to a slide at a specified position. Configure font, size, color, and alignment. Text boxes are independent shapes — for content in a slide layout's placeholder, use `rebel_office_powerpoint_update_text` instead.

Change the layout of an existing slide — e.g. switch a slide from "Title and Content" to "Two Content". The layout is resolved by name (case-insensitive) against the presentation's slide masters; theme layouts work, not just the defaults. Use `rebel_office_powerpoint_get_presentation_properties` to list the available layouts. Requires a PowerPoint version with layout support (PowerPointApi 1.8+).

Delete a shape from a slide, identified by shape ID or by placeholder/name match. Use `rebel_office_powerpoint_get_slide_content` to list a slide's shapes and their IDs first. This cannot be undone from the API — delete with care.

Delete a slide from the presentation by index. **This permanently removes the slide and all its content — cannot be undone.** Returns confirmation.

Format an existing shape: fill color, line color/width, position (left/top), size (width/height, in points), or rename it. Shapes are identified by shape ID or by placeholder/name match. Use `rebel_office_powerpoint_get_slide_content` to list a slide's shapes and their IDs first.

Get the presentation's metadata — title, slide dimensions, slide count, layout names, and theme information. Use to understand the presentation context before making changes.

Get the full content of a specific slide — all shapes, text boxes, images, and their properties (position, size, text content, formatting). Use after `rebel_office_powerpoint_get_slides` to drill into a specific slide for detailed reading or editing.

List all slides in the active presentation with summaries — slide number, layout, title text (if any), and shape count. Use this to understand the presentation structure before making targeted edits. Returns a compact overview; use `rebel_office_powerpoint_get_slide_content` for full details on a specific slide.

Read speaker notes for one or all slides. Returns the notes text for each slide. Speaker notes are the presenter's script — often used for meeting talking points, cue cards, or detailed explanations not shown to the audience.

Move a slide to a new position in the presentation. Reorders the slide deck without modifying content. Use for restructuring presentation flow.

Set or update the speaker notes for a slide. Replaces any existing notes. Use for adding presenter talking points, meeting prep notes, or detailed explanations. Notes support plain text with basic line breaks.

Update existing text in a shape or placeholder on a slide. Identify the target by shape ID (from `rebel_office_powerpoint_get_slide_content`) or by placeholder type ("title", "subtitle", "body"). Use this to modify existing content rather than adding new shapes.

Re-installs or uninstalls the Rebel add-in in Microsoft Office (Word, Excel, PowerPoint). You usually do NOT need to run this manually — the first Office tool call lazily starts the sidecar, which installs the add-in manifest automatically. Use this tool only to: • Force a re-install after deleting manifests manually • Uninstall the add-in (action="uninstall") After install, open (or restart) Word, Excel, or PowerPoint. The Rebel button will appear in the Home ribbon, under the "Add ons" menu; click it to open the panel and see "Connected".

Check which Office applications are currently connected to Rebel. Returns connection status for Word, Excel, and PowerPoint, plus sidecar health information. Use this to verify the connection before running other tools, or to diagnose issues when tools return "not connected" errors.

Accept or reject tracked changes in the document. Can target specific changes by ID, all changes, or all changes from a specific author. Get change IDs from `rebel_office_word_get_tracked_changes`. Common use cases: bulk-accepting all tracked changes after review, rejecting changes from a specific reviewer, selectively accepting individual edits.

Add a comment to the document at a specified location — the current selection, a paragraph, or text matching a search term. If replying to an existing comment, provide the parent comment ID to create a threaded reply. Get comment IDs from `rebel_office_word_get_comments`. Common use cases: providing feedback on specific paragraphs, noting issues, asking questions about document content.

Apply a named paragraph style to existing paragraphs — built-in styles like "Heading 1", "Title", or "Quote", or any custom style defined in the document. Target the current selection, a range of paragraphs, or every paragraph containing a search text. Styles are how Word documents stay consistent — prefer this over manual font formatting (`rebel_office_word_format_text`) when making headings, quotes, or other structural text look intentional. To style new text at insertion time, use `rebel_office_word_insert_text` with its `style` parameter.

Search for text occurrences in the document. Returns matching locations with surrounding context. Supports case-sensitive and whole-word matching. Use before `rebel_office_word_replace_text` to preview what will be changed, or to locate specific content for commenting or formatting. Common use cases: finding all mentions of a term, locating a specific section, previewing search-and-replace matches before executing.

Apply formatting to text at a specified location — a paragraph range, the current selection, or text matching a search term. Supports font family, size, color, bold, italic, underline, highlight, and alignment. For more complex formatting, use Word styles via `rebel_office_word_insert_text` with the `style` parameter. Common use cases: making headings bold, changing font color for emphasis, highlighting key phrases, adjusting paragraph alignment.

Read all comments in the document. Returns each comment with its author, date, associated text range, content, reply thread, and resolved status. Use to review feedback, track discussion threads, or prepare a comment summary. Related tools: Use `rebel_office_word_add_comment` to add new comments, `rebel_office_word_resolve_comment` to resolve or delete them.

Get the outline structure of the currently open Word document — headings, sections, and page counts. Returns a hierarchical tree of headings with their levels and paragraph indices. Useful for understanding document organization before making targeted edits, building a table of contents, or navigating to specific sections. Related tools: Use `rebel_office_word_read_document` with `startParagraph` to read content at a specific heading location.

Get the document's metadata properties — title, author, creation date, last modified, word count, page count, and custom properties. Useful for understanding document context and provenance before making edits or when summarizing document metadata.

Get the currently selected text in the Word document. Returns the text content and location of whatever the user has highlighted. Useful for working with user-indicated content — "format this", "comment on this", "move this paragraph". Related tools: After reading the selection, use `rebel_office_word_insert_text` with location "replaceSelection" to replace it, or `rebel_office_word_add_comment` with target type "selection" to comment on it.

Read tracked changes (revisions) in the document. Returns each change with its type (insertion, deletion, format change), author, date, and content. Use to review edits before accepting or rejecting them. Related tools: Use `rebel_office_word_accept_reject_changes` to accept or reject the changes.

Insert a page break or section break into the document. Page breaks start a new page; section breaks start a new section (allowing different headers/footers/page layouts). Common use cases: separating chapters, starting appendices on a new page, creating sections with different page orientations or margins.

Insert an image into the document from a file path or base64 data. The image is inserted at the end or after a specific paragraph. Supports width/height control — aspect ratio is maintained if only one dimension is specified. Common use cases: adding screenshots, logos, charts generated externally, diagrams.

Insert a table into the document. Provide headers and rows of data. The table is inserted at the end of the document or after a specific paragraph. Tables are created with the default Word table style; specify a `style` for custom styling (e.g., "Grid Table 4 - Accent 1"). Common use cases: adding comparison tables, data summaries, structured lists, pricing tables.

Insert text into the document at a specified location. Can insert at the beginning, end, before/after a specific paragraph, or replace the current selection. Text can include basic markdown-style formatting that gets converted to Word formatting. When track changes is enabled in the document, insertions appear as tracked additions. Common use cases: adding new paragraphs, appending content, replacing selected text, inserting text at a specific location in the document. Related tools: Use `rebel_office_word_read_document` to find the right paragraph index, or `rebel_office_word_get_selection…

Read the content of the currently open Word document. Returns the full text organized by paragraphs with heading levels, styles, and structure markers. Use this to understand what's in a document before making edits. For very large documents, use the `maxParagraphs` parameter to limit output and `startParagraph` to paginate through content. Common use cases: reviewing a draft, extracting key points, understanding document structure before making targeted edits. Related tools: Use `rebel_office_word_get_document_structure` for a heading outline, or `rebel_office_word_find_text` to locate spe…

Read a table in the document as a 2D array of cell text. Tables are indexed 0-based in document order; omit `tableIndex` to read the first table. Use this to see what a table contains before editing it with `rebel_office_word_update_table_cell`. Create new tables with `rebel_office_word_insert_table`.

Find and replace text throughout the document. Supports case-sensitive and whole-word matching. Use `rebel_office_word_find_text` first to preview matches before executing the replacement. When track changes is enabled, replacements appear as tracked changes (delete original + insert replacement). Returns the number of replacements made. Common use cases: fixing typos throughout a document, updating terminology, standardizing formatting or naming conventions.

Resolve or delete a comment by its ID. Resolving marks a comment as addressed without removing it; deleting removes it entirely. Get comment IDs from `rebel_office_word_get_comments`. Common use cases: marking feedback as addressed, cleaning up resolved discussion threads.

Set the header or footer text for the document. Can target the first page, odd pages, or even pages. Supports plain text and basic formatting. Use special placeholders: `{PAGE}` for page number, `{NUMPAGES}` for total pages, `{DATE}` for current date. Common use cases: adding page numbers, document titles, dates, or company branding to headers and footers.

Replace the text of a single cell in an existing table. Row and column indexes are 0-based (the top-left cell is row 0, column 0). Pass an empty `text` to clear a cell. Use `rebel_office_word_read_table` first to see the current contents and dimensions.