Best way to script Excel 2016 from Python
Best way to script Excel 2016 from Python
- Subject: Best way to script Excel 2016 from Python
- From: Felix Zumstein <email@hidden>
- Date: Wed, 25 Mar 2015 11:40:32 +0100
Office 2016 stopped working with the Python package appscript, see thread "New Office for Mac Beta and Applescript". Is PyObjC in connection with py-applescript the best way to deal with the situation going forward? Or are there any other options (that also work with MacOS < 10.10)?
With Office 2016, ASTranslate transforms this:
tell application "Microsoft Excel"
set value of range ("A1") to 5
end tell
into this:
app(u'Microsoft Excel').AS_newreference(app.elements('X117').byname(u'A1').property('DPVu')).set(5)
but when I use this, it returns the following error:
AttributeError: Unknown property, element or command: 'elements'
thanks,
Felix
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden