Note that the original Notes document is still stored in its database or Notes application; the version with the newest changes that has not yet been saved is the. This website uses cookies to deliver its services, to personalize ads and to analyze traffic. By using this site, you agree to its use of cookies.
Welcome to the UiPath Studio guide. You'll find comprehensive information about Studio to help you get started as quickly as possible.Change the documentation version, language, or guide from the left drop-down list. If you think something can be improved, feel free to suggest edits.Please note that UiPath does not license or provide support for any third-party software referenced herein, and does not guarantee compatibility beyond the versions specifically listed. Please review and confirm the specifications and terms and conditions of any third-party software with its respective owner and/or licensor.Keep in mind that the documentation for each major version also contains any change made by subsequent patches.
For example, the 2018.4 version contains all updates brought by all its patches, such as v2018.4.5.Lastly, may the search be with you! Example of Using DataTable VariablesTo exemplify how you can use DataTable variables, we are going to create an automation that reads only two out of multiple columns from an Excel spreadsheet, and then transfers them to another spreadsheet that already contains other information.The initial file is a database of people, transactions, dates, and products. In this example, we are going to extract their names and order dates and append them to an Excel spreadsheet that already contains similar information. Create a new sequence. Add an activity to the sequence.
This activity is required for most of the Excel-related activities. Create two DataTable variables, NamesList and DateInfo. These are going to be used to store information from the initial Excel spreadsheet. In the Properties panel, in the WorkbookPath field, type the path of the initial Excel file to be used, between quotation marks. Add two activities and place them one under the other, in the Excel Application Scope activity. These are used to get information from the initial spreadsheet.
Select the first Read Range activity and, in the Properties panel, in the Range field, type 'G7:G37'. These are the Excel table coordinates that tell UiPath Studio from where to extract information. In the SheetName field, do not make any changes as the name of our sheet is the default one, Orders. In the DataTable field, type the name of the first DataTable variable, NamesList. This variable stores all the information available between the G7 and G37 rows.
( Optional) Change the value in DisplayName field to Read Names, so you can easily tell apart this activity from the second one. Select the second Read Range activity, and in the Properties panel, in the Range field, type 'C7:C37'. These are the Excel table coordinates that contain the order date we want to extract. In the DataTable field, specify the DateInfo variable. This variable retains all the date information we require.
In the Activities panel, under System File Workbook, add a activity to the Designer panel, under the Excel Application Scope. This activity is used to write the stored information to another Excel file.