写入EXCEL文件
from openpyxl import Workbook
a = "aaaaaaaa"
b = "bbbbbbbb"
c = "cccccccc"
d = "dddddddd"
e = "eeeeeeee"
f = "ffffffff"
wb = Workbook()
ws = wb.active
tableTitle = [a, b,c,]
for col in range(len(tableTitle)):
c = col + 1
ws.cell(row=1, column=c).value = tableTitle[col]
# 数据表基本信息
tableValues = [[d, e, f,]]
for row in range(len(tableValues)):
ws.append(tableValues[row])
# wb.save(ExcelFullName)
wb.save("d:\\1.xlsx")