capabilities.work

Append a Row to a Table

A 5-step recipe with Microsoft Excel. We can help you get access.

Recipe · 5 steps

Append a Row to a Table

with Microsoft Excel

Append a single record to an Excel table and verify it was written.

  1. Open a persisting session so the appended row is committed to the stored workbook rather than held in a transient calculation session.
  2. List the tables on the worksheet and take the first one as the append target. The step fails closed if the worksheet carries no table.
  3. Read the table's columns so the caller can confirm the row being appended has one value per column and in the same order. Excel rejects a row whose width does not match the table.
  4. Append the row. Sending index as null tells Excel to add the row at the end of the table rather than inserting it at a position.
  5. List the table rows back so the caller can confirm the appended row is present at the index Excel reported.
What you'll need to have ready
  • itemId: The drive item id of the workbook file.
  • worksheetIdOrName: The worksheet holding the target table (e.g. "Sheet1").
  • values: A two-dimensional array holding the row to append, ordered to match the table's columns (e.g. [["Jan-15-2026", "49", "37"]]).
For your developer

Arazzo workflow microsoft-excel:append-table-row, 5 operations: createWorkbookSession → listTables → listTableColumns → addTableRow → listTableRows. Specs on APIs.io.

More recipes with Microsoft Excel

Build a Chart from a Data RangeFlatten a Table into a Plain RangeCreate a Worksheet and Seed It with DataDiscover Workbook StructureWrite Through a Named RangeSort, Filter, and Total a Table for ReportingDelete a Table Row by IndexRead, Write, and Verify a Cell RangeAdd and Retire a Table ColumnCalculate with a Workbook Function and Write the Result