Python逐行写入excel

参考自博客

// 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)