• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Best way to script Excel 2016 from Python
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Best way to script Excel 2016 from Python

  • Subject: Re: Best way to script Excel 2016 from Python
  • From: Felix Zumstein <email@hidden>
  • Date: Tue, 31 Mar 2015 10:36:11 +0200
I could resolve the saving bug by setting a "Default local file location" under Settings/General.

On Fri, Mar 27, 2015 at 1:33 PM, has <email@hidden> wrote:
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      (applescript-users@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users

This email sent to email@hidden

 _______________________________________________
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
References: 
 >Re: Best way to script Excel 2016 from Python (From: has <email@hidden>)
 >Re: Best way to script Excel 2016 from Python (From: Felix Zumstein <email@hidden>)
 >Re: Best way to script Excel 2016 from Python (From: Christian Prinoth <email@hidden>)
 >Re: Best way to script Excel 2016 from Python (From: Felix Zumstein <email@hidden>)
 >Re: Best way to script Excel 2016 from Python (From: has <email@hidden>)

  • Prev by Date: Scripting Mail for Spam
  • Next by Date: Re: Caffeinate Toast
  • Previous by thread: Re: Best way to script Excel 2016 from Python
  • Next by thread: Re: Best way to script Excel 2016 from Python
  • Index(es):
    • Date
    • Thread