Import XLSX to winforms DataGridView

Apr 8, 2014 at 4:49 PM
Edited Apr 8, 2014 at 4:50 PM
I am trying to import the data from an excel file but when iterating I am not sure how to determine where the worksheet.Cells ends.

I know there is a worksheet.Cells.End function but comes back with something like 100000 rows and 16000 columns and not the end of the actual rows.

How can I get bottom right index row,column of the last record in the excel file?
Editor
Apr 8, 2014 at 4:53 PM
Did you try worksheet.Dimension ?

Regards,
Thiago
Apr 8, 2014 at 5:27 PM
I actually just came across Dimension.End.Row and Column a few minutes ago.
Will use that and see.
Thanks.