Order Sheet Name Ascending on Excel

[aliaga (Ali Aga Mustofa)]

Hello All,

I have litle problem, so i have an excel file are using copy sheet from excel A to excel B.
but the result is make my sheet on excel B filled by sheet with random ordering (B,C,A,E).
i have read thread here : link

my question is, how to implement it in uipath and if any other solution please help

Thankyou

[lakshman (Ganta lakshman)]

@aliaga

I request you to create this kind of threads into RPA Developer section but not under user voice section. As of now i changed it. Please follow this thing from next time onwards.

Please check below thread and it might help you.

Sorting of excel workbook-sheets using invoke code activity

hi The Solution to this problem is that using the instance of Microsoft.Office.Interop.Excel.ApplicationClass you are allowed to open a workbook using xlApp.WorkbooksxlWorkBooks.Open(“Path of your File”) Once the workbook is Open all you need to do is get all the sheet names and apply any of the Sorting Technique.and move the sheet accordingly. do find the Attached Solution.Main (2).xaml (14.2 KB)

[aliaga (Ali Aga Mustofa)]

Hi @lakshman,

im sorry, and thankyou for moderate my thread…

Thank you

[balupad14 (Balamurugan)]

Hi @aliaga,

Here is an activity called “MoveSheet”. That enables to order the work sheet as you desire.

UiPath Go ! BalaReva EasyExcel Activities

** Move Sheet Activity ** Properties [image] Regards Balamurugan.S

Regards
Balamurugan.S