Cell Value Validation

Help
, ,
1

Can anyone help for how to retrieve text from cell depend on its previous cell text

2

Hi @Arun_Pondhe - All those Cell range are static or dynamic? If it is static then try to use Read Cell activity if you want to retrieve the text.

Regards,
AK

3

Fine
—use excel application scope and pass the file path as input
—inside the scope is read range and get the output with a variable of type datatable named dt
—now use a for each row loop and pass the above variable as input
—inside the loop use IF condition like this
dt.Rows.Indexof(row) > 0 AND row(“yourcolumnname”).ToString.Contains(“your keyword”)

If this is true it will go to THEN part where we can use a writeline activity to get the previous cell value
dt.Rows(dt.Rows.Indexof(row)-1)(“yourcolumnname”).ToString

Cheers @Arun_Pondhe