Citrix automation - For each to paste data from Excel to citrix application

excel
uiautomation
activities
studio

#1

Hi,

I have an excel sheet filled with data and a window based citrix app. I would like to read each row from Excel and paste it in Citrix application. I can identify the row/record to place in citrix by using CTRL+F(find). Only if I find a matching record in Citrix application, I have to paste the record else not paste it and keep a track of how many records I pasted and how many aren’t pasted. I need your help with copying a whole row from excel(one by one) and paste in citrix app. I already tried using for each to read each row but how do I copy the whole row so that I can set it to clipboard and once match is found, I can paste it.

Can’t paste the screenshot or xaml file as it is confidential

Thanks
Selva


#2

You can concatenate Whole row in one variable by putting one while loop inside For Each Row. Refer to attached image.


image