컴퓨터/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