import xlwings as xw
from PIL import ImageGrab
import time
app = xw.App(visible=True, add_book=False)
wb1 = app.books.open(r"C:/Users/Administrator/Desktop/KPI2.xlsm")
sht6 = wb1.sheets['主管实动']
sht6.api.activate #就这个地方出问题，显示无效语句不往下走了，
我换成sht6.activate（）就报错内容：Exception: Could not activate App! Try to instantiate the App with visible=True.
主要下面这是个VBA需要显示这页才能运行
wb1.macro('Sheet9.fuz')()
print(1)
time.sleep(3.5)
sht6.api.activate改成sht6 = sht6.api.activate 试试