#遍歷每個場景下API
for TestReporTGGet in range(0, TestReporTgCount001):
    TestReporTGName = TestReporTG[TestReporTGGet]
    # print(TestReporTGName,"類型是：",type(TestReporTGName))
    # 特殊符號過濾
    TestReporTGNameFiltration = re.sub('['!"#$%&\'()*+,./:;<=>?@，。?★、…【】《》？“”‘'！[\\]^_`{|}~\s]+', "",
                                       TestReporTGName)
    # 特殊\斜桿過濾
    TestReporTGNameFiltration01 = re.sub(r'\\', "", TestReporTGNameFiltration)
    # 獲取響應(yīng)體url
    ResponseUrl = "http://ms.***.*****:****/api/scenario/report/selectReportContent/" + TestReporTGNameFiltration01
    print("場景下節(jié)點(diǎn)地址："+ResponseUrl)
    ResponseUrlResp = requests.get(url=ResponseUrl, headers=TestReportHeaders)
    ResponseUrlResp.encoding = "utf-8"
    #print(ResponseUrlResp.text)
    ResponseUrlRespGet = ResponseUrlResp.text
    # 獲取每個流程節(jié)點(diǎn)名字，進(jìn)行過濾
    TestResponseResp = re.findall('","name":"(.+?)",', ResponseUrlRespGet)
    TestResponseRespGet=str(TestResponseResp)
    TestResponseRespGetFiltration=re.sub('[a-zA-Z0-9'!"#$%&\'()*+,-./:;<=>?@，。?★、…【】《》？“”‘'！[\\]^_`{|}~\s]+', "", TestResponseRespGet)
    print("根節(jié)點(diǎn)處理報告名稱:" + TestResponseRespGetFiltration)
    #獲取根節(jié)點(diǎn)成功或失敗
    RootNodeSucceed=re.findall('"pass":(.+?)}]}}}',ResponseUrlRespGet)
    RootNodeSucceedGet=str(RootNodeSucceed)
    print("根節(jié)點(diǎn)失敗或成功狀態(tài)標(biāo)識："+RootNodeSucceedGet)
    #定義局部變量，狀態(tài)轉(zhuǎn)譯使用
    #if
    #獲取根節(jié)點(diǎn)返參數(shù)據(jù)
    #ReturnParameter=re.findall('"vars":"(.+?)}]}}}',ResponseUrlRespGet)
    #ReturnParameter=re.findall('"data":(.+?)}}}',ResponseUrlRespGet)
    #ReturnParameterGet=str(ReturnParameter)
    # 獲取根節(jié)點(diǎn)返參數(shù)據(jù)
    ReturnParameter=re.findall('"body":"{(.+?)]}}}',ResponseUrlRespGet)
    ReturnParameterGet=str(ReturnParameter)
    ReturnParameterGettest=re.sub(r'\\', "", ReturnParameterGet)
    print("過濾后的報文字段"+ReturnParameterGettest)
    #print("長度：" + len(ReturnParameterGet))
    Namenge_list = list(ReturnParameterGet)
    #print("長度：" + len(Namenge_list))
    is_contain_ch29 = '"error":0' in ResponseUrlRespGet
    # 獲取根節(jié)點(diǎn)狀態(tài)碼
    # RootState=re.findall('"responseCode":"(.+?)","',ResponseUrlRespGet)
    # RootStateGet=str(RootState)
    # print("根節(jié)點(diǎn)狀態(tài)碼；"+RootStateGet)
    #獲取投保單號
    InsureGain=re.findall('proposalNo：(.+?)nqueryCode',ResponseUrlRespGet)
    InsureGainGet=str(InsureGain)
    InsureGainGetDispose=re.sub('['!"#$%&\'()*+,-./:;<=>?@，。?★、…【】《》？“”‘'！[\\]^_`{|}~\s]+', "",InsureGainGet)
    InsureGainGetDispose01=re.sub(r'\\', "",InsureGainGetDispose)
    print("投保單號:",InsureGainGetDispose01)
    #獲取報價單號
    PriceSheet=re.findall('quotationNo：(.+?)nquotationNo1：',ResponseUrlRespGet)
    PriceSheetGet=str(PriceSheet)
    PriceSheetGetDispose=re.sub('['!"#$%&\'()*+,-./:;<=>?@，。?★、…【】《》？“”‘'！[\\]^_`{|}~\s]+', "",PriceSheetGet)
    PriceSheetGetDispose01=re.sub(r'\\', "",PriceSheetGetDispose)
    print("報價單號：",PriceSheetGetDispose01)
    #獲取orderMessageList
    orderMessageList=re.findall('"assertions":(.+?)"pass":true',ResponseUrlRespGet)
    orderMessageListGet=str(orderMessageList)
    print("獲取orderMessageList：",orderMessageListGet)
    print("===============================================================================")
    #print("根節(jié)點(diǎn)返參："+ReturnParameterGet)
    print("是否為：",is_contain_ch29)
    print("根節(jié)點(diǎn)的接口:"+ReportParticularsUrl)
    print("===============================================================================")

# 讀取原表格
workbook = xlrd.open_workbook("autoinsurancereport.xls")
# 獲取原表格第一個sheet的名字(我這里只有1個sheet)
all_sheet = workbook.sheet_names()
first_sheet = workbook.sheet_by_name(all_sheet[0])
# 獲取原表格第一個sheet寫入數(shù)據(jù)的行數(shù)
rows = first_sheet.nrows
# 拷貝新的excel,并從rows行開始追加寫入
new_workbook = copy(workbook)
new_sheet = new_workbook.get_sheet(0)
# 創(chuàng)建標(biāo)題
new_sheet.write(0, 0, "場景")  # 場景
new_sheet.write(0, 1, "報告名稱")  # 報告名稱
new_sheet.write(0, 2, "接口")  # 接口
new_sheet.write(0, 3, "返回狀態(tài)碼")  # 返回狀態(tài)碼
new_sheet.write(0, 4, "投保單號")  # 投保單號
new_sheet.write(0, 5, "報價單號")  # 報價單號
new_sheet.write(0, 6, "狀態(tài)")  # 報價單號
new_sheet.write(0, 7, "orderMessageList")  # 報價單號
new_sheet.write(0, 8, "路徑")  # 路徑
new_sheet.write(0, 9, "文檔記錄時間")  # 報價單號
# （行，列，值）
new_sheet.write(rows, 0, GetSceneNameGain)  # 場景
new_sheet.write(rows, 1, TestResponseRespGetFiltration)  # 報告名稱
new_sheet.write(rows, 2, ReportParticularsUrl)  # 接口
new_sheet.write(rows, 3, GetStateGain)  # 返回狀態(tài)碼
new_sheet.write(rows, 4, InsureGainGetDispose01)  # 投保單號
new_sheet.write(rows, 5, PriceSheetGetDispose01)  # 報價單號
if is_contain_ch29 == True:
    new_sheet.write(rows, 6, "成功")  # 狀態(tài)
    new_sheet.write(rows, 8, "　　")  # 返回報文
else:
    print("ReturnParameterGettest長度為:",len(ReturnParameterGettest))
    if len(ReturnParameterGettest)<=32000:
        new_sheet.write(rows, 8, ReturnParameterGettest)  # 返回報文
    else:
        new_sheet.write(rows, 8, "執(zhí)行失敗，報文較長，文檔無法進(jìn)行存儲")  # 返回報文
    new_sheet.write(rows, 6, "失敗或未執(zhí)行")  # 狀態(tài)
new_sheet.write(rows, 7, orderMessageListGet)  # orderMessageList
new_sheet.write(rows, 9, str(current_time))  # 當(dāng)前系統(tǒng)時間
new_workbook.save("autoinsurancereport.xls")