安装xlsxwriter库
pip install xlsxwriter
#设置表格名称
workbook = xlsxwriter.Workbook('hello.xlsx')
#增加一个sheet
worksheet = workbook.add_worksheet()
# 设置表头
headings = ['Number', 'testA', 'testB']
#数据
data = [
['2017-9-1', '2017-90-2', '2017-9-3', '2017-9-4', '2017-9-5', '2017-9-6'],
[10, 40, 50, 20, 10, 50],
[30, 60, 70, 50, 40, 30]
]
#整行写入
worksheet.write_row('A1', headings)
#整列写入
worksheet.write_column('A2', data[0])
worksheet.write_column('B2', data[1])
worksheet.write_column('C2', data[2])
workbook.close()