how to display huge data in new excel sheet using python -


from openpyxl import load_workbook       wb=load_workbook('project_python.xlsx')     sheet2=wb.get_sheet_by_name('sheet2')     sheet3=wb.get_sheet_by_name('sheet3')       sheet1=wb.get_sheet_by_name('sheet1')     sheet3=wb.get_active_sheet()       in range(3,6369):         d1=(sheet1.cell(row=i,column=1).value)         j in range(3,6369):             d2=(sheet2.cell(row=i,column=1).value)         if d1==d2:             print(i,sheet1.cell(row=i,column=1).value,"same")         else:             print(i,sheet2.cell(row=i,column=1).value,"modified") 

i comparing 2 excel sheets i.e sheet1 , sheet2 , want display last 2 outputs in sheet3 on same workbook. how can that?

to write in cell:

sheet3.cell(column=1, row=1, value="something") 

put want .


Comments

Popular posts from this blog

c++ - llvm function pass ReplaceInstWithInst malloc -

Cross-Compiling Linux Kernel for Raspberry Pi - ${CCPREFIX}gcc -v does not work -

java.lang.NoClassDefFoundError When Creating New Android Project -