我是 XML 新手。我拥有的是来自 Adobe Illustrator 的 XML 负载,我正在尝试将 Excel 数据映射到其中。我在原始数据中有序列,看起来像
<Market_Pie>
<datanumDataColumns="5">
<values>
<row>
<valuekey="name"></value>
<value>503.931</value>
<value>268.301</value>
<value>285.561</value>
<value>152.037</value>
</row>
</values>
</data>
</Market_Pie>
Excel 已从中创建了一个 XML 映射,该映射将其视为单个序列。当我尝试将其与各种单元格关联时,它似乎希望将其视为单个列。然而,我的数据是结构化的,因此该数据需要位于一系列单独的列中,每个值对应一个列。
我使用的是 Excel 2007,只是不明白这是如何工作的。帮助文件似乎也毫无帮助。
I'm new to XML. What I have is a load of XML from Adobe Illustrator which I'm trying to map excel data onto. I have sequences in the original data which look like this
<Market_Pie>
<datanumDataColumns="5">
<values>
<row>
<valuekey="name"></value>
<value>503.931</value>
<value>268.301</value>
<value>285.561</value>
<value>152.037</value>
</row>
</values>
</data>
</Market_Pie>
Excel has created an XML map from this which sees this as a single sequence. When I try to associate this with various cells, it seems to want to see this as a single column. My data, however, is structured so that this data needs to be in a series of separate columns, one column for each value.
I'm using Excel 2007, and just can't see how this is supposed to work. The help files seem remarkably unhelpful as well.
发布评论
评论(1)
为了让每个值都有自己的列,每个值都需要一个唯一的键,该键对应于每列的标题。有几种方法可以欺骗这一点:
在一张工作表中导入数据,并在另一张工作表中使用公式或函数,沿着列进行计算并将所有值放入列中。
为每个值指定一个唯一的元素名称或 ID。要么:
要么
任一解决方案的问题都揭示了您所想到的实际问题,即:如果您有 200 个值怎么办?您真的想要 200 列吗?通常,值组会放入列中,并且每个组都有自己的列。如果这些值都属于同一组,您可能希望将它们放在一列中。但是,如果列适合您的模型,正如您的问题所示,我会选择使用函数。
In order to have each value get its own column, each value needs a unique key, something that would correspond to the the header for each column. There are a couple of ways to cheat this:
Import the data in one sheet, and have a formula or function in another sheet that works down the column and puts all values in columns.
Give each value a unique element name or id. Either:
or
The problem with either solution reveals the actual problem with what you have in mind, which is: what if you had 200 values? Do you actually want 200 columns? Typically sets of values go into columns, and each set gets its own column. If the values all belong to the same set, you probably want to have them in one column. But if columns fit your model, as your question suggests, I would go with using a function.