Question

2
Replies
303
Views
Dipesh Barakoti (DipeshB2)
Coforge BPM
Associate System Architect
Coforge BPM
US
DipeshB2 Member since 2018 5 posts
Coforge BPM
Posted: December 18, 2018
Last activity: January 3, 2019
Posted: 18 Dec 2018 18:17 EST
Last activity: 3 Jan 2019 9:23 EST
Closed
Solved

How to append range of data in a new Excel Workbook in a single sheet in each iteration.

My used case requires filtering data in one excel application and paste it into another. The Filter parameter is based on date and the result is range of data in each iteration. I have been able to figure out the filtration and export part but every time I import, the old range of data copied in the destination excel sheet gets replaced by the new range. I found counter tool from the tool box as a possible solution to set the cell values for next iteration, but I have not been able to figure out how to make it work for the range of data basically to append in the same worksheet not replacing what I already have.

Does anybody know how to accomplish this?

Robotic Process Automation
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.