import pandas as pd
from xlrd import open_workbook
if __name__ == '__main__':
table = open_workbook("文件名称.xlsx" ) #打开文件
data = pd.read_excel("文件名称.xlsx" , sheet_name = 任意一个sheetname) # 为了获取数据的结构
get_sheets = table.sheet_names() #获取excel的sheet页的名称,全部打印出来
print(get_sheets)
dataAll = pd.DataFrame(columns = data.columns.tolist())
total = 0
for sheetname in get_sheets:
data = pd.read_excel("名称.xlsx" , sheet_name = sheetname)
dataAll = dataAll.append(data.drop(index =0))
print(sheetname)
# 修改这3列编码的字段类型,避免科学计数法
dataAll[['A','B','C']] = dataAll[['A','B','C']].astype(str)
dataAll.to_excel('融合后的结果数据.xlsx')