Ruma

Ruma

  • NA
  • 7
  • 6.5k

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

Sep 3 2012 8:43 AM

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.



Answers (2)