import win32com.client
import pyautogui
import pywinauto
import pygetwindow as gw
xl = win32com.client.Dispatch('Excel.Application')
xl.Visible = True
wb = xl.Workbooks.Open("D:\회사\회계\★전체장부.xlsm")
ws = wb.Worksheets("계좌없음")
win = gw.getWindowsWithTitle('전체')[0]
if win.isActive == False:
pywinauto.application.Application().connect(handle=win._hWnd).top_window().set_focus()
win.activate()
pyautogui.hotkey('ctrl','shift','n')
환경
python 3.10
pycharm
설치모듈
pypiwin32
pyautogui
'컴퓨터 > Python' 카테고리의 다른 글
pyside6-uic mainwindow.ui -o mainwindow.py (0) | 2022.04.21 |
---|---|
python 카카오톡 나에게보내기 (0) | 2022.04.20 |
jupyterlab 설치 에러 (0) | 2022.04.15 |
flask slack (0) | 2022.04.08 |
flask_fastcampus2 (0) | 2022.04.01 |