I am facing an error.i have automated one data entry work on my our application.my condition is if the excel row value is “STOP” it should close all my opened application should be closed.if any other text are there it should proceed the data entry work.
i used if condition but when the row reached the value “STOP” that text also entering on that field pls support
Use if condition like row.Item(“name”).ToString.ToUpper.Contains(“STOP”) close all applications in else u can run ur data entry
Hi @gowthamr could you show the condition and variables on which this
IF is set?
is this right but i am getting an error
replace the cinema with column in like row.item(“column name”)
cinema is your variable then use like Cinema.ToString.ToUpper.Contains(“STOP”)
OK Its not working. i explain here what i want to do
Excel sheet has 12 colums and rows count is variable sometimes it wil 10 sometimes and sometimes 340 rows.here if there is no data in a row .it should close my application windows (nearly 3 windows supposed to close can you give some idea.
1.use read range activity to read the excel store it in data table
2.then use for each row to get the each row from data table
3.in for each row body use get row item get the cell value
4.use above if condition after getting all data using get row item
5. after for each row use close application activity to close the application
thank you shyamm i wil check and update