Forum Discussion

MarkSchofer's avatar
MarkSchofer
Frequent Contributor
4 years ago
Solved

Detailed Question About Formatting

I have a python Script that reads from a spreadsheet

Long Story Short

It Reads Payee, PayDate and Payment Amount

def LookForCash():
# Checking the 'Cash Recipt Links' activity
# Log.Message("Drill Down","",pmNormal, attr)
browser = Aliases.browser
page = browser.Page("*")
PropArray = ["ObjectType","ObjectLabel"]
ValuesArray = ["Link","$4,077.94"]; -Hard Coded right now (and it works) I will be passing a variable within a loop
#browser = Aliases.browser
#page = browser.Page("*")
page.FindChild(PropArray, ValuesArray,10).click()
currentPage = browser.Page("*")
currentPage.Wait()
Log.Message(currentPage)

I formatted the spreadsheet and look like the Object Label and of course it only takes the unformatted value.   

IDEALLY IF I COULD extract the formatted value I would be pretty much done

Can I AQstring the ValuesArray here? Is there a better way?