UiPath Excel Read Range vs. Workbook Read Range activities
This video offers a full tutorial on the Excel Read Range and Workbook Read Range activities. It looks at their similarities as well as differences, and more importantly - in which context we should use each of them.
I would conclude that the Excel Read Range would be preferred when:
we need anyway to do that as part of a larger set of activities within the excel file, like maybe running also some macros, and an Excel Application Scope is anyway required
we need to consider the filters applied to the excel file
speed is critical (it was in our test about 6-7 times faster than the workbook activity)
we do not need to open the excel file, it can run in background even when the excel file is opened
The Workbook Read Range should be used when:
we want to be sure the excel file is already closed and not used by another process when we start reading from it, otherwise we want to throw an exception - this could be used as a "synchronization" or "lock" feature
we need to work with password protected workbooks
Microsoft Excel is not installed on the client that runs the bot
a few milliseconds don't make e difference and we just want to quickly read some data with just one quick activity, instead of two activities.
00:01 Topic and summary of the video
00:19 UiPath Hacks intro theme
00:57 The Excel Read Range Activity overview
04:11 The Workbook Read Range Activity overview
05:02 Some more subtle differences between the Excel and Workbook Read Range activities
10:32 When to use the Excel Read Range
11:09 When to use the Workbook Read Range
11:43 Wrap-up and conclusion
Let us keep in touch:
/ gabrielverzea
Watch video UiPath Excel Read Range vs. Workbook Read Range activities online without registration, duration hours minute second in high quality. This video was added by user UiPath Hacks by Gabi Verzea 27 December 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 7,588 once and liked it 54 people.