Iterate through all excel cells

Help
1

Hi guys!
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?
Thanks

2

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.

3

@vishal.kp, How to adress each cell then?
For each row in dt
if … <> 0
then
What should be instead “…”?

4

row(“the column name which you are checking for”).ToString.Contains(“0”)

you can use the above in the if condition

5

@vishal.kp
But I need to check cells in all columns. That’s the question.

6

For Example 1 have table 10x10. I need to check 100 cells…

7

you need to check all the 100 columns if it has 0?

8

I have 10 rows and 10 columns. So I need to check all cells in this range 10x10 dynamically. As an example.

1 Like
9

Fine
here you go with a sample xaml
hope this would help you
rowzcol.zip (15.7 KB)

Cheers @Slavich

1 Like
10

Beautiful decision, as always.
Thank you, @Palaniyappan

1 Like
11

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