Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to determine the most recently viewed worksheet ("ActiveSheet") in EPPlus

When you open a workbook in Excel, it shows you the worksheet you were looking at when you last saved it.

How do you determine which sheet this is when you open a workbook using EPPlus?

like image 560
franzo Avatar asked Sep 02 '13 06:09

franzo


1 Answers

ExcelWorksheet activeSheet = Workbook.Worksheets.FirstOrDefault(f => f.View.TabSelected);

https://epplus.codeplex.com/discussions/456307

like image 161
franzo Avatar answered Nov 14 '22 23:11

franzo