python读取excel多个sheet页并合并成一页
import xlrd
import xlwt
data = xlrd.open_workbook("database.xlsx")
workbook = xlwt.Workbook()
worksheet = workbook.add_sheet('sheets2one')
'''sheet页'''
page0 = len(data.sheets())
print(f'该表格文件有 {page0} 页')
aim_hang = 0
for ye in range(page0):
table0 = data.sheets()[ye]
nrow0 = table0.nrows
nclow0 = table0.ncols
print(nclow0)
print(nrow0)
for hang in range(nrow0):
for lie in range(nclow0):
aim_data = int(table0.cell_value(hang, lie))
worksheet.write(aim_hang , lie , str(aim_data))
print(aim_data)
aim_hang = aim_hang + 1
aim_hang = aim_hang + 2
workbook.save('Excel_test.xls')