Unable to read a macro enabled excel file using Excel Data Reader

Question

I need to read a excel data using C#.

If my excel format is .xlsx I'm using
ExcelReaderFactory.CreateOpenXmlReader(stream)
and for .xls
ExcelReaderFactory.CreateBinaryReader(stream)

When the file is marco emabled (extension .xlsm) what I need to use?

If I'm saving the file in .xls format also DataSet is coming as null.

Ruma · Answer

Hi Sharon My file is Ok and I have to read in the way I mentioned. In my project I have several excel upload but all are normal .xls or .xlsx. Only one is macro enabled.

Sharon White · Answer

Hello Is there some problems with your Excel file? For example some invalid objects exist. If your file is OK maybe you can try to use some .NET Excel tools to read.