Unitalk Microsoft Excel 365 icon

Unitalk Microsoft Excel 365

Consume Microsoft Excel API

Actions17

Table → Get Rows

AI-generated

Summary

Retrieve rows from a specified table within a Microsoft Excel workbook's worksheet, optionally returning all rows or a limited number, and outputting either parsed or raw data.

Inputs

  • Workbook (required) — Select the workbook either from a list or by specifying its ID.
  • Sheet (required) — Select the worksheet containing the table either from a list or by specifying its ID.
  • Table (required) — Select the table from which to retrieve rows either from a list or by specifying its ID.
  • Return All — Choose whether to return all rows or limit the number of results.
  • Limit — Maximum number of rows to return (used if 'Return All' is false); ranges between 1 and 500, default is 50.
  • RAW Data — Option to return rows as raw data arrays instead of parsed objects keyed by column headers.
  • Data Property — Property name to store the raw data when 'RAW Data' is enabled; defaults to 'data'.
  • Filters — Filters to restrict fields or columns returned: 'Fields' (for raw data) to specify fields as a comma-separated string, or 'Column Names or IDs' (for parsed data) to select columns by their names or IDs.

Output shape

a list of row items

If 'RAW Data' is false, each output item is a JSON object with keys as column names and values as cell data. If 'RAW Data' is true, the output has a single item per input with the raw array under the specified data property. Pagination is handled internally when returning all rows.

Examples

Example 1: Retrieve first 50 rows

Set workbook, worksheet, and table from list. Set 'Return All' to false and 'Limit' to 50. Leave 'RAW Data' false to get parsed output.

Example 2: Retrieve all rows as raw data

Set workbook, worksheet, and table from list. Set 'Return All' to true. Enable 'RAW Data' and specify a 'Data Property' to receive raw row arrays.

Links

Discussion