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 next empty cell - Blue Prism Tutorial
From the course: Blue Prism: Excel Automation
Get next empty cell
- In order to get the next empty cell, we'll need to create one more action. Which will be placed just after the right weekly data. Double click on it, and call it "Get Next Empty Cell." From the business object we'll select the "MS Excel VBO." And when it comes to the actions we're going to look for "Go To Next Empty Cell." The option you chose will depend on the direction you need to look for the empty cell. There are few options: up, down, left, and right. In this case we'll be using the "Get Next Empty Cell Down." The handle will be the consolidated report handle, so you can drag that across. This action requires a data item for storing the output. Click on the button to automatically create the cell reference. Once the changes have been made you can click on okay. Also, we'll need this "Get Next Empty Cell" to be just before the "Get Weekly Data." So we can delete the next stage, move the right weekly data down, and…
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.