Iterate through Excel using Epplus

Question

Get the Entire row details in Epplus by using Linq in c#.

Dinesh Santhalingam · Answer

Manii understand itHere i am facing a small pbm In my excel range A:A there is a Row Starts with Total Value.I need to find out this and get all the cell values that in a row.can you please help me to solve this?

Manikandan Murugesan · Answer

Hii Dinesh Use the following code for iterate the Excel using Epplus 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 { // ... Cell by cell... object cellValue = workSheet.Cells[row col].Text; // This got me the actual value I needed. } } And also refer the following LInk : https://msdn.microsoft.com/en-us/library/dd920313%28v=office.12%29.aspx

Manikandan Murugesan · Answer

Refer the following Link : https://stackoverflow.com/questions/31433189/how-to-get-range-in-epplus