Skip to main content

​
Overview

Spreadsheet software for data organization, analysis, and visualization. Through Langdock’s integration, you can access and manage Excel directly from your conversations.
Authentication: OAuth Category: Productivity & Collaboration Availability: All workspace plans

​
Available Actions

​
Get item by name

excel.get_item_by_name
Searches for Excel files by name across OneDrive and SharePoint sites, returning their ID, driveId, name, URL, and metadata Requires Confirmation: No Parameters:
  • filter (TEXT, Required): The filename to search for in OneDrive and SharePoint. The search is case-insensitive and returns items that partially match the input. File extension is optional.
  • siteId (TEXT, Optional): Optional: Limit search to a specific SharePoint site
  • folderPath (TEXT, Optional): Optional: Limit search to a specific folder path
  • offset (NUMBER, Optional): Optional: Skip first N results for pagination (returns 25 results per request)
Output: Returns the operation result

​
Get sheet by item id

excel.get_sheet_by_item_id
Retrieves all worksheets of an Excel workbook Requires Confirmation: No Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): Id of the item of which you want to retrieve the worksheets of
Output: Returns the operation result

​
Add sheet to workbook

excel.add_sheet_to_workbook
Adds a worksheet to an existing Excel workbook Requires Confirmation: Yes Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the item which contains the Excel sheet
  • sheetName (TEXT, Required): The name of the sheet you want to add to the workbook
Output: Returns the operation result

​
Get tables

excel.get_tables
Retrieves all tables from a worksheet, specified by item id and sheet id Requires Confirmation: No Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): Id of the item of which you want to retrieve the tables of
  • sheetId (ID, Required): The id of the sheet where the table is located
Output: Returns the operation result

​
Get all table columns

excel.get_all_table_columns
Retrieves all columns from a table Requires Confirmation: No Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the item which contains the Excel sheet
  • tableId (ID, Required): The id of the table you want to fetch the rows of
Output: Returns the operation result

​
Get single table row

excel.get_single_table_row
Retrieves a specific row from a table given its row index Requires Confirmation: No Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the item which contains the Excel sheet
  • tableId (ID, Required): The id of the table you want to fetch the rows of
  • rowIndex (TEXT, Required): Index (number) of the row you want to retrieve
Output: Returns the operation result

​
Update cells

excel.update_cells
Updates cells in a worksheet at a specified range. Requires Confirmation: Yes Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the Excel workbook file
  • sheetId (ID, Required): The id of the worksheet to update
  • range (TEXT, Required): The exact cell range to update, e.g. ‘A1’, ‘A1:C5’, ‘B2:D10’
  • rowValues (OBJECT, Required): The values to write as a 2D array. Use an array of arrays for multiple rows (e.g. [[“a”,“b”],[“c”,“d”]]) or a single array for one row (e.g. [“a”,“b”,“c”]).
Output: Returns the operation result

​
Insert column

excel.insert_column
Inserts a new empty column to the left or right of a specified column, shifting existing columns Requires Confirmation: No Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the Excel workbook file
  • sheetId (ID, Required): The id of the worksheet where the column will be inserted
  • column (TEXT, Required): The reference column letter (e.g., ‘A’, ‘E’, ‘AA’) next to which the new column will be inserted
  • direction (SELECT, Required): Where to insert the new column relative to the reference column: ‘left’ inserts before, ‘right’ inserts after
Output: Returns the operation result

​
Insert row

excel.insert_row
Inserts a new empty row above or below a specified row, shifting existing rows down Requires Confirmation: No Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the Excel workbook file
  • sheetId (ID, Required): The id of the worksheet where the row will be inserted
  • row (TEXT, Required): The reference row number (e.g., 1, 5, 100) next to which the new row will be inserted
  • direction (SELECT, Required): Where to insert the new row relative to the reference row: ‘above’ inserts before, ‘below’ inserts after
Output: Returns the operation result

​
Add table row

excel.add_table_row
Adds a new row to the end of a table Requires Confirmation: Yes Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the item which contains the Excel sheet
  • tableId (ID, Required): The id of the table you want to fetch the rows of
  • rowValues (TEXT, Required): The values of the row you want to insert. Enter them separated by a comma like: hello,world,4 this will insert hello into the first column and world in the second column and 4 into the third column of the table same for numbers or dates separate every new value with a comma
Output: Returns the operation result

​
Delete table row

excel.delete_table_row
Deletes a specific row from a table given its row index Requires Confirmation: Yes Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the item which contains the Excel sheet
  • tableId (ID, Required): The id of the table you want to fetch the rows of
  • rowIndex (NUMBER, Required): Index of the row you want to delete
Output: Returns the operation result

​
Get workbook summary

excel.get_workbook_summary
Retrieves a summary of an Excel workbook including all sheets, their data ranges, tables, and charts Requires Confirmation: No Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the Excel workbook file to summarize
  • includeDetails (BOOLEAN, Optional): If true, includes a preview of the first few rows of data for each sheet.
  • sheetIds (TEXT, Optional): Optional. Filter to specific sheets by ID or name. Comma-separated for multiple, e.g. ‘Sheet1, Sheet2’ or leave empty for all sheets.
  • tableIds (TEXT, Optional): Optional. Filter to specific tables by ID or name. Comma-separated for multiple, e.g. ‘Table1, Table2’ or leave empty for all tables.
Output: Returns the operation result

​
Insert formulas

excel.insert_formulas
Inserts Excel formulas into cells at a specified range. Use this to add calculations like =SUM(), =AVERAGE(), =IF(), etc. Requires Confirmation: Yes Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the Excel workbook file
  • sheetId (ID, Required): The id of the worksheet where the formulas will be inserted
  • range (TEXT, Required): The cell range where formulas will be inserted, e.g. ‘B14’ for a single cell or ‘B14:P14’ for multiple cells
  • formulas (OBJECT, Required): The Excel formulas to insert. Use standard Excel formula syntax starting with =. For multiple cells, provide an array like [“=SUM(B2:B13)”, “=SUM(C2:C13)”].
Output: Returns the operation result

​
Get range

excel.get_range
Retrieves data from a specified cell range in a worksheet. Use this to read data that is not in a table. Requires Confirmation: No Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the Excel workbook file
  • sheetId (ID, Required): The id or name of the worksheet to read from
  • range (TEXT, Optional): The cell range to read, e.g. ‘A1:D10’, ‘B2:F20’. Leave empty to get the entire used range.
  • includeHeaders (BOOLEAN, Optional): If true, treats the first row as headers and returns data as objects with header keys. If false, returns raw 2D array.
Output: Returns the operation result

​
Format cells

excel.format_cells
Applies formatting to cells including font styles, background colors, and borders Requires Confirmation: Yes Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the Excel workbook file
  • sheetId (ID, Required): The id or name of the worksheet
  • range (TEXT, Required): The cell range to format, e.g. ‘A1’, ‘A1:D10’
  • fontBold (BOOLEAN, Optional): Set to true to make text bold
  • fontItalic (BOOLEAN, Optional): Set to true to make text italic
  • fontColor (TEXT, Optional): Font color in hex format (e.g. ‘#FF0000’ for red)
  • fontSize (NUMBER, Optional): Font size in points (e.g. 12, 14, 18)
  • fillColor (TEXT, Optional): Cell background color in hex format (e.g. ‘#FFFF00’ for yellow)
  • borderStyle (SELECT, Optional): Apply borders to all sides of the range
  • borderColor (TEXT, Optional): Border color in hex format (e.g. ‘#000000’ for black). Only used if border style is set.
Output: Returns the operation result

​
Create table

excel.create_table
Creates a new table from a cell range. Tables enable filtering, sorting, and structured references. Requires Confirmation: Yes Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the Excel workbook file
  • sheetId (ID, Required): The id or name of the worksheet
  • range (TEXT, Required): The cell range to convert to a table, e.g. ‘A1:D10’
  • hasHeaders (BOOLEAN, Required): Set to true if the first row contains column headers. If false, Excel will auto-generate headers.
Output: Returns the operation result

​
Sort range

excel.sort_range
Sorts data in a range by one or more columns Requires Confirmation: Yes Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the Excel workbook file
  • sheetId (ID, Required): The id or name of the worksheet
  • range (TEXT, Required): The cell range to sort, e.g. ‘A1:D10’
  • sortColumn (NUMBER, Required): The column index (0-based) to sort by. 0 = first column, 1 = second column, etc.
  • ascending (BOOLEAN, Required): Set to true for A-Z/smallest-largest, false for Z-A/largest-smallest
  • hasHeaders (BOOLEAN, Optional): Set to true if the first row contains headers that should not be sorted
Output: Returns the operation result

​
Create chart

excel.create_chart
Creates a chart from data in a range Requires Confirmation: Yes Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the Excel workbook file
  • sheetId (ID, Required): The id or name of the worksheet
  • sourceRange (TEXT, Required): The cell range containing the data for the chart, e.g. ‘A1:B10’
  • chartType (SELECT, Required): The type of chart to create
  • seriesBy (SELECT, Optional): How to organize data series in the chart
Output: Returns the operation result

​
Get table rows

excel.get_table_rows
Retrieves rows from a table with pagination support. Use this to read data from Excel tables. Requires Confirmation: No Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the Excel workbook file
  • tableId (ID, Required): The id or name of the table to read from
  • limit (NUMBER, Optional): Maximum number of rows to return (default 100, max 1000)
  • skip (NUMBER, Optional): Number of rows to skip (for pagination)
Output: Returns the operation result

​
Set number format

excel.set_number_format
Sets the number format for cells (currency, percentage, date, etc.) Requires Confirmation: Yes Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the Excel workbook file
  • sheetId (ID, Required): The id or name of the worksheet
  • range (TEXT, Required): The cell range to format, e.g. ‘A1:D10’
  • formatType (SELECT, Optional): Predefined format type to apply
  • customFormat (TEXT, Optional): Custom Excel number format string (overrides format type if provided). Examples: ’#,##0.00’, ‘0.00%’, ‘YYYY-MM-DD’
Output: Returns the operation result

​
Delete row

excel.delete_row
Deletes a row from a worksheet, shifting remaining rows up Requires Confirmation: Yes Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the Excel workbook file
  • sheetId (ID, Required): The id or name of the worksheet
  • row (NUMBER, Required): The row number to delete (e.g., 5)
Output: Returns the operation result

​
Delete column

excel.delete_column
Deletes a column from a worksheet, shifting remaining columns left Requires Confirmation: Yes Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the Excel workbook file
  • sheetId (ID, Required): The id or name of the worksheet
  • column (TEXT, Required): The column letter to delete (e.g., ‘C’, ‘AA’)
Output: Returns the operation result

​
Clear range

excel.clear_range
Clears cell contents, formatting, or both from a range without deleting the cells Requires Confirmation: Yes Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the Excel workbook file
  • sheetId (ID, Required): The id or name of the worksheet
  • range (TEXT, Required): The cell range to clear, e.g. ‘A1:D10’
  • clearType (SELECT, Required): What to clear from the range
Output: Returns the operation result

​
Merge cells

excel.merge_cells
Merges cells in a range into a single cell Requires Confirmation: Yes Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the Excel workbook file
  • sheetId (ID, Required): The id or name of the worksheet
  • range (TEXT, Required): The cell range to merge, e.g. ‘A1:D1’
  • across (BOOLEAN, Optional): If true, merges cells in each row separately. If false, merges all cells into one.
Output: Returns the operation result

​
Set alignment

excel.set_alignment
Sets text alignment for cells (horizontal and vertical) Requires Confirmation: Yes Parameters:
  • driveId (ID, Required): The id of the drive containing the Excel file
  • itemId (ID, Required): The id of the Excel workbook file
  • sheetId (ID, Required): The id or name of the worksheet
  • range (TEXT, Required): The cell range to align, e.g. ‘A1:D10’
  • horizontalAlignment (SELECT, Optional): Horizontal text alignment
  • verticalAlignment (SELECT, Optional): Vertical text alignment
  • wrapText (BOOLEAN, Optional): Enable text wrapping within cells
Output: Returns the operation result