python 将API获取到的数据写入exel

import os
import urllib.request, urllib.parse, urllib.error, sys
from urllib import request, parse
import json
import configparser
import xlwt
import time

def write_to_exel(self):
        self.params['action'] = 'search'
        binary_data = urllib.parse.urlencode(self.params).encode('ascii')
        req = request.Request(url=self.url, headers=self.headers, data=binary_data, method='POST')
        response = request.urlopen(req)
        raw = 1
        exel_table = xlwt.Workbook(encoding='utf-8')
        table = exel_table.add_sheet('a.xls', cell_overwrite_ok=True)
# 表格行标题
        table.write(0, 0, "ID")
        table.write(0, 1, "")
        table.write(0, 2, "")
        table.write(0, 3, "")
        table.write(0, 4, "")
        table.write(0, 5, "")
        table.write(0, 6, "")
        table.write(0, 7, "")
        table.write(0, 8, "")
        table.write(0, 9, "")
        table.write(0, 10, "")

        config = configparser.ConfigParser()
        config.read('exclude_libraries.ini', encoding='utf-8')
        exclude_libraries_list = config['Exclude_Libraries'].get('exclude_libraries').split()

        for rep in response:
            break_flag = False
            record = json.loads(rep.decode())
            library = record['file'].rsplit('/')[12]
            for exclude_library in exclude_libraries_list:
                if library == exclude_library or record['file'].rsplit('/')[12] == '' or \
                        record['file'].rsplit('/')[12] == '' or \
                        record['file'].rsplit('/')[12] == '' or \
                        record['file'].rsplit('/')[12] == '':
                    break_flag = True
                    break
            if break_flag == True:
                continue
            else:
                table.write(raw, 0, str(record['']))
                table.write(raw, 1, record[''])
                table.write(raw, 2, record[''])
                dir = '/'.join(record[''].rsplit('/')[10:12])
                component = record[''].rsplit('/')[12]
                script = record[''].rsplit('/')[13:]
                table.write(raw, 3, dir)
                table.write(raw, 4, )
                table.write(raw, 5, "/".join())
                table.write(raw, 6, record[''])
                date = record['']
                
                table.write(raw, 7, time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(date / 1000)))
                table.write(raw, 8, record[''])
                table.write(raw, 9, record[''])
                table.write(raw, 10, record[''])
            raw = raw + 1
            print(raw)
        exel_table.save('a.xls')
        print("Save issues to .xls successful")