GunturGongura Posted January 16, 2016 Report Posted January 16, 2016 from openpyxl import load_workbook import xlsxwriter wb=xlsxwriter.Workbook('Project_Python.xlsx') wb=load_workbook('Project_Python.xlsx') sheet2=wb.get_sheet_by_name('Sheet2') sheet3=wb.create_sheet(title="modified data") sheet3=wb.add_sheet3() sheet1=wb.get_sheet_by_name('Sheet1') sheet3=wb.get_active_sheet() for i in range(3,6369): d1=(sheet1.cell(row=i,column=1).value) for j in range(3,6369): d2=(sheet2.cell(row=i,column=1).value) if d1==d2: s=(i,sheet1.cell(row=i,column=1).value,sheet2.cell(row=i,column=1).value,"same") else: t=(i,sheet1.cell(row=i,column=1).value,sheet2.cell(row=i,column=1).value,"modified") I want to display output s and t in new spreadsheet excel i.e sheet3 how to load output data to sheet3 ? (sorry for indentation errors, indentation errors lekunda post cheydaniki ratledu db lo)
GunturGongura Posted January 16, 2016 Author Report Posted January 16, 2016 Where did you write that code? its my own code i did code on sublime text 2 and executed on bash
Royalsimham Posted January 16, 2016 Report Posted January 16, 2016 its my own code i did code on sublime text 2 and executed on bash I have no idea still I will try to find solution
GunturGongura Posted January 17, 2016 Author Report Posted January 17, 2016 I have no idea still I will try to find solution thanks ipdu varku didn't get solution :(
andhrapradesh@123 Posted January 17, 2016 Report Posted January 17, 2016 thanks ipdu varku didn't get solution :( Stackexchange lo try chesava?
GunturGongura Posted January 17, 2016 Author Report Posted January 17, 2016 Stackexchange lo try chesava? First akda chese ikda vesa
Recommended Posts