Copying entire Column from Datatable

datatable
studio

#1

Hi Folks,

I need to copy the entire column from datatable and need to copy the sam in the SAP, Could anyone please let me know the solution?


#2

@badita Please let me know the solution for this


#3

Hi Pavan,

As per my knowledge, I don’t think so we have option to copy the entire column and paste the same into SAP.

  1. You can iterate through & use Type Into activity
  2. You can use Clipboard activity

#4

Do you need something like this?


#5

Hi manoj,

           Right now i did iteration and copied, but i want to know do we have any option of copying the entire column. BTW Thanks for ur reply

#6

Hi Vaidya,

          Thanks for ur reply but the thing is i need to copy into table in SAP. So I Think this doesnt works in my scenario.

#7

Ok. You can try this as a last resort if you don’t find other solution. Hope it helps.

string.Join(Environment.NewLine,dt.AsEnumerable().[Select](Function(s) s.Field(Of String)(**COLNAME**)).ToArray())

Ctrl+V or any other method you can do in SAP.


#8

Hi Vaidya,

can you send me the xaml file. As I tried it but I am getting compilation errors.


#9

@vvaidya thak you for the solution its working


#10

hI @vvaidya

It seems I have the same question. Can you sent me the xaml file too or post it on the website?thx!


#11

I think this should have the logic you asked for.


#12

Thank you!:grin:


#13

@vvaidya thank you!:grin: