Microsoft Excel
Microsoft Excel integration allows you to automate spreadsheet tasks and manage your data efficiently, enhancing productivity and accuracy.
Features
- Automate repetitive spreadsheet tasks to save time.
- Seamlessly manage and update data within Excel.
- Supports complex formulas and data manipulations.
- Enables integration with other apps and workflows.
- Provides real-time data updates and synchronization.
Benefits
- Increase productivity by automating manual Excel tasks.
- Reduce errors in data entry and calculations.
- Streamline data management across multiple platforms.
- Enhance collaboration with consistent and up-to-date spreadsheets.
- Gain valuable insights through efficient data processing.
Available tools
8 actions available as tools
Update worksheet tablerow
Update the properties of tablerow object. `(Only for work or school account)` [See the documentation](https://learn.microsoft.com/en-us/graph/api/tablerow-update?view=graph-rest-1.0&tabs=http)
Update cell
Update the value of a specific cell in an Excel worksheet. [See the documentation](https://learn.microsoft.com/en-us/graph/api/range-update?view=graph-rest-1.0&tabs=http)
Get table rows
Retrieve rows from a specified table in an Excel worksheet. [See the documentation](https://learn.microsoft.com/en-us/graph/api/tablerow-list?view=graph-rest-1.0&tabs=http)
Get spreadsheet
Get the values of a specified Excel worksheet. [See the documentation](https://learn.microsoft.com/en-us/graph/api/range-get?view=graph-rest-1.0&tabs=http)
Get columns
Get the values of the specified columns in an Excel worksheet. [See the documentation](https://learn.microsoft.com/en-us/graph/api/range-get?view=graph-rest-1.0&tabs=http) IMPORTANT: The arguments have specific formats. Please follow the instructions below: - columns: Return JSON in this format: string[]
Find row
Find a row by column and value in an Excel worksheet. [See the documentation](https://learn.microsoft.com/en-us/graph/api/range-get?view=graph-rest-1.0&tabs=http)
Add row
Insert a new row into a specified Excel worksheet. [See the documentation](https://learn.microsoft.com/en-us/graph/api/range-insert?view=graph-rest-1.0&tabs=http) IMPORTANT: The arguments have specific formats. Please follow the instructions below: - values: Return JSON in this format: string[]
Add a worksheet tablerow
Adds rows to the end of specific table. [See the documentation](https://learn.microsoft.com/en-us/graph/api/tablerowcollection-add?view=graph-rest-1.0&tabs=http)