How to find the number of rows and columns for the Excel Table
This article describes how to find the number of rows and columns for the Excel Table.
I want to find the number of rows and columns for the Excel Table.
Please refer the below screenshot to find the number of rows and columns for Excel Table.
Tosca 12.0 and below (Classic Excel Engine):
Here .rowcount will give the total number of rows in the table along with the Header of the table and .colcount will give the total number of columns in the table.
In the above case, we have 2 extra rows as below.
- Header of the Sheet.
- Header of the Table.
Tosca 12.1 (TBox Excel Engine 3.0 ):
You need to define excel range by using the TBox Define Excel Range module prior to have the row count or the column count.
As the names indicate RowCount will give you the total number of rows present on the Excel range that you are defining and the same with ColumnCount as well.
Classic Excel Engine:
TBox Excel Engine: