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,


#3

Hello. I want to ask if how do you compare data retrieved from an excel spreadsheet to another spreadsheet


#4

Thanks


#5

Thanks Lucas.Pimenta :slight_smile: