ExcelDataReader not reading the xls file in some cases

Question

When using excelDatareader for some Excel file the ExcelReaderFactory.CreateOpenXmlReader(stream) is returning null and not taking the filestream. But for some excel file it is running perfect.

Can somebody explain me the reason?

static void Main(string[] args)
{
    FileStream stream = File.Open(@"C:\Users\nichi-user\Desktop\BLRJCCI.xls", FileMode.Open, FileAccess.Read);

    IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);

    DataSet result = excelReader.AsDataSet();

    result.Tables[0].TableName.ToString();
}

enter image description here

gery128 · Accepted Answer · 2015-01-22 13:34:57Z

7

Excel can be of two types: -Binary (MS Excel 2003 and older versions - .xls) -Zip - based on Open Office XML standards (MS Excel 2007 onwards - .xlsx)

You should try to use following for older excel format files:

ExcelReaderFactory.CreateBinaryReader(fileStream);

answered Jan 22, 2015 at 13:34

gery128

965 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Johan Appelgren · Accepted Answer · 2017-08-19 12:21:32Z

3

ExcelDataReader can in most cases detect what type of file it is if you use ExcelReaderFactory.CreateReader instead. See https://github.com/ExcelDataReader/ExcelDataReader for supported formats and versions.

answered Aug 19, 2017 at 12:21

Johan Appelgren

3411 silver badge5 bronze badges

Collectives™ on Stack Overflow

ExcelDataReader not reading the xls file in some cases

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related