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

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