Insert a value on two conditions in a excel using epplus

Question

Hi all I have a excel sheet with data from column A to E. Now I have to search a specific value in column A and another specific value in column C where both should be in same in row. If the row meet my condition then I have to a value to column F of that row which meet both condition. Please help to solve this. Thanks in advance.

Srikant Maruwada · Answer

var package = new ExcelPackage( new FileInfo( sample.xlsx )); ExcelWorksheet workSheet = package.Workbook.Worksheets[0]; var start = workSheet.Dimension.Start; var end = workSheet.Dimension.End; for ( int row = start.Row; row { // Row by row... for ( int col = start.Column; col { // ... Column by column... object cellValue = workSheet.Cells[row col].Text; // This got me the actual value I needed. } } https://stackoverflow.com/questions/21742038/how-do-i-iterate-through-rows-in-an-excel-table-using-epplus Hope this will help you.