本文主要是介绍python 的openpyxl对两个表的横向,竖向合并,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
列合并,即横向合并
from openpyxl import Workbook,load_workbook
wb=Workbook()
wb=load_workbook("excel.xlsx")
wslist=wb.worksheets
ws1=wslist[0]
ws2=wslist[1]
ws3=wslist[2]
Columns=ws1.columns
data1 = ws1["A1":"C3"]
data2 = ws2["A1":"C3"]
for i in range(len(data1)):for j in range(len(data1[i])):ws3.cell(i+1, j+1, data1[i][j].value)n = len(data1[0])
for i in range(len(data2)):for j in range(len(data2[i])):ws3.cell(i+1, j+n+1, data2[i][j].value)
wb.save("excel3.xlsx")
行合并,即放在下面的那种
from openpyxl import Workbook,load_workbook
wb=Workbook()
# wb.save("excel.xlsx")
wb=load_workbook("excel.xlsx")
# print(wb.sheetnames)
# ws=wb.active
# ws=wb.sheetnames
wslist=wb.worksheets
ws1=wslist[0]
ws2=wslist[1]
ws3=wslist[2]
# ws3.cell(1,1,21)
#wb.save("excel1.xlsx")
rows=ws1.rows
# #print(rows)
# for row in rows:
# for cell in row:
# print(cell.value)
'''合并表格'''
data1=ws1["A1:C3"]
data2=ws2["A1:C3"]
data=data1+data2
print(data)
for i in range(len(data)):for j in range(len(data[i])):print(data[i][j].value)ws3.cell(i+1,j+1,data[i][j].value)
wb.save("excel2.xlsx")
这篇关于python 的openpyxl对两个表的横向,竖向合并的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!