Jump to content

Calling Excel Experts


Recommended Posts

Posted

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)
Posted

Where did you write that code?

 

its my  own code 

i did code on sublime text 2 and executed on bash

Posted

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
Posted

I have no idea still I will try to find solution

thanks ipdu varku didn't get solution :(

Posted

thanks ipdu varku didn't get solution :(

Stackexchange lo try chesava?

Posted

Stackexchange lo try chesava?


First akda chese ikda vesa
×
×
  • Create New...