Slow Access to Sheets in large excel packages

Dec 4, 2016 at 8:53 PM
Hi,

Fantastic library, cant live without it :)

I am creating some pretty large spreadsheets to look at data (around 250 Meg) -

One thing I notice is that when I load sheets , it takes really long -

Code like:

var worksheet = package.Workbook.Worksheets["Sheet1"];
I wouldn't expect that to take so long, is there a better way to get sheets by name?

Thanks