Copy and Paste table from excel to notepad

Help
1

Hi Everyone,

I want to copy the whole structure from excel to notepad. I have created a datatable and converted that into a string and write it to the text file but I don’t want that output, as it shows comma if I am copy the table structure. Instead I want the (tab - space). So I want to do Ctrl+A, Ctrl+C and Ctrl+V into the text file from Excel. Please anyone help me out.

Regards,
Hemal

2 Likes
2

image
please try this send hotkey activity- hope useful my inputs

3

@rkelchuri yes you are correct. I have tried using hotkey only. But I am trying to open the notepad through Open Application activity and sending hotkey ‘Ctrl+V’ though it is not working . Can you please help me to show the step by step as how to do Ctrl+V in notepad.

4

Hi hemal,
Refer this code. if u want inside the CITRIX then the solution is different.
test.zip (9.5 KB)

5

Hello @debasisa, I am getting an error like, ‘Activity could not be loaded because of errors in the XAML.’

6

You have to go to Package manager and install the UiPath.Database.Activities package.

Screenshot_32
Screenshot_321137×587 51.6 KB

7

The solution is still not clear. Let’s say i have an excel output.xlsx (8.5 KB)
and as it is to a word doc/notepad, can you please suggest how to do it?

Thanks heaps.

8

Hi,

PFA Solution, I have done very basic programming, I will optimize the solution by using either DB or Datatable and share with you

test.zip (9.3 KB)

9

Revised Solution, Use ExcelToNotepadUsingDT workflow

test.zip (11.4 KB)

2 Likes
10

Hi @hemal ,

  1. To copy data from excel to clipboard you use “Copy Data” activity in the below .
    UiPathGo - BalaReva Excel Activities

2.Open the Notepad and use the Ctrl+V in the sendhot key activity.

Regards
Balamurugan.S