读取范围

UiPath.Excel.Activities.Business.ReadRangeX

将 Excel 范围的值读取为数据表。该活动可以与为父级“使用 Excel 文件”活动选择的 Excel 文件一起使用，也可以与“项目笔记本”一起使用。

配置活动

• Range - Select the plus icon. From the dropdown menu, select a named range, table, or sheet that the activity should read. Alternatively, select Indicate in Excel to open the file and select a range directly from the file. Another options is to select Custom Input to enter the range manually, or Open in Advanced Editor and enter a VB expression.
  • “包含标题”- 如果范围中的第一行是标题行，则选择此选项。
  • “仅可见行”- 选择此选项可仅读取可见行。它会忽略筛选值和隐藏值。

• Save to - The DataTable where to save the contents of the range. To paste the data from the clipboard, use Copy/Paste Range or other dedicated pasting activities.

Note: For details on how to use the options under the plus menu, check Designing automations in UiPath Studio.

属性

常见

• “显示名称”- 设计器面板中活动的显示名称

输入

• Range - Check Range in the body of the activity.

其他

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

选项

• Has headers - Check Has headers in the body of the activity.
• Read formatting - The formatting that should be applied to the values. Select one of the following options:
  • (null) - The formatting options are the same as for the parent card.
  • 默认 - 使用 Excel 返回的默认格式。
  • “原始值” - 从 Excel 中检索原始值并忽略所有格式。
  • 显示值 - 检索 Excel 中显示的值。
• Visible rows only - Check Visible rows only in the body of the activity.

Note: For better performance, it is recommended to set the Read formatting option to RawValue and deselect the Visible rows only option.

输出

• Save to - The DataTable where to save the contents of the range. To paste the data from the clipboard, use Copy/Paste Range or other dedicated pasting activities. Select the plus icon and, from the dropdown menu, select one of the available options:

  • Use Variable - Use an existing variable to store the output.
  • Open in Expression Editor - Enter a VB expression.
  • Create Variable - Creates a new variable to store the output.