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.

Create consolidation report file

Create consolidation report file - Blue Prism Tutorial

From the course: Blue Prism: Excel Automation

Start my 1-month free trial

Create consolidation report file

“

- [Instructor] As we now have the handle and the process name generated, we can move into creating the file itself. For this purpose we are going to create a new action which will be just after create instance. Double-click on the action in order to edit the properties. The action is going to be called create consolidated report. From the business object, we'll select Excel VBO, and from the action itself, we're looking for the Create Workbook action. The input of the handle variable will be the handle data item we just created, which is going to be the consolidated report handle. Now, navigate to the outputs tab where the workbook name variable needs to be generated. While creating variables, try to keep them as specific as possible. This helps in case variables need to be made global, and also, it makes it easier to understand their purpose later on. Call the workbook name consolidated report workbook name. Once…

Contents