Copy Excel 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

Hi @Aditya_Bhalerao,

In this case you have to use the Copy ToClipboard. Download load the latest package in below link and configure it . It has the feature that the cell range is “”(blank) , It will take the used range.(I have uploaded it in the UiPath Go. Waiting for the publish.)

Thank you
Balamurugan.S

1 Like

@balupad14
I am trying the same thing but in vain.
Can you please make a little workflow showcasing how to copy the excel sheet to clipboard and pasting it to Notepad.

It will be really helpful.

1 Like

I did this, but shows error (Object reference not set to an instance of an object).

1 Like

Hi @Aditya_Bhalerao,

In the below thread I have attached a copy paste sample for you.

Regards
Balamurugan.S

1 Like

Thanks you @balupad14 and @Palaniyappan.

Cheers !!!

2 Likes

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