Repository navigation
Feature - Edit Chart Data #1141
Description
Edit Chart Data
It would be incredibly valuable to edit chart data within a Word Document.
Research
This has been raised (and was closed) via #444 stating that the user should post to StackOverflow for assistance.
However, investigating Stack Overflow: [🏷️python-docx] edit chart shows that nobody has been able to solve this problem with the only suggestion being to use python-pptx.
It would be nice to have similar functionality within python-docx.
Documentaiton
From my interpretation of Shapes (in general) — python-docx 0.8.11 documentation and Inline shape — python-docx 0.8.11 documentation this functionality appears to be possible but non-trivial and unimplemented.
Apologies if I have missed anything!
Reacted by Phuntsho Wangdi, Alexamakans, Ruben Nielsen, benkyou, Lucas Depetris and Shi Pengtao
Activity
eldamir commentedon Aug 11, 2023
This would be incredibly useful. Actually, my main requirement from a library like this. My journey so far can be summed up to:
I looked into other solutions from the C#/Dotnet world. They have a similar story. OpenXMLSdk2 is available, but too low-level implementation to be practical. Several libraries are built on top to try to make it simpler. Most of them support only Word xor PowerPoint xor Excel. Some support all, and those are paid, commercial libraries. Out of 4 of those commercial ones, only 1 of them - the most expensive one - promises an API for editing Chart data 😦
It seems to be a very tricky topic.
I'm guessing that the maintainers of this repo has some deep knowledge of OpenXML stuff. It would be awesome if they could chime in and help us find a good direction for this 😉
I'd love to contribute a solution, but I don't even know where to start 🤣
eldamir commentedon Aug 11, 2023
Currently trying some funky work-arounds for dealing with updating of charts. It it works, I'll turn it into a blog post. Maybe it'll spark some interest here.
I'll be back with an update if I'm successful 😉
benkyousec commentedon Aug 15, 2023
+1 I'm also trying to get around having editable charts in the document.
Like you mentioned, there seems to be a workaround using
python-pptx. See #392 .eldamir commentedon Aug 15, 2023
Thank you @marcus-hao.
What I am currently hacking together in my own specific case is:
So far, it seems to work okay, but I need to explore some edge cases. It is not a reasonable thing to add to this library, but it may be a somewhat reasonable workaround for some 😉
benkyousec commentedon Aug 21, 2023
@eldamir That's what I thought about too, changing the underlying XML. But I think this method is too complicated for my use case. :(
lucasdepetrisd commentedon Sep 25, 2023
@eldamir I'm interested in your workaround. I'd like to know more about it, also regarding those edge cases. If you could share your approach or any insights, that would be great. Thanks a lot!
eldamir commentedon Sep 25, 2023
Alright friend, I tried to write up the whole shebang, just for you, @lucasdepetrisd.
Enjoy: https://botched-deployments.com/posts/python-docx-charts
scanny commentedon Sep 26, 2023
Nice post @eldamir! :)
One other possible appoach is to use
python-pptxto generate the charts and then "transplant" them into Word. The chart functionality inpython-pptxis pretty well advanced; it turns out to be highly desired by analytics projects who funded most of that work.I'm sure there are differences, especially at the top level with how they are embedded into a document instead of a slide, but I expect much of the DrawingML aspects are identical, which Microsoft would have done on purpose of course because DrawingML objects can appear in all of Excel, Word, and PowerPoint.
Just an idea, but I've seen folks succeed at that approach too. :)
eldamir commentedon Sep 28, 2023
Thank you @scanny. For my case, I need the advantage of being able to prepare the word template by hand, but I'll definitely dig into
python-pptxto see if I can maybe be a bit smarter about how I update the charts.Messing with the XML by hand works fine, but is pretty low-level, and it is different for every chart type... Maybe
python-pptxwould provide a simpler interface for it ❤️mengdeer589 commentedon Jun 4, 2024
请在此处获取monkey.py文件monkey.txt
我通过整合KehaoWu的代码，创建了monkey.py这个文件，使用monkey patching的办法为docx增加了添加可编辑图表的功能。 使用示例参考
1，需要在代码中引入该文件
import monkey,，2，需修改docx/oxml/shape.py，65行，增加
cChart = ZeroOrOne('c:chart')，即可成功使用。测试版本：
python 3.11
python-docx 1.1.2
python-pptx 0.6.23
示例代码：
`from docx import Document
from pptx.chart.data import CategoryChartData
from pptx.enum.chart import XL_CHART_TYPE
from pptx.util import Cm
import monkey
document = Document()
chart_data = CategoryChartData()
chart_data.categories = ["apple", "banana", "grape"]
chart_data.add_series("Series 1", (19, 30, 7))
chart = document.add_chart(
XL_CHART_TYPE.COLUMN_CLUSTERED, 0, 0, Cm(15.2), Cm(11.4), chart_data
)
document.save("test.docx")
`
不过未经严格测试，请谨慎使用