From the course: UiPath: Robotic Process Automation (RPA)

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Append data table into a worksheet

Append data table into a worksheet - UiPath Tutorial

From the course: UiPath: Robotic Process Automation (RPA)

Start my 1-month free trial Buy for my team

Append data table into a worksheet

“

- [Instructor] In this video, we'll take a look at how to apphend information to a worksheet from a data table variable. In order to speed up this demo, I'm just going to keep using the same worksheets we've been using and in the last video, we did a right range that had three rows in it and you may recall that it didn't overwrite this fourth row that was present from the previous write. I'm going to go ahead and clear out this data by right-clicking and deleting all the rows and I'm also going to delete this sheet one that came for free when this file was created by UiPath. So I'll control-S to save and close this one up and now when we write and apphend, it's going to go into this existing file. So back here in our UiPath process, you may recall that we're reading some information in from one spreadsheet and writing it into another. I'm going to reuse this block, which is an Excel application scope, so I'll double click on that and after this right range, I'll go into my activities…

Contents