python查询数据库后生成excel

代码： 

import xlwt


class Mysql:
    def __init__(self):
        self.content = pymysql.Connect(
            host='localhost',
            port=3306,
            user='root',
            passwd='1234',
            db='fincerobotmanager',
            charset='utf8',
        )
        self.cursor = self.content.cursor()

    def query(self):
        # 创建确认申报汇总表工作簿
        wb = xlwt.Workbook(encoding='utf-8')
        # 创建表
        ws = wb.add_sheet('确认申报汇总表')
        # 行数
        row_num = 0
        font_style = xlwt.XFStyle()
        # 二进制
        font_style.font.bold = True
        # 表头内容
        columns = ['单位名称', '纳税人识别号', '个税申报密码', '申报结果', '错误原因', '是否确认申报']
        # 写进表头内容
        for col_num in range(len(columns)):
            ws.write(row_num, col_num, columns[col_num], font_style)

        font_style = xlwt.XFStyle()  # 将列名加粗后重新设置

        sql = 'select corp_name,taxpayer_num,pwd,job_result,why_error from job_list inner join corps_info on corp_base_id = corps_info.id and job_list.job_no = "71b2cf6e"'
        self.cursor.execute(sql)

        for row in self.cursor.fetchall():
            # print(row)
            # print(f"一共查找到：{self.cursor.rowcount}")
            row = ['' if i == 'nan' else i for i in row]  # 如果某项为nan则设置为空

            row_num += 1
            # 逐行写入Excel
            for col_num in range(len(row)):
                ws.write(row_num, col_num, row[col_num], font_style)

        wb.save(r'F:/确认申报汇总表.xls')

        # for row in self.cursor.fetchall():
        #     print(row)


    def end(self):
        self.cursor.close()
        self.content.close()


if __name__ == '__main__':
    m = Mysql()
    m.query()
    m.end()

结果：