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


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.


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.