Skip to main content

Add Table Row

Adds a new row to a specified table in an Excel workbook stored in OneDrive or SharePoint using Microsoft Graph API.

Category: Microsoft Office 365 & OneDrive · Group: Office 365 · Activity name: AddTableRow

The AddTableRow activity in the designer

Example

AddTableRow(workbookPath="<workbookPath>", worksheetName="<worksheetName>", tableName="<tableName>", useSpecificRow=True, values=[])

Inputs

NameTypeRequiredDefaultDescription
Workbook PathstringThe full path of the workbook in OneDrive or SharePoint.
Worksheet namestringThe name of the worksheet that contains the table.
Table NamestringThe name of the table where the row should be added.
Insert a specific row index.booleanInsert a specific row index where the data should be appended. If left unchecked it will append the data after the last row.
ValuesarrayAn array of values to insert as a new row. The number of values must match the number of columns in the table.