Json(Excel)处理

import xlrd
import json
import xlwt

class GetJson(object):

    def __init__(self):
        self.workbook = xlwt.Workbook(encoding='utf-8')
        self.sheet = self.workbook.add_sheet('已完成')
        workfile = xlrd.open_workbook('filedeal.xlsx')
        table = workfile.sheets()[1]
        self.data_z = table.col_values(0)
        self.data_o = table.col_values(1)
        self.data_t = table.col_values(2)
        self.data_th = table.col_values(3)
        self.data_f = table.col_values(4)
        self.data_fi = table.col_values(5)
        self.data_s = table.col_values(6)
        self.data_se = table.col_values(7)
    def collectData(self):
        count = 0
        num = 0
        for data in self.data_f[1:]:
            num += 1
            print(data)
            data = json.loads(data)
            print(type(data))

            Main = data['Main']
            personalPaymentInfo = data['PersonalPaymentInfo']
            number = self.data_z[num]
            user = self.data_o[num]
            submitTime = self.data_t[num]
            title = self.data_th[num]
            checkTime = self.data_fi[num]
            node = self.data_s[num]
            checkUser = self.data_se[num]
            details = self.data['Details']
            item = [number,user,submitTime,title,checkTime,node,checkUser,details]
            for detail in details:
                count += 1
                for idx,ite in enumerate(item):
                    self.sheet.write(count, idx, ite)

                PaymentDeptNa