Hello guys,
I just want to take the names which have a value, like (B, C, E, and G).
How should I do it?
2 Likes
Hi,
in Read range with in double quotes just give(“A3:A8”)
1 Like
We have read column activity @claudiojody
1 Like
Hi @claudiojody
Please check out this file, fill in the correct path for your excel
Main.xaml (4.9 KB)
Cheers
1 Like
Hi
Hope these steps could help you resolve this
— use excel application scope and pass the file path as input
— use read range activity and get the output with a variable of type datatable named outdt
— now use a for each row loop and pass the above variable outdt as input
— now use a if condition like this
Not String.IsNullOrEmpty(row(“Prob”).ToString)
If the above condition passes it will go to THEN part of if condition where we can get the Name like this in a write line activity
row(“Name”).ToString
Or if the condition fails it will go to ELSE part where we can leave it empty
Simple isn’t it
Hope this would like help you
Cheers @claudiojody
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.