Search code examples
c#excelepplusepplus-4

EPPlus set default worksheet


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.


Solution

  • 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();