Copy Excel Sheet to Clipboard

[Aditya_Bhalerao]

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

[sarathi125 (Parthasarathi)]

@Aditya_Bhalerao,

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

[balupad14 (Balamurugan (BalaReva))]

Hi @Aditya_Bhalerao,

Here is an activity called “Copy to Clipboard”.

UiPath Go ! BalaReva EasyExcel Activities

Hi, I have developed the new activity in the package of BalaReva EasyExcel.Activities .It is called “Copy ToClipboard” .It copies the excel data to the clipboard. (The BalaReva.Excel.Activities have the same activity called “CopyData”) [image] Sample : ExcelCopyPaste.zip (26.4 KB) Thank you Balamurugan.S

This one for to paste the clipboard to excel.

UiPath Go ! BalaReva EasyExcel Activities

Hi, I have developed the new activity in the package of BalaReva EasyExcel Activities. It is called “Paste Clipboard” . It paste data from the clipboard . That means you can copy the data anywhere(SAP,text editors and etc…) [image] Thank you Balamurugan.S

Regards
Balamurugan.S

[Aditya_Bhalerao]

@sarathi125

why you want to copy the excel sheet content

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.

[sarathi125 (Parthasarathi)]

@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.

[Aditya_Bhalerao]

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

[sarathi125 (Parthasarathi)]

@Aditya_Bhalerao,

Is there any issue to use Write Range activity?

[ImPratham45 (Prathamesh Patil)]

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

[Aditya_Bhalerao]

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

[Palaniyappan (Palaniyappan P)]

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

[ImPratham45 (Prathamesh Patil)]

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

[Aditya_Bhalerao]

I want to copy the entire data from the Sheet .

[Navyavara (Navya Gangavaram)]

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.

[Palaniyappan (Palaniyappan P)]

@balupad14

Here is an activity called “Copy to Clipboard”.

UiPath Go ! BalaReva EasyExcel Activities UiPath Go!

Hi, I have developed the new activity in the package of BalaReva EasyExcel.Activities .It is called “Copy ToClipboard” .It copies the excel data to the clipboard. (The BalaReva.Excel.Activities have the same activity called “CopyData”) [image] I have attached the package in the thread begin. (It is a package before upload to UiPath Go). Thank you Balamurugan.S

This one for to paste the clipboard to excel.

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

[Aditya_Bhalerao]

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)

[balupad14 (Balamurugan (BalaReva))]

Hi @Aditya_Bhalerao,

You can specify the starting cell like “H1”.

Thank you
Balamurugan.S

[balupad14 (Balamurugan (BalaReva))]

@Aditya_Bhalerao

I want to copy the entire data from the Sheet .

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

BalaReva.Excel.Activities

Hi Friends, I have included the below new custom components in the package. 1.Create Workbook.(Create a new worksheet) 2.Copy to File (Copy the worksheet to another excel file). 3.Copy to WorkBook (Copy the worksheet inside the workbook). 4.HideUnhide the worksheet 5.Protect Unprotect the worksheet [image] Create WorkBook Properties [image] Sample : CreateWorkbook.zip (18.5 KB) Copy To File This activity copies the work sheet to an another excel file. If the another file is not ex…

Regards
Balamurugan.S

[Aditya_Bhalerao]

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

[balupad14 (Balamurugan (BalaReva))]

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 :

BalaReva.Excel.Activities

Hi Friends, I have included the below new custom components in the package. 1.Create Workbook.(Create a new worksheet) 2.Copy to File (Copy the worksheet to another excel file). 3.Copy to WorkBook (Copy the worksheet inside the workbook). 4.HideUnhide the worksheet 5.Protect Unprotect the worksheet [image] Create WorkBook Properties [image] Sample : CreateWorkbook.zip (18.5 KB) Copy To File This activity copies the work sheet to an another excel file. If the another file is not ex…

Regards
Balamurugan.S

[Aditya_Bhalerao]

@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.