Articles → UiPath → Read And Write Data In Excel In Uipath

Read And Write Data In Excel In Uipath

Excel Application Scope

1. Open the excel file
2. Specifies the scope of an excel activity
3. Close the excel file when the excel activity is completed
4. Creates an excel if the file does not exist

Example

1. Drag and drop Excel Application Scope
2. Inside the Excel Application Scope, add the Read Range Activity

Click to Enlarge


3. Assign the value of the Read Range activity to a DataTable variable in the property window

Click to Enlarge

1. Drag and drop the second Excel Application Scope
2. Inside the Excel Application Scope, add the Write Range Activity
3. Set the data source to the datatable

Click to Enlarge

Output