Paste data in Excel From Clipboard

Help
, , ,
1

I’m trying to paste data into Excel from the clipboard and then save the excel. I tried using hotkeys but they aren’t reliable sometimes they work and sometimes they won’t.
I have tried updating the selectors using attach to live screen option. But the problem still remains, I’m not able to get 100% reliable results.
Is there is another way to paste the data into excel? How can I make my Hotkeys more reliable?
Here is my Xml file.

outlook to excel Main.xaml (34.8 KB)

Thank you

1 Like
2

Hi @RishiVC1,
In case you want to write your data to excel file, directly you have activities:

  1. Write Range
    https://www.uipath.com/activities-guide/excel.write-range
  2. Write Cell
    https://www.uipath.com/activities-guide/workbook.write-cell

Still if you want to automate your excel file inside Citrix (You can’t use the Excel Application Scope) in that case, you can use Ctrl+G and enter your cell address then navigate to the required cell.

Note: In case of using hotkeys to save, you can use click image and click on the save icon. It is more reliable in this saving case.

Regards,
Jiban

3

Thank you for the quick reply @jibanjyoti. Write cell and Write Range activity aren’t of much use to me, as my tabular data is coming from outlook. The solution attached to the question is based on the solution provided on this link:

Can I use write range in this case? Please have a look at the XML too if you haven’t already.

I have tried click activity too in the past I faced the same issue. I haven’t tried click on image option though.

4

@RishiVC1 , did you find a solution? I am facing some issue

5

Hi, I managed to get the Values by string manipulation.

6

Hi @RishiVC1 thanks for quick reply…
even when will copy data from html file and paste it in excel, we should use string manipulation?
is there any alternative way??

7

Approach 1
If after reading the mail body your values are coming along with HTML then it would be difficult to do the string manipulation (But not impossible, if you can do that then please go ahead, it will work all the time. you need to find the patterns of HTML code that you will encounter again and again and manipulate them to get the values in the required format)

Approach 2

  1. You can filter for the required mail messages and then you can save the required mail message using save email message activity.
  2. Once saved you can read the list of each saved message and then one by one using outlook you can open them. Refer open applications with arguments of your choice
  3. and copy paste the data into the Excel using Hotkey (make sure you are using the correct paste option that retains the formatting).
  4. Once the data is saved in excel you can read the data in the dataTable.
  5. The Data table may contain unwanted data which can we cleaned or removed using string manipulation and Datatable operations.
1 Like
8

Hi @RishiVC1,

Here is an activity called “PasteClipboard”. it pastes the data inside excel sheet.

Regards
Balamurugan.S