컴퓨터/Python

python win32com excel 단축키 실행

풍경소리^^ 2022. 4. 16. 18:51
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