37,722
社区成员
发帖
与我相关
我的任务
分享
writer = pd.ExcelWriter('/home/lei/Downloads/泥石流视频/IntegrateData/ROC.xlsx')
for video_Path in glob.glob(os.path.join(video_Dir, '*')):
data = pd.DataFrame(c)
sheetName = 'video_{}'.format(filename)
data.to_excel(writer, sheetName, float_format='%.5f')
writer.save()
writer.close()
需要注意的是要在循环外面进行writer的操作,循环内只能写入,这样就不会覆盖了writer.sheets = dict((ws.title, ws) for ws in book.worksheets)
import pandas
from openpyxl import load_workbook
df = pandas.read_excel('test.xlsx')
print df
book = load_workbook('test2.xlsx')
writer = pandas.ExcelWriter('test2.xlsx', engine='openpyxl')
writer.book = book
writer.sheets = dict((ws.title, ws) for ws in book.worksheets)
df.to_excel(writer, "Main",index=0,startrow=0,startcol=0)
writer.save()