Excel

​

Overview

Spreadsheet software for data organization, analysis, and visualization. Through Langdock’s integration, you can access and manage Excel directly from your conversations.

​

Available Actions

​

Get Item by Name

excel.getItembyName

Retrieves OneDrive items by name, providing their ID, name, URL, and other metadata Requires Confirmation: No Parameters:

• filter (TEXT, Required): Filter drive items by if their names contain the filter

Output: Returns an array of items with the following structure:

• id: Item ID
• name: Item name
• webUrl: Web URL for the item
• createdDate: Creation date
• creator: Creator information (name, email)
• lastModifiedDateTime: Last modified date
• lastModifier: Last modifier information (name, email)

---

​

Get Sheet by Item ID

excel.getSheetbyItemID

Retrieves all worksheets of an Excel workbook Requires Confirmation: No Parameters:

• itemId (TEXT, Required): Id of the item of which you want to retrieve the worksheets of

Output: Returns an array of worksheets with their IDs and names

---

​

Add Sheet to Workbook

excel.addSheettoWorkbook

Adds a worksheet to an existing Excel workbook Requires Confirmation: Yes Parameters:

• itemId (TEXT, 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 created sheet with its ID and name

---

​

Get Tables

excel.getTables

Retrieves all tables from a worksheet, specified by item id and sheet id Requires Confirmation: No Parameters:

• itemId (TEXT, Required): Id of the item of which you want to retrieve the tables of
  • sheetId (TEXT, Required): The id of the sheet where the table is located

Output: Returns an array of tables with their IDs and metadata

---

​

Get All Table Columns

excel.getAllTableColumns

Retrieves all columns from a table Requires Confirmation: No Parameters:

• tableId (TEXT, Required): The id of the table you want to fetch the rows of
  • itemId (TEXT, Required): The id of the item which contains the Excel sheet

Output: Returns an array of columns with their names and types

---

​

Get Single Table Row

excel.getSingleTableRow

Retrieves a specific row from a table given its row index Requires Confirmation: No Parameters:

• itemId (TEXT, Required): The id of the item which contains the Excel sheet
  • tableId (TEXT, 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 row data with values for each column

---

​

Update Table Row

excel.updateTableRow

Updates a specific row in a table, requiring values for each column Requires Confirmation: Yes Parameters:

• rowIndex (TEXT, Required): The id of the row you want to update
  • 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
  • itemId (TEXT, Required): The id of the item which contains the Excel sheet
  • tableId (TEXT, Required): The id of the table you want to fetch the rows of

Output: Returns confirmation of the update

---

​

Add Table Row

excel.addTableRow

Adds a new row to the end of a table Requires Confirmation: Yes Parameters:

• itemId (TEXT, Required): The id of the item which contains the Excel sheet
  • tableId (TEXT, 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 confirmation of the row addition

---

​

Delete Table Row

excel.deleteTableRow

Deletes a specific row from a table given its row index Requires Confirmation: Yes Parameters:

• rowIndex (NUMBER, Required): Index of the row you want to delete
  • itemId (TEXT, Required): The id of the item which contains the Excel sheet
  • tableId (TEXT, Required): The id of the table you want to fetch the rows of

Output: Returns confirmation of the row deletion

---

​

Common Use Cases

​

Best Practices

​

Troubleshooting

Issue	Solution
Authentication failed	Verify your OAuth credentials
Rate limit exceeded	Reduce request frequency
Data not found	Check permissions and data availability
Connection timeout	Verify network connectivity

​

Support

For additional help with the Excel integration, contact support@langdock.com