I need to read a excel data using C#.
If my excel format is .xlsx I'm using ExcelReaderFactory.CreateOpenXmlReader(stream)and for .xlsExcelReaderFactory.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.