Sort Excel sheet by column using EPPlus

Question

I'm using EPPlus to generate Excel workbooks.

I'm trying to figure out how to either:

1. Sort a worksheet by a specific column (the equivalent of clicking sort A-Z in Excel) or...
2. Set the sort order for a specific column's AutoFilter

Answer 1

var startRow = 1;    
var startColumn= 1;
var endRow= 10;
var endColumn= 10;
var sortColumn = 5; //6th Column because index is ZeroBased.
using (ExcelRange excelRange = yourWorkSheet.Cells[startRow, startColumn, endRow, endColumn])
     {
         excelRange.Sort(sortColumn, true);
     }