Format as Table Activity

The Format as Table activity converts a specified cell range within an Excel worksheet into a structured table, applying a chosen visual style and optional header row. This gives raw data an organized, filterable, and professionally formatted appearance without manual styling.

Field	Description	Requirement
Excel name	The reference name of the Excel file, which must already be open or created, is selected from a dropdown.	Required
Sheet name	The name of the Excel sheet to work within. If not specified, the activity defaults to the first sheet.	Optional
Sheet index	The index of the Excel sheet to work within. If not specified, the activity defaults to the first sheet.	Optional
Range	The specific range of cells to convert into a table (e.g., `A1:D10`).	Optional
Table style	The predefined visual style to apply to the table (e.g., banded rows, accent color).	Optional
Has header?	A boolean option indicating whether the first row of the range contains column headers.	Optional

Action Types & Examples

Table Style Assignment

Format: string
Example Result: "TableStyleMedium9"

Header Row Toggle

Format: boolean
Example Result: true

Implementation Examples

Field Setup - Excel name: ${newExcel} - Sheet name: Sheet1 - Range: A1:D10 - Table style: TableStyleMedium9 - Has header?: true

Execution Parameters - Sheet index: 1

Technical Notes

When Sheet name or Sheet index are not explicitly provided, the activity defaults to operating on the first sheet of the specified Excel file. Selecting Has header? prevents the first row of the range from being treated as a data row when the table's filter and sort controls are generated.