循环excel表

for i in range(sheet.nrows):
    row_value = sheet.row_values(i)
    target_list.append(row_value)

target_newList = []
for item in target_list:
    if not isinstance(item[0],float):
        for zb in item[0].split(";"):
            res = [zb,item[1],item[2],item[3],item[4]]   #内部小循环的结果和外部大循环进行组配，写入到excel中
            target_newList.append(res)
df = pd.DataFrame(target_newList)  #将res转换成DataFrame，然后存入到excel中
df.to_excel("xxx.xlsx")