How to read certain column with excel

Hello guys,
NANYAFORUM%204
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”)
:slight_smile:

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.