python处理excel

from tkinter import *
from tkinter.filedialog import askopenfilename
from tkinter.messagebox import showinfo
import tkinter as tk
import xlrd
import xlwt

frameT = Tk()
frameT.geometry(‘500x500+400+200’)
frameT.title(‘输入文件’)
frame = Frame(frameT)
frame.pack(padx=10,pady=10)
frame_1 = Frame(frameT)
frame_1.pack(padx=10,pady=10)
v1 = StringVar()

def fileopen():
file = askopenfilename()
if file:
v1.set(file)

def show():
print(v1.get())
data = xlrd.open_workbook(v1.get())
table = data.sheets()[0]
nrows = table.nrows
print(nrows)
workbook = xlwt.Workbook(encoding=‘utf-8’)
worksheet = workbook.add_sheet(‘mysheet’)

for i in range(0,nrows):
a = table.cell_value(i,4)
print(i,table.cell(i,4).ctype)
print(a)
for j in range(0,nrows):
b = table.cell_value(j,7)
if a == b:
print(a)
c = table.cell_value(i,3)
workbook=xlwt.Workbook(encoding=‘utf-8’)
sheet=workbook.add_sheet(“yx”)
worksheet.write(j,0,c)
worksheet.write(j,1,table.cell_value(i,3)*2)

   if table.cell_value(i,4) == 'null':
       print(i)
      worksheet.write(i,2,81-i)

workbook.save(‘713.xls’)
for j in range(0,nrows):
b = table.cell_value(i,7)
if a ==b:
print(a)

def run():
data = xlrd.open_workbook(‘v1.get()’)
print(data)
pass

ent = tk.Entry(frame,width=50,textvariable=v1).pack(fill=X,side=LEFT)
#print(ent.get())

btu = Button(frame,width=20,text=‘总文件’,font=(‘宋体’,14),command=fileopen).pack(fil=X,padx=10)
btu1 = Button(frame_1,width=20,text=‘运行’,font=(‘宋体’,14),command=show).pack(fil=X,padx=10)

frameT.mainloop()