EPPlus set default worksheet

Question

I am using EPPlus v4.1 to generate an excel file in C#.

Is there a way to set a specific worksheet as the default worksheet? (when the user is opening the exported file, that sheet should be shown)

I could not find a method or property on ExcelWorkbook or ExcelWorksheets classes.

Answer 1

I found the answer meanwhile. I don't want to delete the question because it might be useful to someone else.

//this line sets the first tab in the excel file as default/active
    Workbook.Worksheets.First().Select();

Answer 2

For EPPlus 5 the answer is:

sheet.View.SetTabSelected();

Answer 3

None of the other answers worked in my case (not sure what was specific about my particular case), but I was able to set the active worksheet using the below (using EPPlus v4.5.3.3):

excelPackage.Workbook.View.ActiveTab = worksheet.Index;