Unitalk Microsoft Excel 365 icon

Unitalk Microsoft Excel 365

Consume Microsoft Excel API

Actions17

Sheet → Get Many

AI-generated

Summary

Retrieve a list of worksheets (sheets) within a specified Microsoft Excel workbook from the Microsoft 365 cloud platform.

Inputs

  • Workbook (required) — Select the workbook to get sheets from, either from a searchable list or by entering its ID.
  • Return All — Choose whether to return all sheets or limit the number of results.
  • Limit — If 'Return All' is false, specify the maximum number of sheets to return (1-500).
  • Filters — Optional filter specifying a comma-separated list of fields to include in the response.

Output shape

a list of worksheet objects

The output contains an array of worksheet records from the specified workbook. Pagination is supported if 'Return All' is false, otherwise all sheets are retrieved. Each worksheet includes identifying and descriptive fields as returned from Microsoft Excel API.

Examples

Example 1: Retrieve all sheets from a workbook

Set the 'Workbook' parameter to the desired Excel workbook and enable 'Return All' to fetch every sheet.

Links

Discussion