How to count the row and column in a excel

excel
activities

#1

I need the answer for number of rows and columns in a excelsheet.If anyone knows share your answer…

advance thanks…


#2

Hello!

Use a Read Range to get all the information from the Excel File and then assign to a variable the count of columns and rows.

Example:

rowsCount = datatableExcel.Rows.Count
columnsCount = datatableExcel.Columns.Count

Here’s a example done: excelCounts.xaml (8.0 KB)

Hope It Helps!

Regards,