Excel Automation - How to copy a data row to clipboard?

datatable
excel
uiautomation
studio

#1

Hello,

I am trying to copy the full row one by one and paste it in window based citrix application. I have used for each to read each row from the datatable but how do I copy the whole row (ex: row1 with all column values–>paste it in citrix—>row2 with all column values–>paste it in citrix etc) one by one while in the for each loop?

Get row item can extract only specific columns but I want the complete row

Can you please help me with this?

Thanks
Selva


Start Process - Open Excel - Issue while opening
#2

I didnt get to see any straight forward way to do this, other that iterating through the cells and appending the content with separator. Attaching a workflow just to give you an idea. I am not sure if this is the best way to do it.

Content of DataRow.xaml (12.6 KB)


#3

Thanks for the response @kaderms