본문 바로가기

분류 전체보기

 (42)
폴더내이미지순환 from tkinter import * from PIL import ImageTk, Image from tkinter import messagebox from tkinter import filedialog import os import time from numpy.random import choice def choose(): global folder_choose folder_choose = filedialog.askdirectory(initialdir='path', title='select folder') if folder_choose == '': messagebox.showwarning("경고", "폴더를 선택하세요") input_entry.delete(0.0, END) input_entry.inser..
엑셀DB순환 from tkinter import * from tkinter import scrolledtext from tkinter import messagebox from tkinter import filedialog from openpyxl import load_workbook import time from numpy.random import choice def choose(): file_name1 = filedialog.askopenfilename(initialdir='path', title='select file', filetypes=(('*xlsx', '*.xlsx'),('all files', '*.*'))) global files files=file_name1 if files == '': messageb..
이메일자동발송 from datetime import datetime from email import charset from tkinter import * from tkinter import filedialog from tkinter import messagebox from tkinter.ttk import Notebook from tkinter import ttk import pyautogui as pag import time from openpyxl import load_workbook import openpyxl as xl import smtplib from os.path import basename from email.mime.application import MIMEApplication from email.mi..
특정위치클릭 from tkinter import * import pyautogui def mouse_position(event=None): #바인딩했을때 event도 설정해 주어야 함 x_po,y_po=pyautogui.position() input_entry1.delete(0, END) input_entry1.insert(INSERT, x_po) input_entry2.delete(0, END) input_entry2.insert(INSERT, y_po) def clicks_sp(): pyautogui.PAUSE =1 pyautogui.FAILSAFE =True pyautogui.click(int(input_entry1.get()),int(input_entry2.get()), button='left', clicks..
이미지포맷확인 import PIL.Image #이미지 from tkinter import * from tkinter import filedialog from tkinter import messagebox def choose(): file_name1 = filedialog.askopenfilename(initialdir='path', title='select file', filetypes=(('jpg files','*.jpg'),('png files','*.png'),('gif files','*.gif'),('bmp files','*.bmp'),('all files','*.*'))) global files files=file_name1 if files == '': messagebox.showwarning("경고", "파..
캔버스이미지삽입 내부 함수 from tkinter import * from PIL import ImageTk, Image from tkinter import filedialog from tkinter import messagebox from openpyxl import load_workbook wbf ='db_gen_v5.xlsx' wb = load_workbook(wbf) # 경로는 꼭 "/"로 wbs = wbf sheet = wb['login_size_position'] #시트이름은 정확히 csz_x = sheet['e7'].value csz_y = sheet['f7'].value res_r = sheet['b11'].value files_im_s="jpg 파일을 선택해 주세요!^^" files_im=sheet['b..
엑셀DB검색 내부 함수 import pandas as pd from tabulate import tabulate from tkinter import ttk from tkinter import scrolledtext wbf ='site_db_new_v14.xlsx' data = pd.read_excel(wbf, sheet_name=[0,1], engine = "openpyxl") data[1]=data[1].applymap(str) #모든 데이터프레임에 데이터를 문자화하여 검색이 가능하도록 data[1]['내선']=data[1]['내선'].str.zfill(4) #데이터 앞에 0 붙이기 def innerline(): datashow = data[1][data[1][chlb.get()].str.contains(str(s..
구글시트연동 구글드라이브 API -참고URL- https://lucaseo.github.io/posts/2020-04-12-python-spreadsheet-gspread/ #주요내용# 1. 구글클라우드플랫폼 로그인 및 새 프로젝트 생성 2. 구글클라우드플랫폼(GCP)에서 json파일 내려받아서 GUI 파일있는 폴더에 넣기 3. 구글스프레드시트에 json파일의 메일 공유설정 내부 함수 from oauth2client.service_account import ServiceAccountCredentials import gspread from openpyxl import load_workbook import pandas as pd from tabulate import tabulate from tkinter import t..
반응형

티스토리툴바