Mac: Excel 2016 compatibility (from Python to Excel)

[fzumstein]

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

[fzumstein]

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]

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 Mac: Excel 2016 - enable VBA calls #206

[zefyrr]

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

[fzumstein]

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