形状数据取决于excel文件 [英] Shape data depended on excel file

问题描述

大家好，

我想将形状数据添加到依赖于excel文件数据的形状。例如，我有一个包含以下类的excel文件：

I want to add shape data to a shape which is dependent on data from an excel file. For example, i have an excel file with the following classes:

PositionType - 函数 - 传感器 - 品牌

PositionType - Function - Sensor - Brand

我有3个PositionTypes：PT1，PT2和PT3

I have 3 PositionTypes: PT1, PT2 and PT3

PT1有2个功能：PT1F1，PT1F2

PT1 has 2 Functions: PT1F1, PT1F2

PT1F1可以是2个传感器：Fotocell或ReedContact

PT1F1 can be 2 sensores: Fotocell or ReedContact

该品牌取决于传感器的类型，但是固定，所以如果它是fotocell，品牌总是'Company1'，如果传感器是ReedContact，品牌是'Company2'。

The brand is dependend on the type of sensor, but fixed, so if it's fotocell, the brand is always 'Company1', if the sensor is a ReedContact, the brand is 'Company2'.

链接到excel示例：  http：//prntscr.com/ln2r67

Link to excel example: http://prntscr.com/ln2r67

使用此数据，我想在我的形状数据中创建一个下拉列表。

And with this data i want to make a drop down list in my shape data.

首先我应该选择PositionType。这是一个包含PT1和PT2的列表

So first i should select the the PositionType. This is a list with PT1 and PT2

在我选择PT1之后，我需要选择一个功能：这也是一个下拉列表，但仅限于功能PT1F1，PT1F2和PT1F3。 

After i selected PT1 i need to select a function: this is again a drop down list but only with the functions PT1F1,PT1F2 and PT1F3. 

传感器类型也是如此：只有可能类型的下拉列表（Fotocell或ReedContact）

The same goes for the sensorType: A drop down list with only the possible types (Fotocell or ReedContact)

形状数据字段Brand应该是自动填写Brand，因为这完全取决于SensorType。

The shape data field Brand should then be automatically filled in with the Brand, because this is a completely depended on the SensorType.

我不知道哪个是最好的选择。我想从excel中提取数据，所以当我需要添加一个positiontype时我可以很容易地修改excel

I don't know which is the best option to do this. I would like to extract the data from an excel so when i need to add a positiontype i could easily modify the excel

提前谢谢。

推荐答案

Visio没有可以执行此操作的内置工具！特别是来自Excel源码!!!

Visio haven't build-in tools which can do this ! Especially from Excel source !!!

您可以创建具有依赖上下文列表的智能形状，它可以处理Visio文档中的形状数据。但即使对我来说，这也是一项非常复杂的任务：）

You can create smart shape which have depended context lists, it can work with shape data in Visio document. But this is very complex task even for me :)

这篇关于形状数据取决于excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！