- Notas relacionadas
- 2023.4.0
- 2023.4.6
- Primeros pasos
- Tutoriales
- Proyectos de automatización
- Crear automatizaciones
- Fundamentos de la automatización
- Repo. de objetos
- Mejores prácticas de automatización
- Tutorial: Crear una tabla dinámica
- Tutorial: Iterar a través de las filas de una tabla
- Tutorial: Comparar archivos de Excel y envío de errores de conciliación por correo electrónico
- Tutorial: Extraer datos de correos electrónicos automatizados y trasladarlos a una aplicación de escritorio
- Tutorial: Filtrar datos en Excel
- Tutorial: Formatear celdas
- Tutorial: Añadir información en los archivos de una carpeta a un archivo de Excel
- Tutorial: Añadir sus propias fórmulas al cuaderno del proyecto
- Automatización de PowerPoint
- Automatización de datos
- Actividades comunes
- Automatización de Google Workspace
- Automatización de OneDrive y SharePoint
- Solución de problemas
Fecha de lanzamiento: 27 de abril de 2023
Novedades
Buscar actividades de todos los paquetes oficiales
Ahora es más fácil encontrar la actividad adecuada para tu proyecto gracias a la posibilidad de buscar en todos los paquetes de actividades disponibles sin necesidad de instalar un paquete previamente. Esta característica está disponible en proyectos multiplataforma con StudioX conectado a 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.
Compatibilidad con 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.
Variables generadas automáticamente a partir de las salidas de la actividad
Hasta ahora, para almacenar y utilizar la salida de las actividades, necesitabas crear variables manualmente. En proyectos multiplataforma, para ayudarte a crear flujos de trabajo más rápido, StudioX crea ahora automáticamente una variable para cada salida de actividad y te da la opción de utilizar la variable en otras actividades a lo largo del flujo de trabajo. La variable solo se almacena cuando se consume, lo que significa que generarla no afecta al rendimiento ni al tamaño del proyecto.
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.
Mejoras
Mejoras en Data Manager
Compatibilidad con la clasificación de 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.
Actualización de 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.
Otras mejoras de Data Manager
- Las nuevas variables y argumentos ahora aparecen como los primeros elementos de sus respectivos nodos en Data Manager.
- También se han realizado varias mejoras de rendimiento en la forma en que se actualizan los datos del panel de Data Manager.
Dependencias separadas en tiempo de diseño y de ejecución
Para aumentar el rendimiento de UiPath Robot y reducir el tamaño de los paquetes publicados, los paquetes de actividades ahora se separan en paquetes de diseño y de runtime. Esto significa que las actividades publicadas ahora contienen un paquete de diseño utilizado por StudioX y un paquete de ejecución más pequeño usado por UiPath Robot. La separación solo se aplica a las actividades Windows y multiplataforma oficialmente compatibles con UiPath.
Seguimiento de aplicaciones y URL
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.
Mejoras en la validación de proyectos
Ahora la validación del proyecto es más rápida y utiliza menos recursos de RAM y CPU.
Automatización de Excel
Nuevas actividades
- Lookup - Finds data in a range or sheet using the LOOKUP function.
Mejoras
- 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.
Otras mejoras
- You can now link StudioX projects to Automation Hub ideas from multiple Automation Cloud tenants.
- La instalación de dependencias adicionales del proyecto es más 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.
Cambios de última hora
- 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.
Corrección de errores
- StudioX dejaba de responder al cambiar el valor predeterminado de una variable desde una ruta de archivo a un valor vacío y de nuevo a una ruta de archivo en 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.
- Novedades
- Buscar actividades de todos los paquetes oficiales
- Compatibilidad con Microsoft Office 2021
- Variables generadas automáticamente a partir de las salidas de la actividad
- Mejoras
- Mejoras en Data Manager
- Dependencias separadas en tiempo de diseño y de ejecución
- Seguimiento de aplicaciones y URL
- Mejoras en la validación de proyectos
- Automatización de Excel
- Otras mejoras
- Cambios de última hora
- Corrección de errores