Articles → UiPath → Difference Between Read Range Activity In Workbook Vs Read Range Activity In Excel

Difference Between Read Range Activity In Workbook Vs Read Range Activity In Excel

Difference

1. Use the "Excel Application Scope" activity
2. Install Microsoft Office on the machine where the bot is running

Example

1. Drag and drop the "Read Range" activity from the "Workbook"
2. Inside the "Read Range" activity, specify the Excel file name, sheet name, and the range
3. Store the output in a datatable variable

Click to Enlarge


4. Drag and drop the "Output Data Table" activity to convert the datatable to the comma-separated string
5. Stores the output in a string variable

Click to Enlarge


6. Display the value of the string variable in the messagebox

Output