如何在保存图表的同时使用XLRD或openpyxl编辑Excel工作簿? [英] How can I edit Excel Workbooks using XLRD or openpyxl while preserving charts?

问题描述

我有一本工作簿，里面有几张纸.一张纸上有图表.我需要使用xlrd或openpyxl来编辑另一个工作表，但是，每当保存工作簿时，图表都消失了.

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.

有任何解决方法吗?还有另一个可以保留图表和格式的python软件包吗?

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

推荐答案

目前这两种方法均无法实现，但我希望将其安装在openpyxl 2.x中.补丁/拉取请求一律欢迎！ ;-)

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

这篇关于如何在保存图表的同时使用XLRD或openpyxl编辑Excel工作簿?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！