New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Mac: Excel 2016 compatibility (from Python to Excel) #170

Closed
fzumstein opened this Issue Mar 24, 2015 · 4 comments

Comments

Projects
None yet
2 participants
@fzumstein
Member

fzumstein commented Mar 24, 2015

appscript doesn't work with 2016 out of the box, see: http://lists.apple.com/archives/applescript-users/2015/Mar/msg00114.html

@fzumstein fzumstein changed the title from Mac: Replace appscript layer with pyobjc for Office 2016 compatibility to Mac: Fix Mac-Office 2016 incompatibility Mar 24, 2015

@fzumstein

This comment has been minimized.

Member

fzumstein commented Mar 26, 2015

Using a static glue from Office 2011 seems to work fine: http://lists.apple.com/archives/applescript-users/2015/Mar/msg00290.html

>>> from appscript.terminology import dump
>>> dump('Microsoft Excel', '/path/to/myappglue.py')

>>> import myappglue
>>> from appscript import app
>>> app = app('Microsoft Excel', terms=myappglue)

but AppleScript's saving doesn't work properly (it displays Document not saved. when trying to resave the opened document manually:

tell application "Microsoft Excel"
    set new_book to make new workbook
    save workbook as new_book filename "test.xlsx"
end tell
@fzumstein

This comment has been minimized.

Member

fzumstein commented Mar 26, 2015

TODO

  • saving doesn't work (AppleScript issue - might be a general early version issue) ==> seems that setting a Default local file location may solve this - need to redo it though quite often. update: this option has disapeard with the first update...update2: seems to be resolved now with 2nd update 15.10
  • wb = Workbook('Workbook1') throws an error ('/WORKBOOK1' could not be found.) when unsaved ==> needs to call get_workbook instead of open_workbook, this is really a current bug
  • fix hyperlink test
  • wb.application.calculation need to be updated to run with k.manual etc. instead of Constants ==> however, switching to Automatic from Manual doesn't trigger a recalculate like on the other versions. Seems to be a changed behaviour of Excel 2016
  • Unicode issue when running nosetests
  • Excel shows quickly up when doing Workbook(app_visible=False) - The Sheet tests also don't pass when app_visible = False.
  • VBA fails - see extra issue #206

@fzumstein fzumstein changed the title from Mac: Fix Mac-Office 2016 incompatibility to Mac: Make it Office 2016 compatible Mar 26, 2015

@fzumstein fzumstein changed the title from Mac: Make it Office 2016 compatible to Mac: Excel 2016 compatibility Mar 26, 2015

@fzumstein fzumstein modified the milestone: v0.3.6 May 19, 2015

@fzumstein fzumstein closed this Jul 12, 2015

@fzumstein fzumstein changed the title from Mac: Excel 2016 compatibility to Mac: Excel 2016 compatibility (from Python to Excel) Jul 12, 2015

@zefyrr

This comment has been minimized.

zefyrr commented Nov 14, 2015

Why is this issue closed? It still is an issue, no?

@fzumstein

This comment has been minimized.

Member

fzumstein commented Nov 14, 2015

What you are referring to is covered in #206. This one is only from python to Excel.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment