Loading

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

Ruma

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ruma14y ago
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 White14y ago
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.