Tool
Update worksheet tablerow
Microsoft Excel Update Worksheet TableRow is a powerful AI tool designed for work or school accounts to efficiently update the properties of a table row within Excel spreadsheets. It streamlines data management by enabling direct modifications to specific rows in Excel tables via Microsoft Graph API.
Features
- Allows updating properties of a specific table row in Excel spreadsheets.
- Requires only work or school Microsoft accounts ensuring enterprise-grade security.
- Supports specifying folder, sheet, table, and row IDs for precise data targeting.
- Enables updating multiple cell values in a row with a single API call.
- Integrates seamlessly with Microsoft Graph API for robust and scalable Excel automation.
Benefits
- Saves time by automating Excel table row updates without manual entry.
- Enhances data accuracy by directly modifying cell values programmatically.
- Improves workflow efficiency in business and educational environments.
- Supports complex Excel data management through API integration.
- Ensures secure operations by restricting usage to authorized work or school accounts.
Description
Update the properties of tablerow object. (Only for work or school account) See the documentation
Parameters
5 parameters
| Name | Type | Description |
|---|---|---|
| folderIdrequired | string | The ID of the folder where the item is located |
| sheetIdrequired | string | The ID of the spreadsheet you want to use |
| tableIdrequired | string | The ID of the table you want to use |
| rowIdrequired | string | The ID of the row you want to use |
| valuesrequired | string | An array of values for the updated row. Each item in the array represents one cell. E.g. |