From the course: Introducing Blue Prism

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Get all orders using Excel VBO

Get all orders using Excel VBO - Blue Prism Tutorial

From the course: Introducing Blue Prism

Start my 1-month free trial

Get all orders using Excel VBO

- [Instructor] As we now have the Excel VBO, we can move on to working on the getting the data from the Excel. The first action we'll require is create instance which is always required when an interaction with Excel file is performed. In order to create a handle for the Excel process. For this purpose, we're going to click on Action, and place it on the grid. We'll double click on the action, and call it Create Handle. From Business Objects, we'll look for the Excel VBO, and from actions, we'll look for the create instance. For the inputs, when it comes to enable event, we'll select that to true, and when it comes to outputs, we have only one which is handle from type number. We can click on this button in order to automatically create the data item, and we'll click on OK. You can actually delete the note in order to replace that with the newly created flow. The next required action would be to show the workbook. Keep in mind, you can copy and paste the same action just because we're…

Contents