Count rows on studiox

[jhj3627 (HJ)]

Hi.
How can I count data table rows on studioX?

[flavius (Flavius Manea)]

It would be great if you could provide more details about your scenario, but here are some options:

1. Use Excel to operate on your tabular data, with the Count() function in this case
2. Use the AdvancedEditor option, if your scenario is more advanced, and access members programmatically:
   

[unknownay]

Hi @jhj3627

The .net method for retrieving the number of rows in a datatable is

datatable.Rows.Count.ToString

You can use a message box activity or writeline activity to see the value.

Please mark as solution if found useful

[jhj3627 (HJ)]

Hi guys.
Thank you for your posts. It’s so usable.
But I wanted writing the datatable on project notebook and get the number of rows.
Because it’s more difficult to write datatable on excel after parameterizing than directly write datatable on excel. (I’m using extracting table data)