-

pip install pyinstaller https://www.google.com/search?q=%ED%8C%8C%EC%9D%BC+%EA%B2%BD%EB%A1%9C+%EB%93%A4%EC%96%B4%EA%B0%80%EA%B8%B0&oq=%ED%8C%8C%EC%9D%BC+%EA%B2%BD%EB%A1%9C+%EB%93%A4%EC%96%B4%EA%B0%80%EA%B8%B0&aqs=chrome..69i57.2916j0j7&sourceid=chrome&ie=UTF-8

from tkinter import * from tkinter.filedialog import askopenfilename from openpyxl import load_workbook import datetime def get_file(): print("get_file") file_path = askopenfilename() print(file_path) number = text_input.get() print(number) now = datetime.datetime.now() now_after_7 = now + datetime.timedelta(days=7) money_due_date = now_after_7.strftime('%Y-%m-%d') read_wb = load_workbook(file_p..

from tkinter import * def get_file() : print("get_file") window = Tk() window.geometry('300x300') window.title("GUI 시작합시당") label_text = Label(window, text="입력하세용") label_text.grid(column=1, row=1) text_input = Entry(window,width=10) text_input.grid(column=2, row=1) label_text2 = Label(window, text="파일 경로 입력하세용") label_text2.grid(column=1, row=2) button = Button(window, text="파일선택하기", command=ge..

from openpyxl import load_workbook import datetime now = datetime.datetime.now() now_after_7 = now + datetime.timedelta(days=7) money_due_date = now_after_7.strftime('%Y-%m-%d') read_wb = load_workbook('./test.xlsx', data_only=True) read_ws = read_wb["Sheet1"] read_ws_sheet2 = read_wb["Sheet2"] print(read_ws_sheet2.cell(2,1).value) print(read_ws_sheet2.cell(3,1).value) print(read_ws_sheet2.cell(..

from openpyxl import load_workbook import datetime now = datetime.datetime.now() print(now) now_after_7 = now + datetime.timedelta(days=7) print(now_after_7) print(now_after_7.strftime('%Y-%m-%d')) money_due_date = now_after_7.strftime('%Y-%m-%d') read_wb = load_workbook('./test.xlsx', data_only=True) read_ws = read_wb["Sheet1"] list1 = [] row = 70 for i in range(2, row) : list1.append(read_ws.c..

from openpyxl import load_workbook read_wb = load_workbook('./test.xlsx', data_only=True) read_ws = read_wb["Sheet1"] list1 = [] row = 70 for i in range(2, row) : list1.append(read_ws.cell(i, 2).value) print(list1) list2 = set(list1) print(list2) list3 = list(filter(None, list2)) print(list3) for i in list3 : read_wb_result = load_workbook("./result.xlsx") read_ws_result = read_wb_result["Sheet1..

from openpyxl import load_workbook read_wb = load_workbook('./test.xlsx', data_only=True) read_ws = read_wb["Sheet1"] list1 = [] row = 70 for i in range(2, row) : list1.append(read_ws.cell(i, 2).value) print(list1) list2 = set(list1) print(list2) list3 = list(filter(None, list2)) print(list3) read_wb_result = load_workbook("./result.xlsx") read_ws_result = read_wb_result["Sheet1"] for i in list3..

from openpyxl import load_workbook read_wb = load_workbook('./test.xlsx', data_only=True) read_ws = read_wb["Sheet1"] list1 = [] row = 70 for i in range(2, row) : list1.append(read_ws.cell(i, 2).value) print(list1) list2 = set(list1) print(list2) list3 = list(filter(None, list2)) print(list3) read_wb_result = load_workbook("./result.xlsx") read_ws_result = read_wb_result["Sheet1"] for i in list3..

from openpyxl import load_workbook read_wb = load_workbook('./test.xlsx', data_only=True) read_ws = read_wb.active list1 = [] row = 70 for i in range(2, row) : list1.append(read_ws.cell(i, 2).value) print(list1) list2 = set(list1) print(list2) list3 = list(filter(None, list2)) print(list3) for i in list3 : current_company = i temp_list = [] for j in range(2, row) : # j = 2,3,4,5,6,7 -- if curren..

엑셀파일들 from openpyxl import load_workbook read_wb = load_workbook('./test.xlsx', data_only=True) read_ws = read_wb.active list1 = [] row = 70 for i in range(2, row) : list1.append(read_ws.cell(i, 2).value) print(list1) list2 = set(list1) print(list2) list3 = list(filter(None, list2)) print(list3)