Arrange excel data table after copy to new sheet

I need to copy datarow from sheet 1 and paste it to Sheet to.
as my expected output is what datarow copy from sheet 1 it should be paste 1st in sheet 2.

Sheet 1
image

but the result it is like random data.
Sheet 2
image

Expected output
Sheet 1
User1
User3
User5
User7
User8
User10

Bot Process
Sheet 2
User 2
user4
User 6
user 9

Hey @Vincent_Nuestro
You could do one thing.

  1. Read Range from sheet1
  2. Use sort datatable activity
  3. Write range in sheet2.

Open the excel in application scope read the sheet 1 with reade range and use write range to paste it in some other sheet just chnage the sheet name in write range
if you are using any condition what should go in sheet 2 then you have to use either invoke method import that datarow to differnt sheet or create some newrow vaiable and assign the value

Hi @Vincent_Nuestro

Please find attached XAML and result workbook.
If the result is as expected please mark it as a solution.
and let me know if anything is needed.

Thank you,
Prashant

CopySheetDataAndSort.xaml (6.7 KB)
Result.xlsx (9.3 KB)

hi @PRASHANT_GABHANE can i have the screenshot instead?

I cant open the file, because if the Uipath version

image
image

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.