Hello guys,
I have to cross check with excel file if the value is match it will click on generate mail
As I shown in below image
Above image is and desktop application from this table I have check clomun name is (B_Nseqty)
Take first value and cross check with the Excel.file.which shown in below image
Column name is NSE once it’s it will be highlight that value
Thanks
One thing you can do is use ui explorer and indicate the value you need to get…mostle you would get tablecol and tablerow …if not use idx…and in loop increment and get each value
In same loop use a filter datatable and check if value is present in excel data…if yes then click on generate usinng tablerow or idx …if not continue the loop
Cheers
I have to click on generate mail but in column (Lock status) if there is. Pending then I have to click on generate mail
Please elaborate 2 point
By changing tablecol value you can access each column ideally
Now on point 2
Read the data from excel and keep in datatable dt
Use get text and get the B_nseqty column value for each row by changing idx or table roe…
Once the value is there…use filter datatable and filter the column in dt and then take a filtereddt.Rowcount>0 and if yes there is a match if no there is no match
Similarly use different get text to check pending and all
Cheers