Get the last data filled excel row number in C# -
i have been trying row number effectively. fails data cleared , cells not explicitly deleted. i guess because of "used range". what did using epplus using (var excel = new excelpackage(hpf.inputstream)) { var ws = excel.workbook.worksheets["sheet1"]; if(ws.dimension.end.row > 2003) { var result = new jsonresult(); result.data = "filelimitexceeded" ; but gives me incorrect data. how last count effectively. i found var lastrow = cells.find("*", [a1], , , xlbyrows, xlprevious).row; but namespaces not comprehend. me complete , correct answer ? i have come senario few days before, did read data , put in data table, , filter data show records when data not null. can go same approach.