Copy Excel Sheet to Clipboard

Hey Everyone, I am facing difficulty in copying content from an Excel Sheet and pasting it in Clipboard. I have tried Set to Clipboard and Get from Clipboard but it didnt help.
Kindly suggest me a way out of it.

@Palaniyappan @joepaw @ImPratham45

2 Likes

@Aditya_Bhalerao,

May I know the reason why you want to copy the excel sheet content to the clipboard?

Hi @Aditya_Bhalerao,

Here is an activity called “Copy to Clipboard”.

This one for to paste the clipboard to excel.

Regards
Balamurugan.S

1 Like

The sheet I want to copy contains filtered data from another sheet in the same file.
This filtered data I want to paste in an vendor portal.

@Aditya_Bhalerao,

Instead of filtering the data in the excel sheet itself you can do it using UiPath datatable filtering activity, then do with the filtered data.

I am filtering the data using Uipath itself.
Now I need to copy this data from sheet to Clipboard.

@Aditya_Bhalerao,

Is there any issue to use Write Range activity?

Why u are coping that data
You can directly paste data to any sheet using Write Range

I want to paste the Data to another application and not another sheet

Hi
Would you like to paste the entire data from that sheet or one by one along a specific column
Cheers @Aditya_Bhalerao

If you want without lines separator
Then by using output datatable you convert it into Text and then set it to Clipboard.
If you want as it is from excel then
After filter use write range then by using VBA (Macro) select the entire data and copy it

I want to copy the entire data from the Sheet .

Hi,

Try to send Hotkeys in excel applicatipon scope activity.
First you can select entire sheet by passing ctrl+a.
Again passing ctrl+c to copy the entire sheet.
Next you can use get from clipboard activity to get the data.

Then this method would work
Did we try with this buddy @Aditya_Bhalerao

2 Likes

I am trying for the same.

But I am unable to define the Range for the below mentioned data in excel sheet (Say Sheet 3).
It doesnt have any headers. Also this workflow operates within an Excel Application Scope. Also a FOR each row operates for another Sheet (Say Sheet 1)

1 Like

Hi @Aditya_Bhalerao,

You can specify the starting cell like “H1”.

Thank you
Balamurugan.S

Hi ,
Y don’t you use the Copy to File(to copy sheet) that exists in the below link .

Regards
Balamurugan.S

@balupad14 I want to copy the entire sheet .
How do I define the range for all the contents of the sheet.

1 Like

Hi @Aditya_Bhalerao,

  • To copy the sheet within excel file use Copy to WorkBook .
  • To copy the sheet to another file use Copy to File.

This is package link with example :

Regards
Balamurugan.S

1 Like

@balupad14 I want to copy the excel sheet to Clipboard.
As i want to paste the data to another Application and not another excel sheet.

1 Like