Excel: Integration für KI-Agenten
Read, update, and format cells in your workbooks
Verbinde Excel mit Langdock und nutze es im Chat, in Agenten und in Workflows.
26 Actions
Beschreibungen, Actions und Beispiel-Prompts kommen direkt aus dem Produkt und sind dort auf Englisch verfasst.
Actions für Excel
Jede Action ist ein Schritt, den ein Agent oder Workflow in Excel ausführen kann.
- Add sheet to workbook
Adds a worksheet to an existing Excel workbook.
- Add table row
Adds a new row to the end of a table.
- Clear range
Clears cell contents, formatting, or both from a range without deleting the cells.
- Create chart
Creates a chart from data in a range.
- Create table
Creates a new table from a cell range. Tables enable filtering, sorting, and structured references.
- Delete column
Deletes a column from a worksheet, shifting remaining columns left.
- Delete row
Deletes a row from a worksheet, shifting remaining rows up.
- Delete table row
Deletes a specific row from a table given its row index.
- Format cells
Applies formatting to cells including font styles, background colors, and borders.
- Get all table columns
Retrieves all columns from a table.
- Get range
Retrieves data from a specified cell range in a worksheet. Use this to read data that is not in a table.
- Get sheet by item id
Retrieves all worksheets of an Excel workbook.
- Get single table row
Retrieves a specific row from a table given its row index.
- Get table rows
Retrieves rows from a table with pagination support, including the table name. Use this to read data from Excel tables.
- Get tables
Retrieves all tables from a worksheet, specified by item id and sheet id.
- Get workbook summary
Retrieves a summary of an Excel workbook including all sheets, their data ranges, tables, and charts.
- Insert column
Inserts a new empty column to the left or right of a specified column, shifting existing columns.
- Insert formulas
Inserts Excel formulas into cells at a specified range. Use this to add calculations like =SUM(), =AVERAGE(), =IF(), etc.
- Insert row
Inserts a new empty row above or below a specified row, shifting existing rows down.
- Merge cells
Merges cells in a range into a single cell.
- Search files
Searches for Excel files by name or resolves a OneDrive / SharePoint URL. Returns file ID, driveId, name, URL, and metadata for use with other Excel actions.
- Set alignment
Sets text alignment for cells (horizontal and vertical).
- Set number format
Sets the number format for cells (currency, percentage, date, etc.).
- Sort range
Sorts data in a range by one or more columns.
- Update cells
Updates cells in a worksheet at a specified range.
- Update table row
Updates values in a specific row or range within an Excel table.
Agenten-Vorlagen mit Excel
Einrichtung und Berechtigungen
Eine Action kann nach deiner Bestätigung fragen, bevor sie ausgeführt wird. In einem Agenten steht jede Action auf „Immer erlauben“ oder „Braucht Bestätigung“.