使用tkinter做了一个查找两个excel某列相同数据
对比完当前目录会生成一个txt文件,输出所有相同数据
import xlrd
from tkinter import *
import tkinter.filedialog
from tkinter import ttk
class ExcelCmpApp(object):
def __init__(self):
self.m_Root = None
self.m_OriExc = None
self.m_TarExc = None
self.m_TextList = []
self.m_TextDict = {
}
self.m_OriNumberList = []
self.m_TarNumberList = []
self.InitLayer()
def InitLayer(self):
self.m_Root = Tk()
root = self.m_Root
path = StringVar()
sheet_name = StringVar()
column_name = StringVar()
taget_sheet_name = StringVar()
taget_column_name = StringVar()
taget_path = StringVar()
self.m_TextList.append(path)
self.m_TextList.append(sheet_name)
self.m_TextList.append(column_name)
self.m_TextList.append(taget_sheet_name)
self.m_TextList.append(taget_column_name)
self.m_TextList.append(taget_path)
self.m_TextDict["orisheet"] = sheet_name
self.m_TextDict["oricol"] = column_name
self.m_TextDict["tarsheet"] = taget_sheet_name
self.m_TextDict[