I tried to fetch whole row from DataTable and set it to ClipBoard
Why do you want to copy to clipboard?
from clipboard I paste that row in excel
You can achieve this without clipboard as well read particular col and write in other excel file.
but I have to write perticular row in Excel i.e my data table contains only one row for perticular Transaction
Can you please explain with example.
In My Process I read data from Queue and put it into DataTable And Then I Have to Fetch That Queue Data From DataTable And Paste into Excel
You can get the record from the queue using Get Transaction Data activity. This will get assigned to a queueitem variable. And then you can however get it assigned to a data table. I believe this part is already done?
Once in the datatable, you can write the data to your excel file using Write Range activity. It is much easier than using clipboard activities…
Let know whether this helps…
Did any of our answers worked for you? If so, please mark the appropriate answer as the solution so that it could help others as well