Copy range from excel to clipboard retain format

Help
1

I can try set to clipboard activity to copy the column values of excel to clipboard and paste in SAP.
what i tried is

  1. Read Excel in Datatable using Read Range.
    2.how to change variable dataable to string???
  2. Set this value to clipboard and paste it .

i also tried “Copy selected text” but when i paste it miss the format and color

i just want to realize select range of data and ctrl+c in excel then ctrl+v in google spreadsheet

2

I doubt whether it is possible without opening excel…

3

Hi @Gunisoo
you can change a dataTable to string using the “output data table” activity.

5

HI @reda it doesnt work:sob: it doesnt contain the cell color.
i just want select range and ctrl＋ｃand ctrl+v in google spreadsheet.

6

You can directly use excel shortcuts to copy and paste the content.
Just that you need to use the shortcuts in a way that fits your sheet. I can help with some shortcuts if you need.
Are you trying to copy the entire sheet’s content from excel?

7

Hi @Gunisoo
Ive looked into the same issue. This is my solution and works:

Create a Macro in Excel:

Sub CopySelection()
Range("A1:C20").Copy
End Sub

In Uipath inside an excel scope, add an execute macro with the name: CopySelection
Its now set to your clipboard.

Make sure the Excel Scope have auto save and create new file unchecked.
This also works in the background (invisible)

If you get an error when saving the macro, make sure the Excel file is Macro valid. So .Xlsm extension.

Bumped this post because didn’t find a good solution to this problem.

1 Like
8

Hi @Gunisoo,

You can either use excel shortcuts or it will better to try "Long Path Tool " Software.

9

@MickeyFireMouse I tried Invoke VBA activity but, unable to get anything into clipboard

10

Hi, the macro i posted above should be created inside EXCEL. So not as a included code in uipath.

11

The main problem is copied range scope is untill macro run. Outside the macro clipboard is empty