Microsoft Excel 365 icon

Microsoft Excel 365

Consume Microsoft Excel API

Actions16

Table → Create

AI-generated

Summary

Create an Excel table from a selected worksheet range in a workbook. Choose the range automatically to use the sheet’s used range, or manually provide a cell range; set whether the range contains headers.

Inputs

  • Workbook (required) — Select a workbook from the list or enter its ID.
  • Sheet (required) — Select a worksheet from the list or enter its ID.
  • Select Range — Choose Automatically to use the worksheet’s used range, or Manually to specify a range.
  • Range — Cell range to convert to a table when manual range selection is used, for example A1:B2.
  • Has Headers — Whether the range has column labels. Defaults to true; when false, Excel generates headers and shifts the data down by one row.

Output shape

A list of items containing the created table response.

The supplied source pack shows the operation entry point but omits its implementation body, so the exact response fields and item handling are not visible.

Links

Discussion