I have a xml file, here is sample part:
<?xml version="1.0" encoding="UTF-8"?>
<ProducsList>
<Product id="1">
<SpecList>
<Spec>
<SpecLabel>Heig ht</SpecLabel>
<SpecValue>10 </SpecValue>
<SpecCat>Dimens ion</SpecCat>
</Spec>
<Spec>
<SpecLabel>Widt h</SpecLabel>
<SpecValue>6</SpecValue>
<SpecCat>Dimens ion</SpecCat>
</Spec>
<Spec>
<SpecLabel>Weig ht</SpecLabel>
<SpecValue>20.5 </SpecValue>
<SpecCat>Weigth </SpecCat>
</Spec>
</SpecList>
</Prodcut>
<Product id="2">
<SpecList>
<Spec>
<SpecLabel>Heig ht</SpecLabel>
<SpecValue>8</SpecValue>
<SpecCat>Dimens ion</SpecCat>
</Spec>
<Spec>
<SpecLabel>Widt h</SpecLabel>
<SpecValue>5</SpecValue>
<SpecCat>Dimens ion</SpecCat>
</Spec>
<Spec>
<SpecLabel>Weig ht</SpecLabel>
<SpecValue>18 </SpecValue>
<SpecCat>Weigth </SpecCat>
</Spec>
</SpecList>
</Prodcut>
<Product id="3">
<SpecList>
<Spec>
<SpecLabel>Heig ht</SpecLabel>
<SpecValue>5</SpecValue>
<SpecCat>Dimens ion</SpecCat>
</Spec>
<Spec>
<SpecLabel>Widt h</SpecLabel>
<SpecValue>2</SpecValue>
<SpecCat>Dimens ion</SpecCat>
</Spec>
<Spec>
<SpecLabel>Weig ht</SpecLabel>
<SpecValue>10 </SpecValue>
<SpecCat>Weigth </SpecCat>
</Spec>
</SpecList>
</Prodcut>
</ProductsList>
I need to create a table look like that based on that xml file:
----------------------------------------------------
Label Product 1 product 2 product 3
----------------------------------------------------
Height 10 8 5
Width 6 5 2
Weight 20.5 18 10
I am totally losed, I don't know how to create that table. any one has
any idea about that? thank you very much.
Also how many Spec in SpecList is unkown.
Thanks for the help.