Excel each row find this keyword

[CoolRobot]

Hi i am using studio to find on this excel a particular time

where my studio

i put a message box but is skipping it do you know why and how??

[prasath_S]

Hi @CoolRobot

Can you share the excel file please .

[Yoichi]

Hi,

Can you try the following condition?

EachRow(0).ToString.Contains("07:30")

Regards,

[CoolRobot]

Shift report1.xlsx (10.1 KB)
this is the excel file
i am trying with each row but condition is giving me a night

[CoolRobot]

tested is still given me night condition with else

[Yoichi]

Hi,

In my environment, the following works.

Main.xaml (5.9 KB)

Can you check there is ShiftReport1 atOutput-Datatable property in Read Range?

Regards,

[prasath_S]

Its running fine for me as well @CoolRobot in my environment

[CoolRobot]

Thanks yea i not sure why is not working just now

[CoolRobot]

thanks