EDN Admin
Well-known member
hi to all,
Im new with this xml and xslt thing. i read some article to study xml in .net, and now I can generate the required xml. And here is my xml.
<div style="color:Black; background-color:White
<pre>
<span style="color:Blue <?<span style="color:#A31515 xml <span style="color:Red version<span style="color:Blue =<span style="color:Black "<span style="color:Blue 1.0<span style="color:Black " <span style="color:Red encoding<span style="color:Blue =<span style="color:Black "<span style="color:Blue utf-8<span style="color:Black "<span style="color:Blue ?>
<span style="color:Blue <<span style="color:#A31515 TreeViewData<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 Nodes<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeParent <span style="color:Red Text<span style="color:Blue =<span style="color:Black "<span style="color:Blue Parent1<span style="color:Black "<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeChild<span style="color:Blue >Child1<span style="color:Blue </<span style="color:#A31515 NodeChild<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeChild<span style="color:Blue >Child2<span style="color:Blue </<span style="color:#A31515 NodeChild<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeChild<span style="color:Blue >Child3<span style="color:Blue </<span style="color:#A31515 NodeChild<span style="color:Blue >
<span style="color:Blue </<span style="color:#A31515 NodeParent<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeParent <span style="color:Red Text<span style="color:Blue =<span style="color:Black "<span style="color:Blue Parent2<span style="color:Black "<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeChild<span style="color:Blue >Child1<span style="color:Blue </<span style="color:#A31515 NodeChild<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeChild<span style="color:Blue >Child2<span style="color:Blue </<span style="color:#A31515 NodeChild<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeChild<span style="color:Blue >Child3<span style="color:Blue </<span style="color:#A31515 NodeChild<span style="color:Blue >
<span style="color:Blue </<span style="color:#A31515 NodeParent<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeParent <span style="color:Red Text<span style="color:Blue =<span style="color:Black "<span style="color:Blue Parent3<span style="color:Black "<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeChild<span style="color:Blue >Child1<span style="color:Blue </<span style="color:#A31515 NodeChild<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeChild<span style="color:Blue >Child2<span style="color:Blue </<span style="color:#A31515 NodeChild<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeChild<span style="color:Blue >Child3<span style="color:Blue </<span style="color:#A31515 NodeChild<span style="color:Blue ><span style="color:Blue <<span style="color:#A31515 br<span style="color:Blue />
<span style="color:Blue <<span style="color:#A31515 NodeChild<span style="color:Blue >Child4<span style="color:Blue </<span style="color:#A31515 NodeChild<span style="color:Blue ><span style="color:Blue <<span style="color:#A31515 br<span style="color:Blue />
<span style="color:Blue </<span style="color:#A31515 NodeParent<span style="color:Blue ><span style="color:Blue <<span style="color:#A31515 br<span style="color:Blue />
<span style="color:Blue <<span style="color:#A31515 Nodes<span style="color:Blue ><span style="color:Blue <<span style="color:#A31515 br<span style="color:Blue />
[/code]
My problem now is the xslt. That xml data must be transfer to excel with treeview like structure. So meaning for example
The parent1 will be in placed in A1 cell then its child will be place in B2,B3,B4 cell. im zero knowledge in xslt.
Need help
Thanks in advance.
<
mmb
View the full article
Im new with this xml and xslt thing. i read some article to study xml in .net, and now I can generate the required xml. And here is my xml.
<div style="color:Black; background-color:White
<pre>
<span style="color:Blue <?<span style="color:#A31515 xml <span style="color:Red version<span style="color:Blue =<span style="color:Black "<span style="color:Blue 1.0<span style="color:Black " <span style="color:Red encoding<span style="color:Blue =<span style="color:Black "<span style="color:Blue utf-8<span style="color:Black "<span style="color:Blue ?>
<span style="color:Blue <<span style="color:#A31515 TreeViewData<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 Nodes<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeParent <span style="color:Red Text<span style="color:Blue =<span style="color:Black "<span style="color:Blue Parent1<span style="color:Black "<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeChild<span style="color:Blue >Child1<span style="color:Blue </<span style="color:#A31515 NodeChild<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeChild<span style="color:Blue >Child2<span style="color:Blue </<span style="color:#A31515 NodeChild<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeChild<span style="color:Blue >Child3<span style="color:Blue </<span style="color:#A31515 NodeChild<span style="color:Blue >
<span style="color:Blue </<span style="color:#A31515 NodeParent<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeParent <span style="color:Red Text<span style="color:Blue =<span style="color:Black "<span style="color:Blue Parent2<span style="color:Black "<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeChild<span style="color:Blue >Child1<span style="color:Blue </<span style="color:#A31515 NodeChild<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeChild<span style="color:Blue >Child2<span style="color:Blue </<span style="color:#A31515 NodeChild<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeChild<span style="color:Blue >Child3<span style="color:Blue </<span style="color:#A31515 NodeChild<span style="color:Blue >
<span style="color:Blue </<span style="color:#A31515 NodeParent<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeParent <span style="color:Red Text<span style="color:Blue =<span style="color:Black "<span style="color:Blue Parent3<span style="color:Black "<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeChild<span style="color:Blue >Child1<span style="color:Blue </<span style="color:#A31515 NodeChild<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeChild<span style="color:Blue >Child2<span style="color:Blue </<span style="color:#A31515 NodeChild<span style="color:Blue >
<span style="color:Blue <<span style="color:#A31515 NodeChild<span style="color:Blue >Child3<span style="color:Blue </<span style="color:#A31515 NodeChild<span style="color:Blue ><span style="color:Blue <<span style="color:#A31515 br<span style="color:Blue />
<span style="color:Blue <<span style="color:#A31515 NodeChild<span style="color:Blue >Child4<span style="color:Blue </<span style="color:#A31515 NodeChild<span style="color:Blue ><span style="color:Blue <<span style="color:#A31515 br<span style="color:Blue />
<span style="color:Blue </<span style="color:#A31515 NodeParent<span style="color:Blue ><span style="color:Blue <<span style="color:#A31515 br<span style="color:Blue />
<span style="color:Blue <<span style="color:#A31515 Nodes<span style="color:Blue ><span style="color:Blue <<span style="color:#A31515 br<span style="color:Blue />
[/code]
My problem now is the xslt. That xml data must be transfer to excel with treeview like structure. So meaning for example
The parent1 will be in placed in A1 cell then its child will be place in B2,B3,B4 cell. im zero knowledge in xslt.
Need help
Thanks in advance.
<
mmb
View the full article