wind拉取基金持仓数据导入excel

from WindPy import w
w.start()

data = w.wset("allfundhelddetail","rptdate={0};windcode={1}".format("20230630","000001.OF"))
import pandas as pd
Data = pd.DataFrame(columns=["基金名称"], data=data.Data[0])
Data["报告期"] = data.Data[1]
Data["持有个股代码"] = data.Data[2]
Data["持有个股名称"] = data.Data[3]
Data["持有个股市值"] = data.Data[4]
Data["持有个股占股票市值比"] = data.Data[5]

print(data)

Data

import os
Data.to_excel(os.path.join(r"D:\cfsworkfiles\myjupyternotebook\Mercury","Wind数据试验体.xlsx"))
print("公主请看数据")