Skip to main content

Create Table

Creates an Excel table from a range of cells in a worksheet. Excel tables provide structured data with built-in filtering, sorting, and formula features.

Common Properties​

  • Name - The custom name of the node.
  • Color - The custom color of the node.
  • Delay Before (sec) - Waits in seconds before executing the node.
  • Delay After (sec) - Waits in seconds after executing node.
  • Continue On Error - Automation will continue regardless of any error. The default value is false.

Input​

  • Client Id - The client ID from the Connect node (optional if using direct credentials).
  • Workbook Id - The workbook ID from Get Workbook or Create Workbook node.
  • Worksheet Name - Name of the worksheet to create the table in. Default is "Sheet1".
  • Table Name - Name for the new table (e.g., Table1, SalesData).
  • Range Address - Range address for the table data in A1 notation (e.g., A1:C10).

Options​

  • Credentials - OAuth2 credentials (optional, alternative to using Client ID).
  • Has Headers - When true, the first row of the range is used as column headers. Default is true.
  • Table Style - Excel table style to apply (e.g., TableStyleMedium2). Default is "TableStyleMedium2".
  • Show Filter Button - When true, shows filter buttons in the header row. Default is true.
  • Show Totals - When true, shows a totals row at the bottom of the table. Default is false.

Output​

  • Table Info - Information about the created table:

    • Id: Table ID
    • Name: Table name
    • ShowHeaders: Whether headers are shown
    • ShowFilterButton: Whether filter buttons are shown
    • ShowTotals: Whether totals row is shown
    • Style: Applied table style
    • ColumnCount: Number of columns
    • Columns: Array of column information
    • Range: Range information (address, row count, column count)

  • Table Id - The ID of the created table for use with other table operations.

Examples​

Create Basic Table:

// Input
Table Name: "SalesData"
Range Address: "A1:D10"
Has Headers: true

// Creates a table with headers from the range

Create Styled Table with Totals:

// Input
Table Name: "MonthlyReport"
Range Address: "A1:F20"
Has Headers: true
Table Style: "TableStyleMedium5"
Show Filter Button: true
Show Totals: true

// Creates a formatted table with totals row

Typical Workflow:

Get Workbook
  → Set Range (write data with headers)
  → Create Table (convert range to table)
  → Table now has filtering and structured features

Table Benefits​

Excel tables provide:

  • Automatic filtering with dropdown buttons
  • Structured references in formulas
  • Automatic formatting with styles
  • Easy data sorting and filtering
  • Totals row with aggregate functions
  • Automatic expansion when adding data

Available Table Styles​

Common table styles include:

  • TableStyleLight1 through TableStyleLight21
  • TableStyleMedium1 through TableStyleMedium28
  • TableStyleDark1 through TableStyleDark11

Use Cases​

  • Convert data ranges to structured tables
  • Create filterable datasets
  • Add professional formatting to data
  • Enable structured table references
  • Set up data for analysis

Tips​

  • Table names must be unique within the workbook
  • The range should include headers when Has Headers is true
  • Filter buttons make it easy for users to explore data
  • Totals row can show SUM, AVERAGE, COUNT, etc.
  • Tables automatically expand when you add data below them in Excel

Common Errors​

ErrInvalidArg - "Range address cannot be empty"

  • Solution: Provide a range in A1 notation (e.g., A1:C10)

ErrConflict - "Table already exists or range conflicts"

  • Solution: Use a different table name or check for overlapping tables

ErrInvalidArg - "Invalid range address"

  • Solution: Verify the range address is valid and contains data

ErrNotFound - "Worksheet not found"

  • Solution: Verify the worksheet name is correct

ErrInvalidArg - "Workbook ID cannot be empty"

  • Solution: Ensure you've called Get Workbook first