add Workbook.save() method

[fzumstein]

No description provided.

[fzumstein]

Mac:

• Can't seem to save the workbook elsewhere than in the current excel folder (full path is interpreted as the name of the file): wb.xl_workbook.save_workbook_as(filename="/Users/Felix/Desktop/test.xlsx").
• Additionally, when using: wb = Workbook('Workbook1'), wb.xl_workbook is referring to the workbook in lower case (workbook1) and doesn't find it. -> that was a bug in main.py
• Ah - Classic Mac OS file path: wb.xl_workbook.save_workbook_as(filename='Macintosh HD:Users:Felix:Desktop:test.xlsx') - all good then.
• Conversion: from appscript import mactypes; mactypes.Alias(u'/Users/Felix/Desktop').hfspath

[bklaas]

This is the only direct reference I can find anywhere for save...is it accurate to say that the current released version of xlwings (0.3) cannot save changes at all?

There must be something incredibly hard about saving a spreadsheet, especially xlsx, because looking across the breadth of spreadsheet parsing libraries in Python, Perl, and Ruby, they all seem to have this limitation with xlsx: they either can't save changes or cannot edit an already-in-place xlsx file.

[fzumstein]

save hasn't been implemented, yes. Again - there's a good chance it'll make it into 0.3.1. The thing that is still missing I feel is the possibility to control the working directory from Excel (apart from the Mac version playing funny last time I tried). Same as for your other comment though: If you are on Windows, use this workaround: wb.xl_workbook.SaveAs(r"C:\...\test.xlsx")