Hi Team,

How to copy the data table as it is in excel sheet?
Any idea on this?



hi @Girish

Have you tried Read Range activity ,where you can copy the worksheet data into data table variable ,where you can also include the headers of worksheet in data table by selecting the Add Headers Option in properties pane.

Hope this helps.


Hi Ranjith,

I am working in citrix. Please help me how can do it?



How about you write DT to local file.

Ctrl A

Ctrl C

Open Excel in Citrix

Ctrl V

Ctrl S


Hi Vinay,

Yes you are right but problem is table is having merged cells if I use above it will copy entire table in improper format.