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)