订阅

UiPath StudioX

UiPath StudioX 指南

2021.4.3


UiPath 修补程序文档编制方法


🛈 UiPath 会根据业务需要定期发布补丁,其中包括修复和改进。特定版本的文档会反映该版本的最新补丁。用户可以在发行说明中查看补丁之间的产品更改。
例如,2021 年 10 月,StudioX 2021.4 的文档说明了其最新补丁,即 2021.4.5。



Release date: 26 April 2021

New Features and Improvements

Excel 自动化

New Activities

  • Autofit Range - Changes the displayed column width and/or row height in the specified range to the widest entry in each column and the highest entry in each row.
  • Get Excel Chart - Copies an Excel chart to the clipboard for use in other activities or saves it as a picture file.
  • Insert Excel Chart - Inserts a chart in a sheet at the specified location.
  • Find/Replace Value - Searches in a specified range for certain values. Depending on what operation you choose, it either returns the location of the cell or replaces the value with another given value.
  • Refresh Excel Data Connections - Gets the latest data by refreshing all sources in an open Excel workbook.
  • Update Excel Chart - Updates the properties of an existing Excel chart.

改进

  • SharePoint support has been added to the Use Excel File activity. You can open Excel files stored on SharePoint by placing the SharePoint URL in the Excel File field.
  • A new property called Read Formatting was added to the Use Excel File activity that lets you choose the formatting that will be applied to values read from Excel.
  • A new property called Start in column was added to the Append Range activity.
  • A new property called Empty Row Behavior was added to the For Each Excel Row activity that lets you select how the automation behaves if an empty row is encountered.
  • The Text files entry was added to the Select File dialog when browsing for Excel files using the Use Excel File activity.
  • You can now choose whether Excel windows are visible during the automation and what formatting will be applied to values read from Excel by using the options in the Excel Project settings window.
  • New formatting options have been added to the Format Cells activity that enable you to change the alignment, font, and the fill color of a cell.
  • The Copy Range activity has received the following updates:
    • 标题已更改为“复制/粘贴范围”
    • 现在,“目标”字段支持单元格。您可以提供一个单元格,然后从该单元格开始写入复制的数据。
    • 添加了新的“排除源标头”选项。如果选中,则不会复制“来源”范围的第一行。
  • You can now get the number of rows in an Excel object (ranges, tables, sheets) by using the Row Count property through the Plus plus buttonplus button menu.
  • The Excel Project Settings window has been updated with a new settings category called Excel Preview that determine how Excel files are accessed when using the Plus plus buttonplus button menu.

邮件自动化

改进

  • 以下活动已更新,其中新增两个属性,称为“使用 HTML 内容”和“打开编辑器”
  • When working with Mail activities, you can now retrieve the body of an email as HTML by selecting Body as HTML from the Plus plus buttonplus button menu.
  • You can now specify the reply-to address, importance, and sensitivity of an email when using the Send Email activity using the following options:
    • “回复至”- 回复时使用的电子邮件地址。
    • “重要性”- 电子邮件的重要性。
    • “敏感度”- 电子邮件的敏感度。
  • You can now use shared mailboxes in automations involving Outlook 365 and the Outlook Desktop app. For Outlook desktop, select the shared mailbox to use from the Account drop-down in the Use Outlook Desktop App activity. For Outlook 365, enter the address of the shared mailbox in the Shared mailbox to use field available in the Use Outlook 365 activity.
  • You can now choose to overwrite existing files when saving email attachments with the Save Email Attachments activity by selecting the Overwrite existing option.
  • You can now save multiple attachment types using the Save Email Attachments activity in StudioX by adding multiple file extensions in the Filter by file name field. Example: “.xls|.pdf”.
  • You can now also filter by category and date when using the Additional Filters feature in the For Each Email activity.
  • 未送达报告 (NDR) 支持已添加到以下邮件活动中:
  • 现在,在使用“邮件”活动时支持邀请。

PowerPoint 自动化

New Activities

改进

  • SharePoint support has been added to the Use PowerPoint Presentation activity. You can open presentations stored on SharePoint by placing the SharePoint URL in the PowerPoint File field.
  • A new property called Replace all has been added to the Replace Text in Presentation activity.
  • The Add Table Data to Slide activity has been updated with the following new properties:
    • 排除源标头 - 如果选中,则不复制源表的第一行。
    • “行为”- 确定如何将表格数据添加到幻灯片。
  • “活动”面板中的“演示文稿”类别已重命名为“PowerPoint”

Word 自动化

New Activities

改进

  • You can now open and modify documents from remote locations (e.g. SharePoint/Teams) using a URL in the Word file field of the Use Word File activity. Currently this only supports opening existing files, you can’t create new files on a remote location using a URL path.

Common Activities

New Activities

  • Generate Data Table from Text - Generates a DataTable variable from structured text.
  • Modify Date - Updates a date value using modifications including adding or subtracting days and finding the first or last day of the week, month, or year.
  • For Each Row in Data Table - Executes an action once for each row in a specified Data Table.
  • Filter Data Table - Enables you to filter a Data Table by specifying conditions in the Filter Wizard window.
  • Read Row Item - Retrieves a value from a row in a Data Table according to a specified column.
  • Update Row Item - Assigns the specified value into the indicated column of a Data Table row.

改进

  • You can now use saved for later credentials from the Get Username/Password activity to enter passwords in activity fields that require SecureString passwords.
  • Orchestrator credentials can now be retrieved using the Get Username/Password activity and choosing Orchestrator in the Credentials Source field.

Google Workspace (G Suite) 自动化

现在,您可以使用“Google 文档”、“Google 云端硬盘”和“Google 表格”活动在 Google Workspace 中创建和编辑文件,文档和表格。要使用这些活动,必须首先从“管理包”窗口中安装最新版本的“UiPath.GSuite.Activities”包。

在配置要求指示 Google 云端硬盘中的文件或文件夹的活动时,您可以使用活动中提供的文件浏览器快速进行选择。

When working with Google Sheets activities, you can select sheets and named ranges directly from the Plus plus buttonplus button menu.

可以在 StudioX 中进行以下活动:

通过 Automation Ops 进行监管

  • StudioX can now be governed through Automation Ops, a new web-based application available in Automation Cloud that offers an easy way to define and deploy governance policies across the organization.

Other Improvements

  • 为了便于识别每个活动所使用的应用,以下类别中的所有活动现在都具有与它们集成的应用程序相同的图标:Excel、PowerPoint、Word、Google 表格、Google 文档和 Google 云端硬盘。
  • The Repair Tool for Microsoft Office has an improved user experience and a few new features:
    • 您可以将 Microsoft Office 修复工具作为修复计划的一部分运行。
    • 如果在运行修复后遇到任何问题,可以将 Windows 注册表还原到修复之前的配置。
    • 您可以选择要包含在修复计划中的操作,并在运行计划之前查看有关每个操作的注册表更改的详细信息。
  • 现在,在安装 Excel 加载项时,StudioX 会检测系统上是否存在较旧的安装,并自动将其卸载。
  • 将文件自动化活动的“[当前文件]完整路径”属性显示名称重命名为“全名(包括完整路径)”

已知问题

  • If the Word document you select to use as the body of an email in a Send Email, Forward Email, or Reply to Email activity contains pictures, some of the pictures may not appear in the body of the email that is sent.
    If a picture fails to appear in the email body, try one of the following workarounds:
    • 打开 Word 文档,删除图片,然后再次添加图片。
    • 将 Word 文档的扩展名更改为 .zip,解压缩档案,打开文件夹 word 中的文件 document.xml,搜索属性 r:link,然后将其删除(例如 r:link="rId11")。保存文件,然后再次压缩提取的文件,并将扩展名更改回 docx

Bug Fixes

  • Fixed an issue where an activity was not focused when clicking the Plus plus buttonplus button menu.
  • The Copy Range activity no longer incorrectly pastes the data when columns are selected as the source range.
  • 修复了在某些情况下导致 StudioX 在大型项目中添加活动时暂时冻结的问题。

3个月前更新


2021.4.3



UiPath 修补程序文档编制方法


🛈 UiPath 会根据业务需要定期发布补丁,其中包括修复和改进。特定版本的文档会反映该版本的最新补丁。用户可以在发行说明中查看补丁之间的产品更改。
例如,2021 年 10 月,StudioX 2021.4 的文档说明了其最新补丁,即 2021.4.5。



建议的编辑仅限用于 API 参考页面

您只能建议对 Markdown 正文内容进行编辑,而不能建议对 API 规范进行编辑。