[URGENT!] How to do "control + -" operation on Datatable in uipath

[shreyasshete]

Hello,

I extracted a datatable using DataScaping technique and output looks like as the sample given below

I want to replicate the “Control + -” operation done in excel in uipath and finally the data table should look like this

How shall I achieve this?
Please help me out.

Thanks and Regards,
Shreyas Shete.

[srdjan.suc]

If you know how/what to use those controls in Excel, you can use Type Into activity while Excel file is opened to send the appropriate commands to the file.

[shreyasshete]

Thanks
But, I am using Workbook activity and I won’t be writting it to excel. Just to show here I did so and in my case I shall use this Datatable for further operations.
Any other solution you can thinks

[srdjan.suc]

You can create new DataTable and shift the values using For Each Row and Add Data Row activities.

Forum3.zip (8.3 KB)

Example. Might help you

[wusiyangjia (Siyang Wu)]

Hi @shreyasshete

How about this solution like below.