Datarow count

  • Last Post 19 June 2019
2509 posted this 18 June 2019

How to get row count in datatable or count of files in directory ?

Swathi Muppalla posted this 19 June 2019

Hello Megha,

Thank you for reaching out to the Intellibot Forum Support Team.

You can use the below-mentioned method to get the Rowcount in Data Table:

In the Table Connector, drag and drop the LoadFromExcel method to the Design Surface.

Specify the "ExcelFileName" and the "Sheet Name" to load the data from.

Drag and Drop GetCount method to the design surface and connect to Message, box to display the Row Count Method.


We have attached an image of the automation for your reference.


To find out the count of files in a Directory, follow the steps mentioned below:

Go to Utilities, click on Directory, Select the Get Files Component.

Specify the "Folder Name"

Right click on Output Data Port, Click on Create Proxy, Double click on Create

Proxy method and select Count


We have attached an image of the automation for your reference


Feel free to revert for any further clarification.


Swathi Muppalla