python写入多个sheet_PythonPyExcelate库在同一工作簿中写入多个工作表？

如果您想更快地将不同变量保存在同一个excel文件的不同工作表中，同时还希望熊猫.dataframe在excel文件中。你可以做如下事情import timeit

from pyexcelerate import Workbook

def to_Excel(data, fileName):

start_time = timeit.default_timer()

wb = Workbook()

for key in data.keys():

ws = wb.new_sheet(key)

frame = data[key]

frame = frame.transpose()

frame.reset_index(level=0, inplace = True)

frame = frame.transpose()

frame.reset_index(level=0, inplace = True)

row_num = frame.shape[0]

col_num = 1

for col_name, col_series in frame.iteritems():

ws.range((1,col_num), (row_num,col_num)).value = [[x] for x in col_series]

col_num += 1

wb.save(fileName)

end_time = timeit.default_timer()

delta = round(end_time-start_time,2)

print("Took "+str(delta)+" secs")

“data”是字典变量。“data”的“key”用作“sheet name”，每个key值的数据类型应在pandas dataframe中。在