1
Vote

How to Add New Header Names?

description

I am using below code to get all excelsheel sheet data.

IExcelDataReader excelReader = ExcelReaderFactory.CreateBinaryReader(stream);
                excelReader.IsFirstRowAsColumnNames = true;                    
                DataSet result = excelReader.AsDataSet();
                excelReader.IsFirstRowAsColumnNames = false;                    
                dtExcelSheetData = result.Tables[SheetName];
But I want add my own column names.

comments