How to Move a sheet using EPPlus?

Question

What is the command needed in EPPlus , to move a worksheet location in a workbook?

I couldn't find any Move command for EPPlus only Interop.

Answer 1

There are four methods for moving a worksheet. They are

excelPackage.Workbook.Worksheets.MoveAfter()
excelPackage.Workbook.Worksheets.MoveBefore()
excelPackage.Workbook.Worksheets.MoveToStart()
excelPackage.Workbook.Worksheets.MoveToEnd()

Answer 2

For anybody finding this in 2021, @chandler is totally correct, but let me add this:

//
// Summary:
//     Moves the source worksheet to the start of the worksheets collection
//
// Parameters:
//   sourceName:
//     The name of the source worksheet
public void MoveToStart(string sourceName);

myExcelPackage.Workbook.Worksheets.MoveToStart(myExcelWorkSheetObject.Name);

The worksheetName input parameter tripped me up.