How to change sequence of Worksheets?

Question

Hi,I am supposed to do further processing on a .xlsx-File that was created elsewhere. So I'd like to change the order of worksheets within that Workbook - is that doable or would I have to create a new wb and then copy on sheet after the other into that new wb?Thanks, Michael

Abirami Varadharajan · Answer

Hi Michael, 

Thank you for contacting Syncfusion support. 

Yes, you can change the position of the worksheet in the workbook. Please refer below documentation for moving the worksheet from one index to the another. 

https://help.syncfusion.com/file-formats/xlsio/working-with-excel-worksheet#moving-a-worksheet  

We have also prepared simple sample and shared for your reference which can be downloaded from the following link. 

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/Sample558902804.zip  

Regards, 
Abirami.