How to copy the sheet data to clipboard dynamically

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

@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

Capture32
how to change that into string

@anjani_priya

Please create a new variable of type string

Cheers

Hi,

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

Regards,

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


empty

@anjani_priya

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

Cheers

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,

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.