How do I know if my excel table has more than one row

Hi everyone
I have an excel table with a number of rows
I want to check if this table has 1 row or more?

1 Like

Assumed Excel is Readin into a Datatable
Yourdatatablevar. Rows.count can be used for getting the row Count

From balareva.excel components you also will find some helpfully activities aß an alternate approach

2 Likes

Read the excel using excel app scope. inside it , take the read range activity whose output is datatable. use datatable.rows.count > 0 . if true means it is having more than 1 row.

3 Likes

thank u very much guys
it was very helpful

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.