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,
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.
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
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
How about this solution like below.