Microsoft Excel - Insert table data
Use the Microsoft Excel - Insert table data action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. to insert rows of data to the end of a specific table in a workbook.
For more information about the Microsoft Excel connector, go to Microsoft Excel.
Configure the Microsoft Excel - Insert table data action
-
Add the action to the workflow and open the action configuration panel. For more information, see Add an action to the workflow.
- Select a Connection. If you do not have a connection, see Add a connection.
- Select the Workbook the table belongs to.
- Select the Table you want to insert the data into.
- Specify the row details such as the row index and cell data.
Microsoft Excel - Insert table data action fields, buttons, and settings
Section |
Field |
Description |
Variable types |
---|---|---|---|
(unlabeled) |
The Microsoft Excel connection to use for inserting data into a table. To refresh the available connections, click |
(n/a) |
|
Workbook |
The workbook containing the table you want to insert data into. When you specify the Microsoft Excel connection, all the workbooks in the selected connection are available to select from in the drop-down list. When using a variable, use the workbook ID. |
Text, Decimal, Integer, Boolean, DateTime, Collection |
|
Table |
The Microsoft Excel- Insert Table Data action requires a workbook to have pre-created tables to function. The table you want to insert data into. When you specify the Workbook, all the tables in the selected workbook are available to select from in the drop-down list. If you want to select a table that is not in the list, you can insert a variable in the Table field. When using a variable, use the table ID or table name. |
Text, Decimal, Integer, Boolean, DateTime, Collection |
|
Row index |
Position identifying the row to start from inserting the data. Type the value of the beginning row number (these values are zero based, so Row 1 = 0, Row 2 = 1, etc.). For example, if you type a value of 2, row number 3 will be used to start inserting data. |
Integer |
|
Cell data |
Details identifying the cell data to add. Click Add row to add a row for your cell. Click Add cell to configure the details you want to insert.
To remove a configured area click the Row ellipsis and select Delete. If a table contains multiple columns, then all cells in the column need to have data inserted into them when using the Insert table data action. To add empty cells of data, you must add a space in that field. |
Text, Decimal, Integer, Boolean, DateTime, Collection |
|
Output |
Cell data |
Stores the result of the action as an object with the following variable:
|
Object |