Copy and Paste table from excel to notepad

excel

#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

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.


#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)