#coding=utf-8
importbase64importjsonimportxlsxwriterfrom xlsxwriter.workbook importWorkbookimportxlsxwriterimportsysimporttracebackfrom pandas importpandas as pdimportnumpy as npfrom utils importexcelUtildefexportTable(data):#加载JSON数据
patientList = json.loads(data)['patientList'];#创建excel文件,并且命名问patient.xlsx
fileName="patient.xlsx";#workbook=xlsxwriter.Workbook("./icuisapi-web/src/main/resources/pySource/patient.xlsx");
workbook =xlsxwriter.Workbook(fileName)#创建第一个sheet页码
workSheet = workbook.add_worksheet('患者信息一览表');#表头
headStr = ['ID', '入ICU时间', '出院时间', '转科时间', '诊断情况', '转归', '呼吸机使用', '高流量', 'PICCO', 'ECMO', 'CRRT'];#创建表头
workSheet.write_row(1, 0, headStr, excelUtil.header_style(workbook))#设置第一行表头
workSheet.write(0, 0, '患者信息一览表