Tool
Add a worksheet tablerow
The Microsoft Excel Add a Worksheet TableRow tool enables users to seamlessly add new rows to the end of a specific table within an Excel worksheet. Integrated with Microsoft Graph API, it streamlines data management by allowing programmatic and automated updates to Excel tables.
Features
- Adds rows to the end of a specified Excel table efficiently.
- Supports input of 2-dimensional arrays to insert multiple rows at once.
- Requires folder ID and sheet ID for precise targeting of the worksheet and table.
- Integrates with Microsoft Graph API for smooth authenticated operations.
- Includes comprehensive documentation with usage examples for easy implementation.
Benefits
- Automates the process of updating Excel tables, saving time and reducing manual effort.
- Improves data accuracy by minimizing manual data entry errors.
- Enables bulk data insertion with support for multi-row inputs.
- Facilitates seamless integration into existing workflows using Microsoft Graph API.
- Enhances productivity by allowing easy programmability and customization of Excel data management.
Description
Adds rows to the end of specific table. See the documentation
Parameters
3 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 |
| valuesrequired | string | A 2-dimensional array of unformatted values of the table row. See the documentation to get the data format. |