Python将一张表中多个sheet合并到一张表中的方法

代码如下：
import numpy as np
import xlrd
import datetime
import time
import numpy as np
import pandas as pd

fp=‘D:/乔/工作簿1.xlsx’#原表的存储路径
worksheet = xlrd.open_workbook(fp)
sheet_names= worksheet.sheet_names()

#存储锁号
lock_code=[]
customer_name=[]
customer_type=[]
branch=[]
call_person=[]
phone=[]
jihuo=[]
zhuangji=[]
apply=[]
suojiedianshu=[]
lock_type=[]
product_name=[]
gid=[]
GTJ=[]

for sh in range(3):
sheet = worksheet.sheet_by_name(sheet_names[sh])
rows = sheet.nrows # 获取行数

for i in range(1,rows) :
#cell = sheet.cell_value(i,0) # 注意0表示第1列数据，1表示第二列数据
    lock_code.append(sheet.cell_value(i,5))  #获取表中第一列数据
    customer_name.append(sheet.cell_value(i,0))
    customer_type.append(sheet.cell_value(i,1))
    branch.append(sheet.cell_value(i,2))
    call_person.append(sheet.cell_value(i,3))
    phone.append(sheet.cell_value(i,4))
    jihuo.append(sheet.cell_value(i,6))
    zhuangji.append(sheet.cell_value(i,7))
    apply.append(sheet.cell_value(i,8))
    suojiedianshu.append(sheet.cell_value(i,9))
    lock_type.append(sheet.cell_value(i,10))
    product_name.append(sheet.cell_value(i,11))
    gid.append(sheet.cell_value(i,12))
    GTJ.append(sheet.cell_value(i,13))

total={“客户名称”:customer_name,“客户类型”:customer_type,“分支”:branch, “联系人名称”:call_person,“联系人电话”:phone,“锁号”:lock_code,“是否激活”:jihuo,“是否装机”:zhuangji,“是否应用”:apply,“锁节点数”:suojiedianshu,“锁类型”:lock_type,“产品名称”:product_name,“gid”:gid,“土建设备号”:GTJ}
writer = pd.ExcelWriter(“新建.xlsx”)
data = pd.DataFrame(total)

写入Excel文件，路径可以任意指定

data.to_excel(writer, ‘page_1’, float_format=’%.5f’)

writer.save()
writer.close()