{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","关键字说明"],"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":"Sheet1","index":0,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,4,0],[5,0,7,0],[8,0,9,0],[10,0,11,0],[1,1,4,1],[5,1,7,1],[8,1,9,1],[10,1,11,1],[1,2,4,2],[5,2,7,2],[8,2,11,2]]}
["编号","测试用例标题","用例等级","步骤","步骤描述","关键字","参数_1","参数_2","参数_3","参数_4"]
[1,"能够正确登录用例",null,1,"发送Post请求","request_post_form_urlencoded","http://shop-xo.hctestedu.com","{\n \"s\": \"/api/user/login\",\n \"application\": \"app\"\n}",null,"{\n \"accounts\": \"hami\",\n \"pwd\": \"123456\",\n \"type\": \"username\"\n}"]
[null,null,null,2,"通过JSONPATH提取数据-MSG","ex_jsonData","$..msg",0,"msg_success"]
[null,null,null,3,"通过JSONPATH提取数据-TOKEN","ex_jsonData","$..token",null,"token"]
[null,null,null,4,"断言-文本断言-等于","assert_text_comparators","{{msg_success}}","登录成功","=="]
[2,"能够登录失败用例",null,1,"发送Post请求","request_post_form_urlencoded","http://shop-xo.hctestedu.com","{\n \"s\": \"/api/user/login\",\n \"application\": \"app\"\n}",null,"{\n \"accounts\": \"hami2\",\n \"pwd\": \"123456\",\n \"type\": \"username\"\n}"]
[null,null,null,2,"通过JSONPATH提取数据-MSG2","ex_jsonData","$..msg",0,"msg_success"]
[null,null,null,3,"断言-文本断言-等于","assert_text_comparators","{{msg_success}}","登录帐号不存在","=="]
[3,"加入购物车功能",null,1,"发送Post请求","request_post_form_urlencoded","http://shop-xo.hctestedu.com","{\n \"s\": \"api/cart/save\",\n \"application\": \"app\",\n\"token\":\"{{token}}\"\n}",null,"{\n        \"goods_id\": \"2\",\n        \"spec\": [\n                {\n                        \"type\": \"套餐\",\n                        \"value\": \"套餐二\"\n                },\n                {\n                        \"type\": \"颜色\",\n                        \"value\": \"银色\"\n                },\n                {\n                        \"type\": \"容量\",\n                        \"value\": \"64G\"\n                }\n        ],\n        \"stock\": 2\n}"]
[null,null,null,2,"通过JSONPATH提取数据-MSG","ex_jsonData","$..msg",null,"msg_success"]
[4,"加入购物车功能-参数化",null,1,"发送Post请求","request_post_form_urlencoded","{{URL}}","{\n \"s\": \"api/cart/save\",\n \"application\": \"app\",\n\"token\":\"{{token}}\"\n}",null,"{\n        \"goods_id\": \"2\",\n        \"spec\": [\n                {\n                        \"type\": \"套餐\",\n                        \"value\": \"套餐二\"\n                },\n                {\n                        \"type\": \"颜色\",\n                        \"value\": \"银色\"\n                },\n                {\n                        \"type\": \"容量\",\n                        \"value\": \"64G\"\n                }\n        ],\n        \"stock\": 2\n}"]
[null,null,null,2,"通过JSONPATH提取数据-MSG","ex_jsonData","$..msg",null,"msg_success"]

{"sheet":"关键字说明","index":1,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
["关键字方法","参数 (没有就空着)"]
["request_post_form_urlencoded","URL","PARAMS","HEADERS","DATA"]
["request_post_row_json","URL","PARAMS","HEADERS","DATA"]
["request_post_form_data","URL","PARAMS","HEADERS","DATA","FILES"]
["request_get","URL","PARAMS","HEADERS"]
["ex_jsonData","EXVALUE","INDEX","VARNAME"]
["ex_reData","EXVALUE","INDEX","VARNAME"]
["ex_mysqlData","数据库","SQL","引用变量"]
["assert_text_comparators","VALUE","EXPECTED","OP_STR"]