Import subset of Data from Excel

Mar 4, 2014 at 2:20 PM

I am new to this but I have been using the ExcelDataReader to upload an Excel Spreadsheet to a Database,

this has worked great for a spreadsheet with just one set of data in it but I have been asked to extend this to allow the import of data from a range within the spreadsheet, for example A3:K? Where the data could continue for any number of records.

Is this possible? or is there anything that you can suggest?


Apr 25, 2014 at 6:26 PM
I have just had to implement something like this when we switched from OLE DB to the Excel Data Reader to read Excel files in our product. I modified the Excel Data Reader code to make it possible to:
  • read a specific worksheet into a data table (instead of reading the entire workbook into a dataset and then retrieving the data table of interest)
  • read a specific cell range from a specific worksheet into a data table
I am about to contact the Ian1971 to see if it would be possible to integrate these changes into the Excel Data Reader.
Apr 30, 2014 at 1:50 PM
I just replied to your email Daniel if you wanted to send me the changes.

It seems a bit stone age to be emailing changes around, but codeplex forces us into this. I really need to migrate this to github.