137 lines
5.3 KiB
Python
137 lines
5.3 KiB
Python
# -*- coding:utf-8 -*-
|
|
################################
|
|
# excel 表格对比
|
|
#
|
|
################################
|
|
import os
|
|
import tkinter as tk
|
|
from tkinter import ttk
|
|
from tkinter import filedialog, dialog
|
|
|
|
|
|
class CompareData:
|
|
pass
|
|
|
|
|
|
class CompareFormat:
|
|
pass
|
|
|
|
|
|
class MainView:
|
|
def __init__(self, root: tk.Frame):
|
|
self.__root: tk.Frame = root
|
|
|
|
self.__select_template_file_mess: tk.StringVar = tk.StringVar()
|
|
self.__select_template_file_mess.set('请选择模版文件')
|
|
self.__template_file_name: tk.StringVar = tk.StringVar()
|
|
self.__template_file_name.set('')
|
|
|
|
self.__select_compare_file_mess: tk.StringVar = tk.StringVar()
|
|
self.__select_compare_file_mess.set('请选择对比文件')
|
|
self.__compare_file_name: tk.StringVar = tk.StringVar()
|
|
self.__compare_file_name.set('')
|
|
|
|
self.__conf_type: tk.IntVar = tk.IntVar() # 配置方式
|
|
|
|
self.__progress: tk.IntVar = tk.IntVar()
|
|
self.__progress.set(20)
|
|
|
|
def create_windows(self):
|
|
template_f = tk.Frame(self.__root, bg='gainsboro')
|
|
template_f.rowconfigure(0, weight=1)
|
|
template_f.columnconfigure(0, weight=1)
|
|
template_f.grid(row=0, column=0, padx=5, pady=5, sticky=tk.NW)
|
|
|
|
compare_f = tk.Frame(self.__root, bg='gainsboro')
|
|
compare_f.rowconfigure(0, weight=1)
|
|
compare_f.columnconfigure(0, weight=1)
|
|
compare_f.grid(row=1, column=0, padx=5, pady=5, sticky=tk.NW)
|
|
|
|
compare_type_f = tk.Frame(self.__root, bd=1, height=50)
|
|
compare_type_f.grid(row=2, column=0, padx=5, pady=5, sticky=tk.NW)
|
|
|
|
start_f = tk.Frame(self.__root, bd=1, height=50)
|
|
start_f.grid(row=3, column=0, padx=5, pady=5, sticky=tk.NW)
|
|
|
|
scala_f = tk.Frame(self.__root, bd=1, height=50)
|
|
scala_f.grid(row=4, column=0, padx=5, pady=5, sticky=tk.NW)
|
|
|
|
info_f = tk.Label(self.__root, bg='silver', text='自动判断列名并合并相同列数据')
|
|
info_f.grid(row=5, column=0, sticky=tk.NSEW)
|
|
|
|
template_f_select = ttk.Button(template_f, state=tk.NORMAL, text="选择模版文件", command=self.__select_template_file)
|
|
template_f_select.grid(row=0, column=0)
|
|
template_f_text = ttk.Label(template_f, textvariable=self.__select_template_file_mess)
|
|
template_f_text.grid(row=0, column=1)
|
|
|
|
compare_f_select = ttk.Button(compare_f, text="选择对比文件", command=self.__select_compare_file)
|
|
compare_f_select.grid(row=0, column=0)
|
|
compare_f_text = ttk.Label(compare_f, textvariable=self.__select_compare_file_mess)
|
|
compare_f_text.grid(row=0, column=1)
|
|
|
|
data_only_rb = ttk.Radiobutton(compare_type_f, variable=self.__conf_type, text='仅对比数据', value=0,
|
|
command=self.__conf_type_selection)
|
|
data_only_rb.grid(row=0, column=0, padx=5, sticky=tk.W)
|
|
format_only_rb = ttk.Radiobutton(compare_type_f, variable=self.__conf_type, text='仅对比格式', value=1,
|
|
command=self.__conf_type_selection)
|
|
format_only_rb.grid(row=0, column=1, padx=5, sticky=tk.W)
|
|
|
|
data_format_rb = ttk.Radiobutton(compare_type_f, variable=self.__conf_type, text='对比数据和格式', value=2,
|
|
command=self.__conf_type_selection)
|
|
data_format_rb.grid(row=0, column=2, padx=5, sticky=tk.W)
|
|
|
|
start_b = ttk.Button(start_f, state=tk.NORMAL, text="开始", command=self.__start_compare)
|
|
start_b.grid(row=0, column=0)
|
|
|
|
progressbar = ttk.Progressbar(scala_f, length=200, mode="determinate", orient=tk.HORIZONTAL,
|
|
variable=self.__progress)
|
|
progressbar.grid(row=0, column=0, padx=5, sticky=tk.NSEW)
|
|
|
|
def __select_template_file(self):
|
|
file = filedialog.askopenfilename(title=u'选择文件', initialdir=(os.path.expanduser('~/')),
|
|
filetypes=[('Excel xls', '*.xls')])
|
|
if len(file) > 0:
|
|
self.__select_template_file_mess.set('模版文件:' + file)
|
|
else:
|
|
self.__select_template_file_mess.set('请选择模版文件')
|
|
self.__template_file_name.set(file)
|
|
|
|
def __select_compare_file(self):
|
|
file = filedialog.askopenfilename(title=u'选择文件', initialdir=(os.path.expanduser('~/')),
|
|
filetypes=[('Excel xls', '*.xls')])
|
|
if len(file) > 0:
|
|
self.__select_compare_file_mess.set('对比文件:' + file)
|
|
else:
|
|
self.__select_compare_file_mess.set('请选择对比文件')
|
|
self.__compare_file_name.set(file)
|
|
|
|
def __conf_type_selection(self):
|
|
conf_type = self.__conf_type.get()
|
|
if conf_type == 0:
|
|
pass
|
|
elif conf_type == 1:
|
|
pass
|
|
elif conf_type == 2:
|
|
pass
|
|
|
|
def __start_compare(self):
|
|
pass
|
|
|
|
|
|
def main():
|
|
root = tk.Tk()
|
|
root.title('Excel 文件对比工具')
|
|
root.geometry('720x640')
|
|
root.minsize(720, 640)
|
|
root.rowconfigure(0, weight=1)
|
|
root.columnconfigure(0, weight=1)
|
|
master_frame = tk.Frame(root)
|
|
master_frame.grid(row=0, column=0, padx=5, pady=5, sticky=tk.NSEW)
|
|
w = MainView(master_frame)
|
|
w.create_windows()
|
|
root.mainloop()
|
|
|
|
|
|
if __name__ == '__main__':
|
|
main()
|