Past Text to Word from Stored Echo value from Excel

Hi UI Vision people,

I’m trying to paste values from an excel spreadsheet into a desktop application. For now, I’m using Word to try it out. My table view and code are below.

I’m just unable to write the “stored” text which is showing up in the variables tab.

Any help is appreciated.

Thanks!

Brian


Here is my Table View

Here is my code:
{
“Name”: “Get Strategy Values & Open Word”,
“CreationDate”: “2020-6-2”,
“Commands”: [
{
“Command”: “store”,
“Target”: “medium”,
“Value”: “!replayspeed”
},
{
“Command”: “csvReadArray”,
“Target”: “fund analysis - long optimization test plan.csv”,
“Value”: “myCSV”
},
{
“Command”: “echo”,
“Target”: “E0,2={myCSV[5][9]}", "Value": "Condition" }, { "Command": "echo", "Target": "E0,2={myCSV[5][10]}”,
“Value”: “Entry”
},
{
“Command”: “echo”,
“Target”: “E0,2={myCSV[5][11]}", "Value": "Long Win" }, { "Command": "echo", "Target": "E0,2={myCSV[5][12]}”,
“Value”: “Long Loss”
},
{
“Command”: “XRunAndWait”,
“Target”: “C:\Users\Brian\Desktop\Strategy Template.docx”,
“Value”: “”
},
{
“Command”: “XClick”,
“Target”: “2,18”,
“Value”: “#doubleclick
},
{
“Command”: “XType”,
“Target”: “Condition”,
“Value”: “E0,2=${myCSV[5][9]}”
}
]
}

Try ti yse csvread is more simple to use

https://ui.vision/rpa/docs/selenium-ide/csvread

With csvread it’s a easy work to do this.

I think in your code there are a large amount of errors.

Thank you so much. The gathering of the information is accomplished, however I need to paste the values to the word doc, which I’m unable to do - how do I paste after copied?

To do this work you need to use desktop automation, this is not web automation.

I suggest you to copy in clipboard and after paste the content from clipboard.

A problem can be the focus on the word document, this is the hard part, having a focus because this is not a web pagem this is desktop automation.

You must study this

https://ui.vision/rpa/x/desktop-automation

Be carefull when you use command, read command syntax here

https://ui.vision/rpa/docs

Thank you very much newuserkantu, I’ll give it a go.