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.
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();
For EPPlus 5 the answer is:
sheet.View.SetTabSelected();
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With