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.