I have a huge table. I need to run all cells and check if they are not equal 0.
How can I iterate through all cells?
if its in excel read using read range and convert to data table. Or if you already have a data table you can use for each row to iterate through each row of the data table.
@vishal.kp, How to adress each cell then?
For each row in dt
if … <> 0
What should be instead “…”?
row(“the column name which you are checking for”).ToString.Contains(“0”)
you can use the above in the if condition
But I need to check cells in all columns. That’s the question.
For Example 1 have table 10x10. I need to check 100 cells…
you need to check all the 100 columns if it has 0?
I have 10 rows and 10 columns. So I need to check all cells in this range 10x10 dynamically. As an example.
Beautiful decision, as always.
Thank you, @Palaniyappan
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.