- Notas de Versão
- 2023.4.0
- 2023.4.6
- Introdução
- Tutoriais
- Projetos de automação
- Criando automações
- Noções básicas de automação
- Repo. de Objetos
- Melhores Práticas de Automação
- Tutorial: Criando uma Tabela Pivot
- Tutorial: Iterando através das Linhas de uma Tabela
- Tutorial: Comparar arquivos do Excel e enviar e-mails com erros de reconciliação
- Tutorial: Extrair dados de e-mails automatizados e movê-los para um aplicativo da área de trabalho.
- Tutorial: Filtrar dados no Excel
- Tutorial: Formatar células
- Tutorial: Adicionar informações sobre os arquivos de uma pasta para um arquivo do Excel
- Tutorial: Adicionando suas Próprias Fórmulas ao Project Notebook
- Automação do PowerPoint
- Automação de dados
- Atividades comuns
- Automação do Google Workspace
- Automação do OneDrive e do SharePoint
- Solução de problemas
Data de lançamento: 27 de abril de 2023
Novidades
Pesquisar atividades de todos os pacotes oficiais
Encontrar a atividade certa para o seu projeto agora é mais fácil com a capacidade de pesquisar em todos os pacotes de atividades disponíveis sem a necessidade de instalar um pacote com antecedência.Essa funcionalidade está disponível em projetos multiplataforma com o StudioX conectado ao Automation Cloud Orchestrator.
The Activities panel now groups activities that are available in your project under the label Installed and activities that are included in uninstalled packages under Installable. To make searching even easier, activities packages also have more readable names.
You can add an installable package by right-clicking its name in the Activities panel and selecting Install. You can also double-click individual activities or drag them to the Designer panel. Packages are installed with the latest available version.
The Add Activity search bar was also updated to distinguish between activities that are installed and those that are available to install.
This feature is available for activities from the Official and Orchestrator Tenant feeds.
Suporte para o Microsoft Office 2021
StudioX is now compatible with Microsoft Office 2021 and Office LTSC 2021. The Repair Tool for Microsoft Office now also supports Microsoft Office 2021.
Variáveis geradas automaticamente a partir de saídas de atividade
Até agora, para armazenar e usar a saída das atividades, você precisava criar variáveis manualmente. Agora, em projetos multiplataforma, para ajudar você a criar fluxos de trabalho mais rapidamente, o StudioX gera automaticamente uma variável para cada saída de atividade e oferece a opção de usar a variável em outras atividades ao longo do fluxo de trabalho. A variável é armazenada apenas quando consumida, o que significa que gerá-la não afeta o desempenho ou o tamanho do projeto.
The generated variable is available for use in other activities in the Expression Editor and by selecting the Plus
button > Use Variable in other editors and builders.
To make it easier to see what activity generated the variable, the variable’s name follows the format activity name→the name of the output property. The activity output is not visible in the Data Manager.
The Auto-generate Activity Outputs design setting gives you control over the automatic creation of activity outputs.
Melhorias
Melhorias do Data Manager
Suporte de classificação do Data Manager
You now have more freedom to group variables and arguments by dragging and dropping them in the Data Manager panel. The way you group these items becomes the default order for your project. The drag-and-drop feature is disabled when you select the Group items by scope menu option.
To make sorting data in the Data Manager easier, we've also introduced a new menu option, Sort sections elements, which lets you sort data by name (ascending or descending) or revert to the default order of your project. This option replaces sorting by right-clicking the Variables or Arguments sections individually.
Atualização do Data Manager
Using the Refresh button at the top of the Data Manager panel now refreshes local resources independently from Orchestrator resources. This means that you can use resources that refresh instantly (variables, arguments, and resources) while waiting for Orchestrator resources that can take longer to refresh. Refreshed resources are disabled while they are loading and become available after the loading finishes. Additionally, you can now use StudioX while data is refreshing.
Outras melhorias do Data Manager
- Novas variáveis e argumentos agora aparecem como os primeiros itens em seus respectivos nós no Data Manager.
- Várias melhorias de desempenho também foram feitas na maneira como os dados no painel do Data Manager são atualizados.
Dependências de tempo de design e runtime separadas
Para aumentar o desempenho do Robô e reduzir o tamanho dos pacotes publicados, os pacotes de atividades agora são separados em pacotes de design e runtime. Isso significa que, agora, as atividades publicadas contêm um pacote de design usado pelo StudioX e um pacote de execução menor usado pelo Robô. A separação se aplica apenas ao Windows e a atividades multiplataforma oficialmente suportadas pelo UiPath.
Rastreamento de aplicativos e URLs
StudioX can now track what external applications and URLs are targeted by an automation, providing insights into the automation workflow. This information is available for Windows and cross-platform projects after publishing in Orchestrator, Insights, and Automation Hub. Organizations have the option to prevent this information from being logged using governance policies. App tracking requires the latest versions of activity packages to be installed.
Melhorias na validação do projeto
A validação do projeto agora é mais rápida e usa menos recursos de RAM e CPU.
Automação do Excel
Novas atividades
- Lookup - Finds data in a range or sheet using the LOOKUP function.
Melhorias
- You can now use the Refresh pivot table activity to refresh all the pivot tables in a workbook. When you indicate the pivot table to refresh, a new option called All Pivot Tables is available in the Plus
menu for each Excel file. - You no longer need to specify the columns to compare when using the Remove duplicates activity. A new option now enables you to compare all columns.
- You now have more control over how the Copy/Paste Range activity handles the header of the source range. The Exclude source headers property has been replaced with a dropdown that enables you to exclude or include the header regardless of the source range, exclude it only if the source range is a range, or only if it is a table.
- When you create a pivot table using the Create Pivot Table activity, the fields added as pivot filters now appear one below the other in a column instead of in a single row.
- You can now use the Format Cells activity to set an underline style for the font. The following underline styles are available: none, single, double, single accounting, or double accounting.
- Columns with empty headers are now available for selection in the Plus
menu in Excel activity fields where you can select a column. For example, if column C doesn’t have a header while columns A and B do, when you access the column selector from the Plus
menu, the header values are displayed for the first two columns (A and B), and Column C is displayed for the third column. - The Filter Pivot Table activity now enables you to filter by pivot table rows and columns, not just filters. Row and column labels are available for selection from the Plus
menu of the Column Name field.
Outras melhorias
- You can now link StudioX projects to Automation Hub ideas from multiple Automation Cloud tenants.
- A instalação de dependências adicionais do projeto é mais rápida.
- The Basic License has been renamed to Automation Express License. For more information about this type of license, see the Automation Cloud Admin Guide.
- We added a Triggers filter option that you can select from the Filter by button at the top of the Activities panel. Selecting this option shows all the available triggers.
- Activities Only is now the default filter when searching for activities packages from the Manage Packages window.
- You can now use shared connections when designing projects that use Integration Service. The connection selector displays connections from your personal workspace, as well as those from shared folders in Integration Service.
Alterações interruptivas
- In previous releases, the Match Function activity threw an error when the value to match was not found. The activity now returns the value -1 in this scenario.
- In previous releases, if you used the Copy/Paste Range activity with a sheet as the source range and selected the option to exclude headers, the first row was not skipped, and the copied range started from cell A1. The activity now skips the first row and copies starting with cell A2 in this scenario.
Correções de bugs
- O StudioX parava de responder ao alterar o valor padrão caminho de arquivo de uma variável para um valor vazio e novamente para um caminho de arquivo no Data Manager.
- The Find First / Last Data Row activity sometimes took longer than expected to process data.
- The modern Read Range activity took longer than expected to process data. To increase performance further, we recommend setting the Read formatting option to RawValue and deselecting the Visible rows only option.
- An error occurred if you used a localized version of Windows and ran a project containing an Insert Column activity in which the data format was set to General.
- The Write DataTable to Excel and Write Range activities didn’t copy the column headers of empty DataTables that contained only headers.
- The Chinese translation for the Plus
menu option Ask when run was incorrect. - An error occurred if the Windows regional format was not set to English (United States) and you ran a project that used a Delete Rows activity with the option All visible rows on a range that included hidden rows.
- When the activities added in a Word Application Scope / Use Word File activity finished processing a document, the document was closed but the Microsoft Word application remained open.
- Novidades
- Pesquisar atividades de todos os pacotes oficiais
- Suporte para o Microsoft Office 2021
- Variáveis geradas automaticamente a partir de saídas de atividade
- Melhorias
- Melhorias do Data Manager
- Dependências de tempo de design e runtime separadas
- Rastreamento de aplicativos e URLs
- Melhorias na validação do projeto
- Automação do Excel
- Outras melhorias
- Alterações interruptivas
- Correções de bugs