How to check a full column of cell if there is content and for each the each row to another column

[Hayashi]

I want to try to check if example
Excel.Sheet(“Sheet1”).Cell(“D2”) to maybe Excel.Sheet(“Sheet1”).Cell(“D1000”) or end of the line
if there is discount written in it I want Excel.Sheet(“Sheet1”).Cell(“F2:F1000”) to say there is discount or Excel.Sheet(“Sheet1”).Cell(“G2:G1000”) There is no discount

how do I do that?

[vrdabberu (Varunraj Dabberu)]

Hi @Hayashi

Please check the below workflow

Don't forget to change the option in For Each Excel Row in properties panel from Stop to Process.

Xaml for your reference:
Main.xaml (19.1 KB)

You can use the below workflow if you want to handle with data table’s

Xaml for your reference:
Main.xaml (26.2 KB)

Regards

[rlgandu (Rajyalakshmi Gandu)]

@Hayashi

Not String.IsNullOrEmpty(CurrentRow("Discount").ToString)or Not String.IsNullOrWhiteSpace(CurrentRow("Discount").ToString) or CurrentRow("Discount").ToString.Contains ("Off")

Hope it works

[rlgandu (Rajyalakshmi Gandu)]

@Hayashi

If My Process works for you please mark it as Solution

Thank you

[Hayashi]

Thank you actually both method works.