Question

how copy specific data from one excel to another

  • 10 July 2024
  • 1 reply
  • 8 views

Badge +3

I want to copy some rows from one excel to another excel in automation anywhere.


1 reply

Userlevel 4
Badge +6

At a simple level:

Open both the Excel files.
Loop through the source Excel file, assigning each row to a Record variable.
    Inside the Loop, use a combination of Set Cell and Go To Cell to put each column of the record variable into the target Excel file.
Save your target Excel file.
Close both files.

See these documents for more information:
https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-excel-command.html
https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-loop-command.html

Also visit the Pathfinder Academy and watch the “Getting Started With Excel” video. It shows you exactly how to do this. It’s free!

Reply