如果EXCEL文件不存在
if not os.path.isfile(file):
testData.to_excel(file,sheet_name=sheetName,index=None)
如果文件已存在
else:
newData = pd.read_excel(file,sheet_name=None)
if sheetName in newData.keys():
testData.to_excel(file, sheet_name=sheetName,index=None)
else:
newData[sheetName] = testData
newFile = file
writer = pd.ExcelWriter(newFile)
for i in newData.keys():
newData[i].to_excel(writer,sheet_name=i,index=None)
# worksheet1 = writer.sheets[i]
writer.close()