How can I edit Excel Workbooks using XLRD or openp

问题:

I have a workbook that has some sheets in it. One of the sheets has charts in it. I need to use xlrd or openpyxl to edit another sheet, but, whenever I save the workbook, the charts are gone.

Any workaround to this? Is there another python package that preserves charts and formatting?

回答1:

This is currently not possible with either but I hope to have it in openpyxl 2.x. Patches / pull requests always welcome! ;-)