Excel row and column count

[g444ran]

Is there any way to get the row and column count in an Excel. Kindly provide some solution.

 

[VJR]

Hi g444ran,

Not sure you meant the number of rows/columns with data or without.

Both the solutions are given in this link.
http://rpaforum.net/threads/find-the-number-columns-in-excell-sheet.502/

 

[krrish9199]

Create an Array variable and give your excel as input to it.And the use "Array row" and "Array column" system variables to get total no of rows and columns.