컴퓨터/Python

python qtablewidget excel 실행

풍경소리^^ 2022. 5. 17. 03:21
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]
print(win)
if win.isActive == False:
    pywinauto.application.Application().connect(handle=win._hWnd).top_window().set_focus()
win.activate()
pyautogui.hotkey('ctrl','shift','n')