求教python拆分后怎么添加一行标题栏

dcgg5201314 · 发表于 2022-10-10 13:48:48

def main():
sourceDf = pd.read_excel(r'C:\Users\Administrator\Desktop\pyton处理execl\666.xlsx',header=1)
colName = '销售机构'
outPath = r'C:\Users\Administrator\Desktop\pyton处理execl\test'
# 去重复并转换list格式
colNameList = sourceDf[colName].drop_duplicates().tolist()

for eachColName in colNameList:
sourceDf[sourceDf[colName] == eachColName].to_excel('/'.join([outPath, eachColName + '.xlsx']), index=False)
#print(sourceDf[sourceDf[colName] == eachColName])

if __name__ == '__main__':
main()
print('拆分结束')

求教拆分后怎么在每个拆分文件的最上面一行添加一个合并单元格的标题