Paste special value in excel using uipath

[jimmy_jos1 (Jimmy)]

Hi Team,

How to do paste special value in excel …I mean which activity do i select to paste the data ( Paste special value)

[AshwinS2 (Ashwin S)]

Hi @jimmy_jos1

Check this

Getting data from excel to paste in decisionbox

Hey i need to extract som data from a excel sheet, and place in the decision box. If the data is false, it should do nothing, but if the data i 3 or more it should take action. but i really can’t figure out what i need to type in the Condition box. What should the VB expresion be?

Thanks
Ashwin S

[Palaniyappan (Palaniyappan P)]

we can use WRITE CELL activity to enter a data to a cell in excel
or if we want to paste any thing in specific
–use start process and pass the file path as input and it will open the file in foreground
–set the value to clipboard using set to clipboard activity
–now use a send hot key and mention the hot key as ctrl+g and use type into activity to mention the place of cell where to go and click activity to click enter
–then again use send hot key activity and use key ctrl+v which will paste the clipboard value to the place where we are now

hope this would help you
Cheers @jimmy_jos1

[jimmy_jos1 (Jimmy)]

How to format the data copied from notepad to Excel…everything is coming on a single row i dont want that to happen…?

[Palaniyappan (Palaniyappan P)]

@jimmy_jos1

notepad to Excel

may i know how that data looks
–if its in a structured way we can use GENERATE DATATABLE ACTIVITY and pass that string as input and get the output with a variable as datatable which can be passed to excel with write range activity
Cheers @jimmy_jos1

[jimmy_jos1 (Jimmy)]

data looks like this

[jimmy_jos1 (Jimmy)]

No delimiter

[Palaniyappan (Palaniyappan P)]

then fine
we can use GENERATE DATATABLE ACTIVITY and mention the delimiter as tab
like this

Cheers @jimmy_jos1

[jimmy_jos1 (Jimmy)]

Not sure…

[jimmy_jos1 (Jimmy)]

@Palaniyappan

Can you show an example

[Palaniyappan (Palaniyappan P)]

hope this would help you

How to read tab delimited data file into data table?

its easy one what problem you are facing in this?

Cheers @jimmy_jos1

[Craig_Bannerman]

Hey dude!
So I just did this for my project as I didn’t want the html objects.

So basically for Excel instructions wise:
Ctrl V (to Paste)
Ctrl (just press control button to open up the Paste Special Options)
M (this selects the Match Destination Formatting)

Please note I then had to do a Send Hotkey just to hit Enter so the cells splits before saving or doing any other formatting.

I had to keep the “[d(ctrl)]v[u(ctrl)]” + “[d(ctrl)][u(ctrl)]” + “m” together as you want the data to stay selected until you’ve re-formatted it using the Special Paste.

Hope this helps,
Craig

[Nitesh (Nitesh Kumar)]

Hi @jimmy_jos1,

You can do paste special using the following send hotkeys activity:

1. Ctrl + C =>For the entire Column Data which you have to paste special.
2. Alt+Ctrl+v (Or Ctrl+Alt+v) => Using single hotkey activity.
3. Press “Down” (Twice) using single hotkey. (For Values)
4. Press “Enter”.

Hope it helps.
Cheers!
Nitesh