Excel数据和Visio/PPt之间的数据链接 [英] Data linking between Excel data and Visio/PPt

问题描述

问题:我们如何将数据从excel工作表链接到ppt图表/visio图表? 这里的图是描述不同应用程序之间数据传输的数据流程图.

我知道excel数据需要格式化，但不确定如何处理，并且无法在线找到有用的链接.

任何了解这一点都会很有帮助.

谢谢.

解决方案

这可以通过多种方式完成，使用最新版本(2007和2010)，您可以将数据链接到Visio图表中，而无需编写任何代码:

Visio /Excel数据链接

如果您使用的是2007年之前的Visio或PPT，那么我想您想使用VBA创建链接.然后，问题就变成了如何在Excel单元格和Visio/PPT形状之间保持链接.

我使用了名为 eVSM 的工具，该工具将Visio中的流程图转储到Excel表中.为了维护Excel工作表和Visio形状之间的持久链接，他们将形状的GUID存储在形状单元的Excel单元格注释中.如果可以为PowerPoint形状获得唯一的ID，则可能可以执行类似的操作.

此更新机制是手动运行的，因为它耗时较长，因此它不像在Excel中那样工作，因为您需要修改值并且链接的显示会立即更改，因此您必须仔细考虑如何完成那个.

Question: How can we link data from excel sheets to ppt diagrams / visio diagrams ? Diagrams here are data flow diagrams depicting data trasfer between different applications.

I am aware that the excel data needs to be formatted but not sure how to go about it and could not find helpful links online.

Any light on this would be very helpful.

Thank you.

解决方案

This can be done in many ways, and with more recent versions (2007 and 2010) you can link data into a Visio diagram without writing any code:

Visio/Excel data link

If you're working pre-2007 Visio or with PPT, then I think you'd want to use VBA to create the link. The problem then becomes how do you persist a link between an Excel cell and a Visio/PPT shape.

I've worked with a tool called eVSM that dumps a process chart in Visio out to an Excel table. In order to maintain a persistent link between the Excel worksheet and the Visio shapes, they store the GUID of a shape in the Excel cell comment for the shapes cell. You might be able to do something similar if you can get a unique ID for a PowerPoint shape.

This update mechanism gets run manually because it is relatively time intensive, so it doesn't work like in Excel where you modify the value and the linked display changes instantly, so you'd have to think through how you want to accomplish that.

这篇关于Excel数据和Visio/PPt之间的数据链接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！