Copy last column and insert new in excel with formatting

[Joshikumarav (Joshi Kumar)]

Thanks man. I used a different approach with hotkeys.

1. I know which cell I have to traverse.
2. Send hotkey event to call “find cell shortcut” [Ctrl + G]
3. Enter the cell address and press enter
4. Send hotkey to select entire column [ctrl + shift + down]
5. Send hotkey to copy [Ctrl + c]
6. Go the next column and paste
7. Delete the contents

CompanyList.xlsx (10.4 KB)
project.json (300 Bytes)
Main.xaml (15.9 KB)

It was quite difficult and I would want to share it with the community, so they can go reuse and improve it. i used the below answer as a base.

Send HotKey ctrl-F to excel does nothing

I have tried seemingly every variant I can think of in target, etc. It should open the find dialog and does if I do it manually but everything I try won’t let the robot do it. this is on excel on the same computer that the uipath studio community edition is running on.CompanyList.xlsx (8.7 KB) Main.xaml (18.3 KB)