I have a report rendered from Reporting Services 2005 in Excel format.
I am able to stream the report but when try to get the data in a dataset it fails.Exception Thrown. Unable to cast object of type 'Excel.Core.BinaryFormat.XlsBiffRecord' to type 'Excel.Core.BinaryFormat.XlsBiffDbCell'.
If i however open the excel report and save it, then run my code, everything works fine. i've tried the recommended version v2 as well as the latest but to no avail.
FileStream inStream =
//1. Reading from a binary Excel file ('97-2003 format; *.xls)
IExcelDataReader excelReader =
//3. DataSet - Create column names from first row
DataSet result = excelReader.AsDataSet();
//Exception Thrown here