中文字幕理论片,69视频免费在线观看,亚洲成人app,国产1级毛片,刘涛最大尺度戏视频,欧美亚洲美女视频,2021韩国美女仙女屋vip视频

# -*- coding: utf-8 -*-
"""
Created on Mon Jan 20 13:02:27 2020

@author: twx253
"""

import xlrd
import pandas as pd
from  pandas import DataFrame
from openpyxl import load_workbook

excel_name = 'C:/Users/twx253/Desktop/many_sheets.xlsx'  
wb = xlrd.open_workbook(excel_name)
sheets = wb.sheet_names() # 獲取workbook中所有的表格
# 循環(huán)遍歷所有sheet
alldata = DataFrame()
for i in range(len(sheets)):
    df = pd.read_excel(excel_name, sheet_name=i, index=False, encoding='utf8')
    print(df.shape)
    alldata = alldata.append(df)
    
#指定合并后的數(shù)據(jù)放在哪個excel里
writer = pd.ExcelWriter('C:/Users/twx253/Desktop/many_sheets.xlsx',engine='openpyxl') 
book = load_workbook(writer.path)
writer.book = book

#指定合并后的數(shù)據(jù)放在哪個sheet里
alldata.to_excel(excel_writer=writer,sheet_name="ALLDATA",index=False)
writer.save()
writer.close()
print('處理完成！')

# =============================================================================
# 現(xiàn)在需要將dataframe1,dataframe2和dataframe3中的數(shù)據(jù)存放到result.xlsx中的三個不同的sheet中,
# sheet的名字分別為dataframe1,dataframe2,datafame3.
# =============================================================================
writer = pd.ExcelWriter('result.xlsx')
for i in ['dataframe1','dataframe2','dataframe3']:
       eval(i).to_excel(excel_writer=writer,sheet_name=i,index=False)
writer.save()
writer.close()