本文共 1611 字，大约阅读时间需要 5 分钟。

代码： 

import xlwtclass 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()

结果：

转载地址：http://owwsi.baihongyu.com/