Unitalk Microsoft Excel 365 icon

Unitalk Microsoft Excel 365

Consume Microsoft Excel API

Actions17

Table → Create

AI-generated

Summary

Create a table in a specified worksheet within a Microsoft Excel workbook based on a selected cell range.

Inputs

  • Workbook (required) — The Microsoft Excel workbook where the table will be created. Can be selected from a list or specified by ID.
  • Sheet (required) — The worksheet within the workbook where the table will be created. Can be selected from a list or specified by ID.
  • Select Range (required) — Choose whether to automatically use the whole used range on the selected sheet or manually specify a cell range to convert into a table.
  • Range — The A1-style cell range to be converted into a table. Required only if 'Select Range' is set to 'Manually'.
  • Has Headers (required) — Boolean indicating whether the specified range contains header row(s). If false, Excel will generate headers and shift data down by one row.

Output shape

a list of JSON items representing the newly created table(s) based on the selected range

Each created table's properties are returned as JSON objects. If multiple inputs are processed, multiple table representations are returned. Errors are returned per item if continuation on fail is enabled.

Links

Discussion