Number of data rows in excel?


#1

Hi,

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?

Regards,

Soumya


#2

Please try to use Cells.MaxDataRow property.