excel图表中的轴ID [英] Axis id in excel charts

问题描述

我正在使用OOXML sdk 2.0构建报表生成器，并希望添加一个包含n系列的图表。我使用文档反射器来查找代码的基本结构并更改了系列的值。
当我在excel中打开时，由于部件不可靠而移除了绘图部件。我将原始文档与我创建的文档进行了比较，唯一的区别是系列。在excel中添加manualy系列时，唯一不同的是axisid（xml中的axid节点）。我看到这个id正在根据图表的内容（系列）而改变。这是如何计算的，我在哪里可以找到描述这个的文档。

brds Jonas

解决方案

您是否尝试过使用其中的验证功能Open XML SDK。查看以下有关如何在SDK中使用验证功能的帖子： http://blogs.msdn.com/brian_jones/archive/2009/09/24/finding-open-xml-errors -with-open-xml-sdk-validation.aspx

请告知我们是否有助于找到您的问题。

I'm building a report generator using OOXML sdk 2.0 and want to add a chart with n series. I used the document reflector to find the basic structure of the code and changed the values of the series.
When i open this in excel the drawing part is removed due to an unredable part. I've compared the original document with the one I created and the only difference is the series. When adding the series manualy in excel the only thing different is the axisid (axid node in the xml). I see that this id is changing depending of the content of the chart (the series). How is this calcualted and where can i find the documentation describing this.

brds Jonas

解决方案

have you tried to use the validation functionality within the Open XML SDK. Check out the following post on how to use the validation functionality within the SDK: http://blogs.msdn.com/brian_jones/archive/2009/09/24/finding-open-xml-errors-with-open-xml-sdk-validation.aspx

let us know if that helped find your issue(s).

这篇关于excel图表中的轴ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！