#-*- coding:utf-8 -*-
import pandas as pd
from collections import OrderedDict
#传入一个二维列表
def save_excel(excel_name,header,data):
obj = pd.DataFrame(data)
obj.to_excel(excel_writer=excel_name,index=True,header=header)
print('保存成功')
excel_name="test.xls"
data=[[1,1,1],[2,2,2]]
header=["a","b","c"]
save_excel(excel_name,header,data)
pandas存储数据到excel
最新推荐文章于 2024-03-14 10:32:32 发布