ram-sagar-mourya

    private DataTable ReadExcelSheet(string fname, bool firstRowIsHeader)
    {
        List<string> Headers = new List<string>();
        DataTable dt = new DataTable();
        using (SpreadsheetDocument doc = SpreadsheetDocument.Open(fname, false))
        {
            //Read the first Sheets 
            Sheet sheet = doc.WorkbookPart.Workbook.Sheets.GetFirstChild<Sheet>();
            Worksheet worksheet = (doc.WorkbookPart.GetPartById(sheet.Id.Value) as WorksheetPart).Worksheet;
            IEnumerable<Row> rows = worksheet.GetFirstChild<SheetData>().Descendants<Row>();