Number of data rows in excel?



Is it possible to get to know the total number of rows in the excel? . I have a scenario where i need to insert a footer after the report has been bound to excel, but i have no clue as to which is the last data row. Could you help me on this pls?




Please try to use Cells.MaxDataRow property.