ExcelDataReader ponts to different sheet

May 31, 2013 at 8:50 AM

I have used ExcelDataReader to read sheets from excel and converted to a dataset using the AsDataset method.

I have all the sheets as datatable. When i read the 4th sheet (DataTable), it actually reads another sheet..

For eg:.

I have sheets
1 Org Structure
2 Account Codes
3 Users
4 User Access
5 Financial Data
6 Budget Input Sheets

I have all these sheets as a Datatable... Whne i refer Dataset.Tables[2], it actually takes data from sheet 6 Budget Input Sheets

The excel sheets were once moved back and forth...

Could anyone sugges what might be the issue?

Sep 27, 2013 at 12:13 AM
I am also having the same issue, has there been a solution to this issue? I thought maybe that the sheet order in the VBA Project might have something to do with it, but they don't line up with the dataset.table order either.

Any ideas anyone?