Data Row from Data table Set to Clipboard

#1

I tried to fetch whole row from DataTable and set it to ClipBoard

#2

Hi @Sushant_Chanakhekar,

Why do you want to copy to clipboard?

Thanks,

#3

from clipboard I paste that row in excel

#4

hi @Sushant_Chanakhekar,

You can achieve this without clipboard as well read particular col and write in other excel file.

Thanks,

#5

Hi,
but I have to write perticular row in Excel i.e my data table contains only one row for perticular Transaction
Thanks…

#6

Hi @Sushant_Chanakhekar,

Can you please explain with example.

Thanks,

1 Like
#7

Hi,
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

Thanks

#8

Hi @Sushant_Chanakhekar

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…

#9

thanks

#10

Hi @Sushant_Chanakhekar

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 :slight_smile: