Loading

Insert a value on two conditions in a excel using epplus

Dineshkumar

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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Srikant Maruwada8y ago
1. var package = new ExcelPackage(new FileInfo("sample.xlsx"));
3. ExcelWorksheet workSheet = package.Workbook.Worksheets[0];
4. var start = workSheet.Dimension.Start;
5. var end = workSheet.Dimension.End;
6. for (int row = start.Row; row <= end.Row; row++)
7. { // Row by row...
8. for (int col = start.Column; col <= end.Column; col++)
9. { // ... Column by column...
10. object cellValue = workSheet.Cells[row, col].Text; // This got me the actual value I needed.
11. }
12. }
https://stackoverflow.com/questions/21742038/how-do-i-iterate-through-rows-in-an-excel-table-using-epplus

Hope this will help you.
0