Unitalk Microsoft Excel 365 icon

Unitalk Microsoft Excel 365

Consume Microsoft Excel API

Actions17

Table → Append

AI-generated

Summary

Append one or more rows to a specified table in a Microsoft Excel 365 workbook sheet by providing data either as raw JSON arrays, auto-mapping using input item properties, or defining column-value pairs explicitly.

Inputs

  • Workbook (required) — Select the Microsoft Excel workbook to append data to, either from a list or by specifying its ID.
  • Sheet (required) — Select the worksheet within the workbook, either from a list or by specifying its ID.
  • Table (required) — Specify the table within the selected worksheet to which rows will be appended, from a list or by ID.
  • Data Mode (required) — Choose how to provide the row data: auto-map input JSON properties to columns, define each column value explicitly, or provide raw JSON arrays.
  • Data (required) — When 'Raw' mode is selected, input raw row data as a JSON array of string arrays where each sub-array represents a row's values.
  • Values to Send (required) — When 'Map Each Column Below' mode is selected, explicitly specify column names and the values to append for each row.
  • Options — Additional options including the index at which to insert the new row (default is end), whether to return raw API response data, and the output data property name when raw data is returned.

Output shape

a list of appended row objects reflecting the rows added to the table

Supports processing of multiple input items; errors for individual items can be optionally continued on fail. Output includes parsed or raw data depending on the 'RAW Data' option. The appended rows are returned with their corresponding column mappings.

Examples

Example 1: Append rows to a table by explicitly defining column values

Select workbook, worksheet, and table, choose 'Map Each Column Below' data mode, then add fields specifying column names and values for each new row.

Example 2: Append rows to a table using raw JSON data

Select workbook, worksheet, and table, choose 'Raw' data mode, and provide raw JSON string of row values (array of arrays) to append.

Example 3: Append rows to a table by auto-mapping input item JSON properties

Select workbook, worksheet, and table, choose 'Auto-Map Input Data to Columns' data mode, and ensure input items have properties matching table column names for automatic mapping.

Links

Discussion