Sum of Rows

@Dev2, Hi please give more details, its hard to help someone without knowing exactly what their problem is. Provide as much information as possible, include screenshots and a scenario example if possible.

anyway, if you use read range activity to read data from excel then you can use a for each row to go through each row of the DataTable, you can then use an if to check if per each row if a cell under a certain column is not empty, eg:

Not String.IsNullOrWhiteSpace(row("ColumnName").ToString.Trim)
this is checking if a cell has data using the column name as a reference and the trim is just trimming the string removing any spaces in the beginning and end of a string.

Hope this gives you an idea on how you can solve your problem.

Goodluck.

1 Like