Add Row

This card adds a row of data to the end of a worksheet.

Options

Field Definition Type Required
Workbook

List of workbooks available in your account. Workbook is another word for your Excel files.

If you select a Workbook from the dropdown, ignore the Workbook ID field.

If you select -- Enter Workbook ID -- from the dropdown, then the list of workbooks from your account in the Workbook dropdown will be depopulated; enter an ID in the Workbook ID field.

Dropdown TRUE
Workbook ID

Option to specify a Excel Online workbook by ID.

Example of a workbook ID: 015PGUOTTY6ZMVGBRB65DLDRED7VJJEJTP

To get the ID for an Excel Online workbook, see Get a DriveItem resource.

String FALSE
Worksheet

List of worksheets available in the specified workbook. A worksheet is an individual spreadsheet within a workbook, displayed as a tab in an Excel file.

Dropdown TRUE

Input

Field Definition Type Required
Values List of values for the new row. String FALSE
Column Letters (A - ZZ) Each of the field will represent the corresponding cell in the newly created row. For example if the worksheet is empty then the first three fields will be 1A, 1B, 1C. String FALSE
Caution

Microsoft’s Excel API takes time to propagate changes. When more than one row is being added to a Worksheet, it's recommended that you add a Wait Function Card set to 10 seconds. If you see rows being omitted, add more time.

Output

Field Definition Type
Row
Row Number Newly created row's number. This is the number displayed in Excel to the left of the first column. Number

Related topics

Excel Online connector

About the elements of Okta Workflows

Excel Online API documentation