向幻灯片中添加数据表

UiPath.Presentations.Activities.ReplaceShapeWithDataTable

将表格数据插入演示文稿中，替换空的占位符或上一个表格。此活动必须添加到使用 PowerPoint 演示文稿活动中。

配置活动

在活动正文中

• Presentation - Select 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). Select Plus on the right side of the field, then select the presentation file and the slide number where to insert the table data.

或者，也可以使用菜单中的另一个选项来指定幻灯片编号：

• 项目笔记本或父级 Excel 文件中的数据。例如，在 Excel 文件中选择一个单元格以使用该单元格中的值。
• 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. Select 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.

或者，也可以使用菜单中的另一个选项来指定占位符名称：

• 项目笔记本、父级 Excel 文件或电子邮件帐户中的数据。例如，在 Excel 文件中选择一个单元格以使用该单元格中的值。
• “运行时询问”- 执行项目时提示输入名称。
• “从剪贴板粘贴”- 将您以前复制的值粘贴到项目中的剪贴板中。
• “文本”- 在文本生成器中输入名称。
• 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. Select 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 select Indicate in Excel to select a range directly from the file.
  • “使用保存的值”- 选择您先前在项目中保存以备后用的数据表值。
  • Open in Advanced Editor - Enter a VB expression.

• 排除源标头 - 如果选中，则不复制源表的第一行。

• 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.
    备注：

    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.

属性面板

常见

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

输入

• “行为” - 在活动主体中查看“行为” 。
• “内容占位符” - 请在活动主体中查看“内容占位符” 。
• 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).
• 演示文稿- 在活动主体中查看演示文稿。
• “幻灯片编号” - 请在活动主体中查看“幻灯片编号” 。
• “要添加的表格” - 请在活动主体中查看“要添加的表格” 。
  备注：

  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.

其他

• “私有”- 选中后将不再以“Verbose”级别记录变量和参数的值。

选项

• “排除源标头” - 请在活动主体中查看“排除源标头” 。