Excel

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: Microsoft 365 Availability: All workspace plans

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 inserts hello into the first column, world into the second, and 4 into the third. Do the 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 inserts hello into the first column, world into the second, and 4 into the third. Do the 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

• Data Management — Manage and organize your Excel data

• Automation — Automate workflows with Excel

• Reporting — Generate insights and reports

• Integration — Connect Excel with other tools

Best practices

1

Getting started

• Enable the Excel integration in your workspace settings

• Authenticate using OAuth

• Test the connection with a simple read operation

• Explore available actions for your use case

2

Important considerations

• Ensure proper authentication credentials

• Respect rate limits and API quotas

• Review data privacy settings

• Test operations in a safe environment first

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 [email protected]