{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["TestStepExecution","data","CustomerData","LoopDataExampleTab","NestedLoops"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Activity","LocatorType","Locator","Value","Comparison","Value2","Timeout","Optional","Release"]
["GOTOURL","xpath",null,"$(url1)"]
["click","xpath","//a[contains(., 'Form')]"]
["SETTEXT","xpath","/html/body/div[1]/div[2]/div[1]/div/div/form/div[7]/textarea","$(random{\"type\":\"name\"})"]
["pause",null,null,2]
["SETTEXT","xpath","/html/body/div[1]/div[2]/div[1]/div/div/form/div[7]/textarea","$(random{\"type\":\"string\", \"min\":10, \"max\":100})"]
["pause",null,null,2]
["SETTEXT","xpath","/html/body/div[1]/div[2]/div[1]/div/div/form/div[7]/textarea","$(random{\"type\":\"int\", \"min\":10, \"max\":100})"]
["pause",null,null,2]
["SETTEXT","xpath","/html/body/div[1]/div[2]/div[1]/div/div/form/div[7]/textarea","$(random{\"type\":\"float\"})"]
["pause",null,null,2]
["SETTEXT","xpath","/html/body/div[1]/div[2]/div[1]/div/div/form/div[7]/textarea","$(random{\"type\":\"date\", \"min\":\"20/1/2020\", \"max\":\"30/6/2020\", \"format\":\"%d/%m/%Y\"})"]
["pause",null,null,2]
["SETTEXT","xpath","/html/body/div[1]/div[2]/div[1]/div/div/form/div[7]/textarea","$(random{\"type\":\"time\"})"]
["pause",null,null,2]
["SETTEXT","xpath","/html/body/div[1]/div[2]/div[1]/div/div/form/div[7]/textarea","$(random{\"type\":\"time\", \"min\":\"10.30.00\", \"max\":\"15.00.00\", \"format\": \"%H.%M.%S\"}"]
["pause",null,null,5]
["goback"]

{"sheet":"data","index":1,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["TCLine","Stage","RemoteReadExample","textarea1","textarea2","url1","InputText","Country","Message","doIframe"]
[0,"Test","RRD_[CustomerData,*,[Stage:[$(Stage)],Country:[$(Country)],IsActive:[X]]]","test area. Yeah!","RLP_(LoopDataExampleTab,line_reference=0)","https://webdemo.baangt.org/","this is an input","USA","Baangt is great!"]
[1,"Test","RRD_[CustomerData,*,[Stage:[$(Stage)],Country:[$(Country)],IsActive:[X]]]","Wonderful baangt!","RLP_(LoopDataExampleTab,line_reference=1)","https://webdemo.baangt.org/",null,"Canada","Baangt is fantastic!"]
[2,"Test","RRD_[CustomerData,*,[Stage:[$(Stage)],Country:[$(Country)],IsActive:[X]]]","This is perfect!",null,"https://webdemo.baangt.org/","Another input, how cool!","USA","Baangt is the real deal!"]
[3,"PQA","RRD_[CustomerData,*,[Stage:[$(Stage)],Country:[$(Country)],IsActive:[X]]]","test area. Yeah!",null,"https://webdemo.baangt.org/","this is an input","USA","Baangt is great!"]
[4,"PQA","RRD_[CustomerData,*,[Stage:[$(Stage)],Country:[$(Country)],IsActive:[X]]]","Wonderful baangt!",null,"https://webdemo.baangt.org/",null,"Canada","Baangt is fantastic!"]
[5,"PQA","RRD_[CustomerData,*,[Stage:[$(Stage)],Country:[$(Country)],IsActive:[X]]]","This is perfect!",null,"https://webdemo.baangt.org/","Another input, how cool!","USA","Baangt is the real deal!"]
[6,"FQA","RRD_[CustomerData,*,[Stage:[$(Stage)],Country:[$(Country)],IsActive:[X]]]","test area. Yeah!",null,"https://webdemo.baangt.org/","this is an input","USA","Baangt is great!"]
[7,"FQA","RRD_[CustomerData,*,[Stage:[$(Stage)],Country:[$(Country)],IsActive:[X]]]","Wonderful baangt!",null,"https://webdemo.baangt.org/",null,"Canada","Baangt is fantastic!"]
[8,"FQA","RRD_[CustomerData,*,[Stage:[$(Stage)],Country:[$(Country)],IsActive:[X]]]","This is perfect!","RLP_(LoopDataExampleTab,line_reference=0)","https://webdemo.baangt.org/","Another input, how cool!","USA","Baangt is the real deal!"]

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

{"sheet":"LoopDataExampleTab","index":3,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["line_reference","input_text","input_date","nested"]
[0,"Franzi","2020-06-18","RLP_(NestedLoops,line_reference=1)"]
[0,"Fritzi","2020-07-01","RLP_(NestedLoops,line_reference=1)"]
[1,"franzi","1972-02-14","RLP_(NestedLoops,line_reference=3)"]
[1,"fritzi","1972-02-15","RLP_(NestedLoops,line_reference=4)"]

{"sheet":"NestedLoops","index":4,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["line_reference","input_text"]
[1,"Test_1"]
[1,"Test_2"]
[3,"Test_3"]
[4,"Test_4"]