Sorting of excel workbook-sheets using invoke code activity

excel

#1

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)


#2

Try adding below to code

xlWorkBook.Save()
xlApp.Quit()