Excel转成REC的格式文件

import os
import pandas as pd
import numpy as np
import re


os.chdir(os.getcwd())

path = r"D:\Example\untitled\excel生成REC通用\\工作簿1"
file = "最美四季"

data = pd.read_excel(r"{0}\{1}.xlsx".format(path,file),
                     sheet_name = "Sheet1",
                     na_values ="",
                     skiprows=[])
data = data.fillna("")
rec = ""

titles = list(data.columns)

for index in data.index:
    
    items = list(data.loc[index].values)
    print(items)
    if(len(items) != len(titles)):
        print("Error Line",items)
        continue

    rec += "<REC>\n"
    for i,d in enumerate(items):

        rec += "<{0}>={1}\n".format(titles[i],d)

fout = open(r"{0}\{1}.txt".format(path,file),'w',encoding='gb18030')

fout.write(rec)

fout.close()