This project is read-only.

Display newest worksheet on Workbook Open

Dec 18, 2014 at 1:40 PM
Edited Dec 18, 2014 at 4:04 PM
Another question regarding NPOI 2.1.3: When I add a new page to an existing workbook, I want that new page to be the first one my user sees when the newly-updated workbook opens in Excel. I've tried using "sheet1.SetActive(true)", but that doesn't do it. Am I using the method incorrectly, or is there another way?

I've tried using .SetActive() immediately after .CreateSheet(), and immediately before workbook.Write(filestream). I've also tried .IsSelected = true. Nothing's worked so far.