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

Help
,
1

Hello,

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

I want to replicate the “Control + -” operation done in excel in uipath and finally the data table should look like this
After
How shall I achieve this?
Please help me out.

Thanks and Regards,
Shreyas Shete.

2

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.

1 Like
3

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

1 Like
4

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

1 Like
5

Hi @shreyasshete

How about this solution like below.

Sequence
Sequence498×1017 52.1 KB

2 Likes