contact  |  about  |  sitemap

Imported Excel File, run script, If condition
Last Post 07 Mar 2010 05:09 PM by Tijn. 1 Replies.
Sort:
PrevPrev NextNext
Author Messages
Lee Kim

--
05 Mar 2010 05:15 PM
i imported an Excel file that contains 5 columns, the first columns has x on certain rows, in column 5 their is a url.

i want to run a function that says, if column a has "x" then open url in column 5.

not sure how to reference cells within data grid to accomplish this with an imported excel file. see attached script.

thank you!

001_Indeed_Test.djs

Tijn

--
07 Mar 2010 05:09 PM
You typically use the loop grid rows action.
In the loop you use a get cell action to get the cell content of column 5.
Next you test if it's a url and open it with a get web page action.

See the attached updated script.
Tijn

Indeed_Test_updated.djs



Quick Reply
toggle
  Username:
Subject:
Body:
Security Code:
Enter the code shown above:

Submit

Powered by Active Forums

Forum participation and optional registration

You don't need to be registered to partcipate in the Djuggler forums, however if you want to subscribe to email notifications you need to register. You can also subscribe to the forum RSS feed.