python appscript for macOS

Question

I am trying to use python package appscript to control applications in my MacBook. Unfortunately I am really confused.

For example, I am trying to control one of my excel files. I want to get the position and scroll to certain roll. Here is my code

# -*- coding:utf-8 -*-

from appscript import *

file = app('Microsoft Excel').documents[u'test.csv']
position = file.window.left_position()
print position

The code is only trying to get the position but it is not working. I download the ASDictionary to check the command but I still can not fix it. Here is the screenshot of the command:

Thank you so much for your help.

foo · Accepted Answer · 2021-07-02 05:47:48Z

2

Excel’s Apple event (“AppleScript”) support is atypical and quirky.

Avoid using documents; it doesn’t work correctly. Use workbooks instead.
Workbooks don’t have a window property. They do, however, have windows elements (since you can view a workbook in more than one window).

Corrected Python code:

wb = app('Microsoft Excel').workbooks[u'test.csv']
position = wb.windows[1].left_position()
print(position)

Or, in AppleScript:

tell application "Microsoft Excel"
    tell workbook "test.csv"
        get left position of window 1
    end tell
end tell

answered Jul 2, 2021 at 5:47

foo

7341 gold badge5 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

liaoming999 Over a year ago

thank you so much. do you mind telling me how to get window id? I try "wb.windows[1].id()" but it is not working

foo Over a year ago

Unlike most scriptable apps, Excel’s window doesn’t have an id property. You can only reference Excel windows by index or name.

Collectives™ on Stack Overflow

python appscript for macOS

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related