Access row data of excel.

Question

Emp id Mail id 1234 abc.xyz.com 2345 qwe.asd.com 3456 zxc.asd.com 4567 lkj.mnb.com 5678 poi.mnj.com 6789 mko.bhu.com 7890 cft.vgy.com I have excel data in this fromat. From website I getting these Id not same at all time. I want to get these mail id for particular emp id in C# function.

Tapan Patel · Answer

Not the most ideal way but some basic implementation (Open XML SDK) would help in your case. Only change you need to make is  instead of printing data to console try creating models to hold these properties from excel and store it in list. Also try to make some null checks for empty columns (if cell is modified with no values in it). public class ReadExcelFile { public ReadExcelFile( string FileName) { using (SpreadsheetDocument spreadSheetDocument = SpreadsheetDocument.Open(FileName false )) // false to disable editing of this file { WorkbookPart wbPart = spreadSheetDocument.WorkbookPart; IEnumerable sheets = wbPart.Workbook.GetFirstChild ().Elements (); string id = sheets.ElementAt(0).Id.Value; // zero based index for number of sheets WorksheetPart wshPart = (WorksheetPart)wbPart.GetPartById(id); SheetData shData = wshPart.Worksheet.GetFirstChild (); IEnumerable rows = shData.Descendants (); foreach (Row row in rows) { foreach (Cell cell in row.Descendants ()) { Console.Write($ {GetCellValue(wbPart cell)}	 ); } Console.WriteLine(); } } } private string GetCellValue(WorkbookPart wbPart Cell cell) { if (cell.DataType != null && cell.DataType.Value == CellValues.SharedString) { return wbPart.SharedStringTablePart.SharedStringTable.ElementAt(Int32.Parse(cell.CellValue.InnerXml)).InnerText; } else return cell.CellValue.InnerXml; } }

Shantanu Dhole · Answer

what if I want to do it with oledb.

I have excel data in this fromat. From website I getting these Id not same at all time. I want to get these mail id for particular emp id in C# function.