{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["TestStepExecution","data","CustomerData","ValueRanges"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"TestStepExecution","index":0,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Activity","LocatorType","Locator","Value","Comparison","Value2","Timeout","Optional","Release","Comment"]
["GOTOURL",null,null,"$(url1)"]
["click",null,"//span",{"$nulls":5},"5.0"]
["pause",null,null,1]
["click",null,"//*[@id='navbarDropdown']"]
["click",null,"//a[contains(., 'Action')]"]
["click",null,"//*[@id='navbarDropdown']"]
["click",null,"//a[contains(., 'Another action')]"]
["click",null,"//*[@id='navbarDropdown']"]
["click",null,"//a[contains(., 'Something else here')]"]
["click",null,"//a[contains(., 'Multiple Buttons')]"]
["click",null,"//*[@id='yesBtn']"]
["alertif"]
["switchWindow",null,0]
["click",null,"//*[@id='textarea']"]
["SETTEXT",null,"//*[@id='textarea']","$(textarea1)"]
["click",null,"//a[contains(., 'Back')]"]
["click",null,"//a[contains(., 'Input')]"]
["click",null,"//input[contains(@name,'input')]","$(InputText)"]
["SETTEXT",null,"//input[contains(@name,'input')]","$(InputText)"]
["click",null,"//a[contains(., 'Back')]"]
["click",null,"(//a[contains(text(),'Dropdown')])[2]"]
["click",null,"//select[@id='dropdown']"]
["click",null,"//option[@value='Strawberry']"]
["click",null,"//a[contains(., 'Back')]"]
["click",null,"//a[contains(., 'Form')]"]
["click",null,"//*[@id='firstName']"]
["SETTEXT",null,"//*[@id='firstName']","$(FAKER.name)"]
["SETTEXT",null,"//*[@id='lastName']","$(NameLast)"]
["clickif",null,"//select[@id='country']","$(Country)"]
["clickif",null,"//option[@value='$(Country)']","$(Country)"]
["click",null,"//textarea[@name='message']"]
["IBAN",null,null,"DE",null,"ibanGenerated"]
["SETTEXT",null,"//textarea[@name='message']","$(ibanGenerated)"]
["submit",null,"//input[@value='Send']"]
["saveto",null,"//div[contains(@id,'results')]","formResult"]
["assert",null,"//div[contains(@id,'results')]",null,"!=","None"]
["click",null,"//a[contains(., 'Back')]"]
["if",null,null,"$(doIframe)"]
["click",null,"//a[contains(.,'iFrame')]"]
["handleiframe","//div[@class='container mt-3']//div[1]//div[1]//div[1]//iframe[1]"]
["click",null,"//a[contains(., 'iFrame')]"]
["click",null,"(//button[@type='button'])[3]"]
["click",null,"(//button[@type='button'])[4]"]
["handleiframe","//div[@class='row mt-3']//div[2]//div[1]//div[1]//iframe[1]"]
["click",null,"(//a[contains(text(),'Card link')])[2]"]
["click",null,"//a[contains(., 'Examples')]"]
["click",null,"//a[contains(., 'Download source code')]"]
["click",null,"//a[contains(., 'Back')]"]
["handleiframe",null,0]
["endif"]
["goback"]

{"sheet":"data","index":1,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Stage","RemoteReadExample","textarea1","url1","InputText","Country","Message","doIframe","Password"]
["Test","RRD_[CustomerData,*,[Stage:[$(Stage)],Country:[$(Country)],IsActive:[X]]]","test area. Yeah!","https://webdemo.baangt.org/","this is an input","USA","Baangt is great!",null,123]
["Test","RRD_[CustomerData,*,[Stage:[$(Stage)],Country:[$(Country)],IsActive:[X]]]","Wonderful baangt!","https://webdemo.baangt.org/",null,"Canada","Baangt is fantastic!",null,1234]
["Test","RRD_[CustomerData,*,[Stage:[$(Stage)],Country:[$(Country)],IsActive:[X]]]","This is perfect!","https://webdemo.baangt.org/","Another input, how cool!","USA","Baangt is the real deal!",null,12345]
["PQA","RRD_[CustomerData,*,[Stage:[$(Stage)],Country:[$(Country)],IsActive:[X]]]","test area. Yeah!","https://webdemo.baangt.org/","this is an input","USA","Baangt is great!",null,123456]
["PQA","RRD_[CustomerData,*,[Stage:[$(Stage)],Country:[$(Country)],IsActive:[X]]]","Wonderful baangt!","https://webdemo.baangt.org/",null,"Canada","Baangt is fantastic!",null,12345]
["PQA","RRD_[CustomerData,*,[Stage:[$(Stage)],Country:[$(Country)],IsActive:[X]]]","This is perfect!","https://webdemo.baangt.org/","Another input, how cool!","USA","Baangt is the real deal!",null,1234]
["FQA","RRD_[CustomerData,*,[Stage:[$(Stage)],Country:[$(Country)],IsActive:[X]]]","test area. Yeah!","https://webdemo.baangt.org/","this is an input","USA","Baangt is great!",null,123]
["FQA","RRD_[CustomerData,*,[Stage:[$(Stage)],Country:[$(Country)],IsActive:[X]]]","Wonderful baangt!","https://webdemo.baangt.org/",null,"Canada","Baangt is fantastic!",null,12]
["FQA","RRD_[CustomerData,*,[Stage:[$(Stage)],Country:[$(Country)],IsActive:[X]]]","This is perfect!","https://webdemo.baangt.org/","Another input, how cool!","USA","Baangt is the real deal!",null,1]

{"sheet":"CustomerData","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Stage","Country","IsActive","NameFirst","NameLast","Password"]
["Test","Canada","X","Franzi","Meier",123]
["Test","USA",null,"Rudolf","Huber",1234]
["Test","USA","X","Nudl","Auk",12345]
["PQA","Canada","X","Franz","Fritz",123456]
["FQA","Canada","X","Fritz","Friedrich",12345]
["FQA","USA","X","Fettes","Brot",1234]
["PQA","USA","X","Nette","Susi",123]
["PQA","USA",null,"Böhzer","Onkel",12]
["Test","USA","X","Christian","Hochreiter",1]
["Test","USA","X","Hans","Albers",1]

{"sheet":"ValueRanges","index":3,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Activity","Explanation",null,"LocatorType",null,"Comparison",null,"Optional"]
["click","Click on an element specified by the locatorType and locator",null,"xpath",null,"=",null,"X"]
["clickIf","Same as click but only if condition applies",null,"css",null,">"]
["setText","Write text into an element specified by locatorType and locator",null,"id",null,"<"]
["setTextIf","Same as setText but only if condition applies",null,null,null,"!="]
["if","Execute the next lines only if condition applies",null,null,null,">="]
["else","Execute the next lines only if condition from IF-Statement does not apply",null,null,null,"<="]
["endif","End IF-Structure"]
["comment"]
["alertif","Confirm alerts, if any were raised"]
["assert","Check, if a condition evaluates to true"]
["submit","Execute the submit-Property of the page, Iframe or chosen element"]
["setAnchor","Set an XPATH-Locator as root node for all following elements. Or (if empty) unset the Anchor"]
["switchWindow","Switch to a certain window"]
["handleIFrame","Go into or out of Iframe"]
["pause","Pause execution for a number of seconds"]
["forceTextIf","Remove all contents from element, then write new content"]
["GoToURL","Go to a specific URL"]
["goBack","User Browser's Back-Button"]
["IBAN","Generate a valid IBAN"]
["saveto","Save the value of an element into a variable (for later use)"]
[]
[]
["zz_ClickIfClickable","Custom function to click only if element is clickable"]
["ZZ_savegfinfo","Custom function to save Geschäftsfall-info"]
["zz_spinner","Custom function to wait for spinner to disappear"]
["zz_toasts","Custom function to record and remove toast messages from NG"]