Re: Best way to script Excel 2016 from Python
Re: Best way to script Excel 2016 from Python
- Subject: Re: Best way to script Excel 2016 from Python
- From: has <email@hidden>
- Date: Fri, 27 Mar 2015 12:33:33 +0000
On 27/03/2015 08:06, Christian Prinoth wrote:
fwiw, I tried modifying Info.plist with the command:
sudo plutil -replace NSAppleScriptEnabled -bool false
/Applications/Microsoft\ Excel.app/Contents/Info.plist
But after that for some reason Excel would not start anymore (at the
prompt it returns "Killed: 9"), so I had to reinstall the application.
Codesigning, maybe? Or perhaps something plutil did to it? Caveat hacker. :/
On 27/03/2015 09:26, Felix Zumstein wrote:
But I discovered an issue with AppleScript directly - saving doesn't
work properly:
tell application "Microsoft Excel"
set new_book to make new workbook
save workbook as new_book filename "test.xlsx"
end tell
Does it work any better with a full HFS path string? Mind that the
`filename` parameter is optional; I think if Excel doesn't like the
given value it simply ignores it and saves the file to its current
location. (Yeah, it's a spectacularly cranky scripting interface.)
There's one or two Office scripting vets on this list; perhaps they have
some ideas?
has
_______________________________________________
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