参考自博客
// An highlighted block
import xlsxwriter as xw
import pandas as pd
import openpyxl as op
import numpy as np
orderIds = [1,2,3]
items = ['A','B','C']
mydata = [10,20,30]
testData = [orderIds,items,mydata]
filename = '测试.xlsx'
def pd_toexcel(data,filename): # pandas库储存数据到excel
dfData = { # 用字典设置DataFrame所需数据
'序号':data[0],
'项目':data[1],
'数据':data[2]
}
df = pd.DataFrame(dfData) # 创建DataFrame
print(df)
df.to_excel(filename,index=False) # 存表,去除原始索引列(0,1,2...)
pd_toexcel(testData,filename)