Accessing individual sheets in a .xlsx file

Oct 2, 2009 at 11:13 AM

Great tool it has saving me a lot of time.

I have one question. I'm using the 2007 access methods,

stream = File.Open(excelFilePath & FileUpload1.FileName, FileMode.Open, FileAccess.Read)

excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream) ........

Is there a way to specify a specific sheet in the workbook using this method? If not it would be useful.

Many thanks

Tony