M
MT
We have an XML file that is in a particular format and we want to allow our
users to enter data using Excel 2K3. I found that there were some
limitations regarding recursive structures. I was wondering if Microsoft
recommends any way to get around this.
Basically, our xml file looks like this (I have changed the tag names to
make it more readable):
<root>
<c index="1">
<val>
c_val1
</val>
<r index="1">
<a>Data1</a>
<b>Data1</b>
</r>
<r index="2">
<a>Data2</a>
<b>Data2</b>
</r>
<r index="3">
<a>Data3</a>
<b>Data3</b>
</r>
</c>
<c index="2">
<val>
c_val2
</val>
<r index="1">
<a>Data1</a>
<b>Data1</b>
</r>
<r index="3">
<a>Data3</a>
<b>Data3</b>
</r>
</c>
</root>
I have an XSD file that describes this template. The number of dir and R
tags can change but there is always a maximum. There could be an unlimited
number of C entries. Is there a way for excel to transform this into a flat
2D structure in the following method:
Val R1.a R1.b R2.a R2.b R3.a
R3.b
c_val1 Data1 Data1 Data2 Data2 Data3 Data3
c_val2 Data1 Data1 Data3
Data3
Is there a better alternative to convert a tree-like structure into a 2d
Format? We really need the Excel format because it allows us to manipulate
data. Also, is there a way to use XML transformation to transform the
structure so that it can be imported into Excel and exported from Excel....
Thanks,
MT
users to enter data using Excel 2K3. I found that there were some
limitations regarding recursive structures. I was wondering if Microsoft
recommends any way to get around this.
Basically, our xml file looks like this (I have changed the tag names to
make it more readable):
<root>
<c index="1">
<val>
c_val1
</val>
<r index="1">
<a>Data1</a>
<b>Data1</b>
</r>
<r index="2">
<a>Data2</a>
<b>Data2</b>
</r>
<r index="3">
<a>Data3</a>
<b>Data3</b>
</r>
</c>
<c index="2">
<val>
c_val2
</val>
<r index="1">
<a>Data1</a>
<b>Data1</b>
</r>
<r index="3">
<a>Data3</a>
<b>Data3</b>
</r>
</c>
</root>
I have an XSD file that describes this template. The number of dir and R
tags can change but there is always a maximum. There could be an unlimited
number of C entries. Is there a way for excel to transform this into a flat
2D structure in the following method:
Val R1.a R1.b R2.a R2.b R3.a
R3.b
c_val1 Data1 Data1 Data2 Data2 Data3 Data3
c_val2 Data1 Data1 Data3
Data3
Is there a better alternative to convert a tree-like structure into a 2d
Format? We really need the Excel format because it allows us to manipulate
data. Also, is there a way to use XML transformation to transform the
structure so that it can be imported into Excel and exported from Excel....
Thanks,
MT