python3实现查询mysql生成excel并下载

#******************************接口调用部分*************************************
def post(self, *args):
  sql = "select * from yongyao_lv"
  head = ["ICD10","名称","年份","地区","产品名","新增人数","现有人数","增长率"]
  line = ["code_category","category_name","y","addr","n_item_name","num_yongyao","num_huanbin","yongyaobi"]
  output = export_excel(sql,head,line)
  nowtime = datetime.datetime.now().strftime('%Y%m%d%H%M%S')
  self.set_header("Content-Type", "application/octet-stream")
  self.set_header("Content-Disposition", "attachment; filename=yongyaolv_%s.xls" % nowtime)
  self.write(output.getvalue())

#**********************表格处理部分**************************


def export_excel(sql,head,line):
    list_obj = connect_date