How to copy the sheet data to clipboard dynamically

[anjani_priya]

how to copy the sheet data to clipboard dynamically.
how to take the data dynamically and copy to clipboard

[Anil_G (Anil Gorthi)]

@anjani_priya

Read the data to datatable…use read range without giving range…it wpuld read all the data

Use output datatable and convert to string…

Assign the string to clipboard using set to clipboard activity

Cheers

[anjani_priya]

how to change that into string

[Anil_G (Anil Gorthi)]

@anjani_priya

Please create a new variable of type string

Cheers

[Yoichi]

Hi,

What are you planning to use what copy to clipboard? I think the best approach depends on the purpose.

Regards,

[anjani_priya]

to paste the data in sap
but it should take the data dynamically

[anjani_priya]

empty

[Anil_G (Anil Gorthi)]

@anjani_priya

Did you happen to assign datatable in read range…is the datatable empty can you check

Cheers

[Yoichi]

HI,

I think it may be better to create tab separate string.

Can you try the following sample?

strDt = String.Join(vbCrLf,dt.AsEnumerable.Select(Function(r) String.Join(chr(9),r.ItemArray)))

Sample
Sample20231124-9L.zip (8.3 KB)

Regards,