Change Tab/Sheet Order

GemBox.Spreadsheet
1

Is there a way to rearrange the order of sheets/tabs within a given workbook after they’ve been generated?

I have a multi-sheet workbook that requires certain sheets be generated first to help populate the last sheet, but I want the last sheet to show up first in the list from left to right.

2

Hi Jeff,

You can use ExcelWorksheetCollection.Move() method, for example:

ExcelFile workbook = ...

// Move last sheet to be first.
workbook.Worksheets.Move(workbook.Worksheets.Count - 1, 0);

Does this solve your issue?

Regards,
Mario