Append Table Rows
append_table_rowsAppend rows to an Excel table in an open workbook, specifying the table name and row values, to update the table's data and get the new row count.
Instructions
Append one or more rows to the end of a table.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). table_name: Table to append to (required). rows: A list of rows, each a list of values matching the table's column count (required), e.g. [["Widget", 12, 4.5]].
Returns: JSON with the table's resulting row count.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | No | ||
| sheet | No | ||
| workbook | No | ||
| table_name | No |