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.
but the result it is like random data.
You could do one thing.
- Read Range from sheet1
- Use sort datatable activity
- 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
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.
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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.