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

Hi @jimmy_jos1 Check this [image] Getting data from excel to paste in decisionbox Help 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…

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 mentio…

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

[image] 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

@Palaniyappan Can you show an example

hope this would help you [image] How to read tab delimited data file into data table? Help its easy one what problem you are facing in this? Cheers @jimmy_jos1

Paste special value in excel using uipath

Help

Palaniyappan (Palaniyappan P ) August 22, 2019, 12:54pm 8

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

Cheers @jimmy_jos1

Topic		Replies	Views
Getting data from excel to paste in decisionbox Help	5	2789	July 22, 2017
Unable to paste text in excel Studio	10	2402	July 31, 2020
I have copied to clipboard and I want to paste that directly into excel Help	13	9632	November 23, 2019
Copy and Paste table from excel to notepad Help excel	9	8329	November 23, 2019
Copying data from Excel to Notepad Activities excel , question	16	9346	August 31, 2021

Paste special value in excel using uipath

Related topics