How to count number of filled cells in specific row?

How to I count the number of filled cells in a specific row? can be 01 or 02 or 22 - this depends on the variable.


You can do using datatable, using read range you can get the datatable

and also using filter datatable you can put a condition that column = null

then you can check the count

Hope this helps


if row(0).ToString.Equals("")
in else part
nonEmptyRows = row(0).ToString
and print nonEmptyRows