UiPath.Excel.Activities.Business.CreateTableX

Formats a range of cells as a table with a specified name. After the table is created, you can reference it later in your automation using its name.

In the Body of the Activity

• Source range - Click on the right side of the field and then, from the menu, select a named range or sheet to format as a table, or select Indicate in Excel to open the file and select a range directly from the file. Alternatively, you can select Custom Input to enter the range manually, or Open in Advanced Editor to enter a VB expression.
• New table name - Click on the right side of the field and then, from the menu, select a name for the table using one of the available options:
  • Data from an application added to a card in the project or from the Excel Workspace, for example a cell in an Excel file, or a field in a selected Outlook email.
  • Use Saved Value - Select a value that you previously saved for later use in the project.
  • Text - Enter the name using the Text Builder.
  • Open in Advanced Editor - Enter a VB expression.

Properties

Common

• Display Name - The name displayed for the activity in the Designer panel.

Input

• See the options in the body of the activity.

Misc

• Private - If selected, the data used in the activity is not logged by StudioX.

Options

• Has headers - If selected, the first row in the range is used as a header row for the table. This option is selected by default.