I have an Excel workbook that has 72 worksheets, however, I only need to load 7. Following the example here (http://www.aspose.com/docs/display/cellsnet/Load+only+Specific+Sheets+in+a+Workbook), does not work. I still get all 72 worksheets (ie workbook.WorkSheets.Count = 72). Even using just a simple Excel workbook (see attached), with 3 worksheets and using the exact code mentioned in link, still has a WorkSheets.Count = 3.
I need to be able to do the following....
Load specific worksheets, without prior knowledge of the load format and with the LoadDataOnly = false.