python文件处理-将多个dataframe数据写入EXCEL不同的sheet页

如果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()