How to capture Text from notepad and copy to Excel

Help
1

Hi all,

Can any one guide me with samples or example to copy data from note pad and paste to excel ?

Your help is much appreciated. thanks in advance.

Regards,
Ram

2

Hi @ram_ch,

you can do it in 2 different way

  1. Open the notepad file using send hot key ctrl+A and ctrl+ c, then open the excel file using excel application scope and paste it save the file.
  2. use read text file activity get the data from the notepad and use build data table to format the data then use write range activity to write the data in the excel sheet

Regards,
Arivu :slight_smile:

3

Thanks Arivu,

Do you have any example file? thanks for your help

4

refer this…
notepad to excel.zip (11.0 KB)

1 Like
5

Hi, The t1 datatable that is created is not called anywhere. I tried using your example into my project. Please see and suggest if i have done something wrong. DuplicateRemoval.zip (1.6 MB)

6

Can you please let me know what is the output you want to achieve from the above DuplicateRemoval workflow.
Do you want to copy the text from .txt file (from line 22) to excel (dummy.xlsx)?

7

Hi,
Actually i wanted to copy the text from the Notepadd++ to the excel directly, however, i was not able to achieve it. So i thought it would be easier to first copy it to the notepad and then copy it to the excel.

Thanks,
Nanda

1 Like
8

Make use of Macros. it’s much simpler. You can execute the Macros in UiPath.
UiAutomation approach is More Prone to Errors.