我试图从excel文件中读取合并了单元格范围的数据。。。但产出不是我的目标。请帮帮我
import openpyxl
wb = openpyxl.load_workbook('book1.xlsx')
sheet = wb.get_sheet_by_name('info')
all_data=[]
print(sheet.merged_cells.ranges)
for row_index in range(1,sheet.max_row+1):
row=[]
for col_index in range(1,sheet.max_column+1):
vals = sheet.cell(row_index,col_index).value
if vals =='':
for crange in sheet.merged_cells.ranges:
rlo,rhi,clo,chi = crange
if rlo<=row_index and row_index<rhi and clo<=col_index and col_index<chi:
vals = sheet.cell(rlo,clo).value
print(vals)
break
row.append(vals)
all_data.append(row)
print(all_data)
for row in all_data:
sheet.append(row)
wb.save('bbbb.xlsx')
我希望得到输出: [['06B','Daewoo BC 212',80,1373],['06C',大宇BC 212',80,1020],“06D”,“Transinco B60KL”,60,1061],“06D”,“Transinco B60KL”,60,19],“06E”,“大宇BC 212”,80,1020],“06E”,“大宇BC 212”,60,1061],“06E”,“大宇BC 212”,60,19]],但结果是:
[['06B','大宇BC 212',80,1373],['06C',大宇BC 212',80,1020],'06D',Transinco B60KL',60,1061],[无,无,60,19],“06E”,“大宇BC 212”,80,1020],[无,无,60,1061],[无,无,60,19]]
给你:
=^….^=
输入:
^{pr2}$输出:
我修改了我的守则,这是工作。在
相关问题 更多 >
编程相关推荐