Can anyone help for how to retrieve text from cell depend on its previous cell text
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.
—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