Add Data Table to Slide

In the Body of the Activity

• Presentation - Click Plus on the right side of the field, and then select the presentation file in which to add the table data. Alternatively, you can enter a VB expression.

• Slide number - Slide number on which to insert (numbers begin with 1). Click Plus on the right side of the field, then select the presentation file and the slide number where to insert the table data.

  Alternatively, use one of the other options in the menu to indicate the slide number:

  • Data from the Project Notebook or a parent Excel file. For example, select a cell in an Excel file to use the value in that cell.
  • Ask when run - Prompt for the slide number when the project is executed.
  • Number - Enter the slide number.
  • Use Saved Value - Select a numeric value that you previously saved for later use in the project.
  • Open in Advanced Editor - Enter a VB expression.

• Content placeholder - Placeholder (shape) on the slide where to create the table. Click Plus on the right side of the field, and then select the presentation file, the slide, and the placeholder where to create the table data.

  Alternatively, use one of the other options in the menu to indicate the placeholder name:

  • Data from the Project Notebook, a parent Excel file or email account. For example, select a cell in an Excel file to use the value in that cell.
  • Ask when run - Prompt for the name when the project is executed.
  • Paste from clipboard - Paste a value that you previously copied to the clipboard in the project..
  • Text - Enter the name in the Text Builder.
  • Use Saved Value - Select a value that you previously saved for later use in the project.
  • Open in Advanced Editor - Enter a VB expression.

• Table to add - The table data to be inserted into the slide. Click Plus on the right side of the field, and then, from the menu, choose one of the available options to indicate the table to be added.

  • Data from the Project Notebook or a parent Excel file. For example, select a named range, a table, a pivot table, or a sheet from the menu, or click Indicate in Excel to select a range directly from the file.
  • Use Saved Value - Select a data table value that you previously saved for later use in the project.
  • Open in Advanced Editor - Enter a VB expression.
• Exclude source headers - If selected, the first line of the source table is not copied.

• Behavior - Determines how the table data is added to the slide:

  • Create new table - Replaces the selected shape with a new table. This is the default option.
  • Append data - If the selected placeholder is a table, appends the data to the end of the table.

  • Overwrite existing data - If the selected placeholder is a table, overwrites the table starting from the row and column offsets specified in the Properties panel.

    Note: The Append data and Overwrite existing data behaviors do not add new columns to the target table. If the source table has more columns than the target table, the extra columns are truncated.

Properties Panel

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

• Behavior - See Behavior in the body of the activity.
• Content placeholder - See Content placeholder in the body of the activity.
• Overwrite starting in column - Overwrites data starting in a specified column. The default value is 1.
• Overwrite starting in row - Overwrites data starting in a specified row. The default value is 0 (no offset).
• Presentation - See Presentation in the body of the activity.
• Slide number - See Slide number in the body of the activity.

• Table to add - See Table to add in the body of the activity.

  Note: The Overwrite starting in column and Overwrite starting in row properties only apply to the Overwrite existing data behavior and are ignored for the other behaviors.

• Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

• Exclude source headers - See Exclude source headers in the body of the activity.