planilha = openpyxl.load_workbook('convteste.xlsx')

sheet1= workbook['inconf']
sheet2_1 = workbook['sheet2']


maxr = sheet1.max_row
maxc = sheet1.max_column

for r in range(1,maxr +1):
    for c in range(1,maxc +1):
        sheet2_1.cell(row=r,column=c).value = sheet1.cell(row=r,column=c).value

        planilha.save('convteste.xlsx')