From the course: Blue Prism: Excel Automation

Unlock the full course today

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

Save consolidated report

Save consolidated report - Blue Prism Tutorial

From the course: Blue Prism: Excel Automation

Start my 1-month free trial

Save consolidated report

“

- [Narrator] The last few steps of the process are to finalize the Summary Tab and to save the report. We'll start with finalizing the Summary Tab. We now have all the information which needs to be transferred into the Summary Tab, stored in the Summary Tab Data Collection. The Collection contains a summary of all of the GL accounts, and the associated amount balances. In order to write the information back to the Excel on the Create Summary Tab, we're going to create one more Action which will be located just after the end stage of the GL accounts. We'll rename the Action to Update Summary Tab. From the Business Object select the Excel VBO, and when it comes to the Action we'll select the Write Collection. Here you see, we have a few inputs required. For the Handle itself we're going to drag across the Consolidated Report Handle. The Workbook Name is still Default. And we'll call it, "Book 1". The Collection…

Contents