Please help its very needed currently.
The output databale does not have the bool which i am looking for.
The excel file is not able to read this record, the follwoing code which gives me the data table it has bool conversions (True,False) which are not represented in the datatable. its all blank and null
FileStream stream = File.Open(fileName, FileMode.Open, FileAccess.Read);
//1. Reading from a binary Excel file ('97-2003 format; *.xls)
IExcelDataReader excelReader = ExcelReaderFactory.CreateBinaryReader(stream);
//1. Reading from a OpenXml Excel file (2007 format; *.xlsx)
//IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
//3. DataSet - Create column names from first row
excelReader.IsFirstRowAsColumnNames = true;
DataSet result = excelReader.AsDataSet();
If you want i can send you a sample file.