From the course: Blue Prism: Excel Automation
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Get worksheet as collection - Blue Prism Tutorial
From the course: Blue Prism: Excel Automation
Get worksheet as collection
- The next step of the process will be to extract the information out of the weekly Excel report. We will be using the Get Worksheet as a collection from the Excel VBO. Create a new action just after the Remove Blank Rows. Double-click on it and call it Get Data from Weekly Report. From the business object, we're going to select the MS Excel video. From the action dropdown, we're going to navigate down to the Get Worksheet as Collection. As you can see here, we have three options for the same action. Get Worksheet as Collection, Get Worksheet as Collection Fast, and Get Worksheet as Collection Offset. The Get Worksheet Collection is a standard one which uses as input the handle, the workbook name, and the worksheet name. Each of these need to be entered in order the information to be extracted. The Worksheet as Collection Fast performs the same action as Get Worksheet as Collection. However, it does not require any inputs,…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.