Re: XML to RTF

I hope this helps, I had no experience with XSL when I did this, so there
may be better ways of doing it. I think the most obvious answer for you is
to use XSL which will transform the XML data into something else, in this
case a HTML table, you'll notice all the HTML page information in the .xsl
file, this is where you output the data in the format you want. You can
probably do whatever you like with it, but I chose to output it as an HTML
table. From the HTML table I can right click on the it and export to excel
if I like.
If you move the files to a directory other than the c-root then put the
proper path into the .xml file for the style*** or it won't find it
correctly.

Best of luck,
Rick Francis



"Ilya Dyoshin" <zipito@xxxxxxx> wrote in message
news:dr84tg$1baa$1@xxxxxxxxxxxxxxxxxxxx
> Hi all
>
> There is an XML file, formed from dataset.
>
> I want to see this in the RTF-document like a set of tables.
> something like:
>
> Table1 name
> +------------------------+------------------------+--------------------+
> | Table1.Column1 name | Table1.Column 2 name | Table1.Column3 name|
> +------------------------+------------------------+--------------------+
> |Column1.Row1 data | column2.row1 data | column3.Row1 data |
> +------------------------+------------------------+--------------------+
> |Column1.Row2 data | column2.row2 data | column3.Row2 data |
> +------------------------+------------------------+--------------------+
>
> Table2 name
> +------------------------+------------------------+
> | Table2.Column1 name | Table2.Column 2 name |
> +------------------------+------------------------+
> |Column1.Row1 data | column2.row1 data |
> +------------------------+------------------------+
> |Column1.Row2 data | column2.row2 data |
> +------------------------+------------------------+
>
> and so on.
>
>
> Can someone give me code samples how to do it?
>
> Thanks all!


begin 666 clipdata.xsl
M/#]X;6P@=F5R<VEO;CTB,2XP(C\^#0H\>'-L.G-T>6QE<VAE970@#0H@(" @
M("!X;6QN<SIX<VP](FAT=' Z+R]W=W<N=S,N;W)G+S$Y.3DO6%-,+U1R86YS
M9F]R;2(-"B @(" @('9E<G-I;VX](C$N,"(^#0H\>'-L.F]U='!U="!M971H
M;V0](FAT;6PB+SX-"B @(#QX<VPZ=&5M<&QA=&4@;6%T8V@](B]R97-U;'1S
M970B/@T*(" @(" @/$A434P^#0H@(" @(" @(" \2$5!1#X-"B @(" @(" @
M(" @/%1)5$Q%/CPO5$E43$4^#0H\4T-225!4/@T*"0T*/"]30U))4%0^#0H@
M(" @(" @(" \+TA%040^#0H@(" @(" @(" \0D]$63X-"@D\5$%"3$4@8F]R
M9&5R/2(Q(B!724142#TB,S P)2(^( T*"3QT:&5A9#X-"@D)/'1D/E!R;VIE
M8W0@240\+W1D/@T*"2 @(" @(" @(" @(" @"3Q41#Y0<F]J96-T($YA;64\
M+U1$/@T*"2 @(" @(" @(" @(" @"3Q41#Y0<F]J96-T('-T871U<SPO5$0^
M#0H@(" @(" @(" @(" @( D)/%1$/DUA8VAI;F5.86UE/"]41#X-"B @(" @
M(" @(" @(" @"0D\5$0^4&5R8V5N="!#;VUP;&5T93PO5$0^#0H@(" @(" @
M(" @(" @( D)/%1$/E-U;6UA<GD@9FEL93PO5$0^#0H@(" @"0D\5$0^4G5N
M(%1I;64\+U1$/@T*(" @(" @(" @(" @(" )"3Q41#Y2=6X@1&%T93PO5$0^
M#0H)/"]T:&5A9#X-"@D@(" @(" @(" @/'AS;#IF;W(M96%C:"!S96QE8W0]
M(G)O=R(^( T*"0D\>'-L.G-O<G0@<V5L96-T/2)C;VQU;6Y;0&YA;64])W!R
M;VIE8W1I9"==(B O/B -"@D)(" @(" @(" @(" \5%(^( T*"0D)/%1$/CQX
M<VPZ=F%L=64M;V8@<V5L96-T/2)C;VQU;6Y;0&YA;64])W!R;VIE8W1I9"==
M(B O/CPO5$0^#0H)"0D\5$0^/'AS;#IV86QU92UO9B!S96QE8W0](F-O;'5M
M;EM ;F%M93TG<')O:F5C=&YA;64G72(@+SX\+U1$/@T*"0D)/%1$/CQX<VPZ
M=F%L=64M;V8@<V5L96-T/2)C;VQU;6Y;0&YA;64])W!R;VIE8W1S=&%T=7,G
M72(@+SX\+U1$/@T*"0D)/%1$/CQX<VPZ=F%L=64M;V8@<V5L96-T/2)C;VQU
M;6Y;0&YA;64])VUA8VAI;F5N86UE)UTB("\^/"]41#X-"@D)"3Q41#X\>'-L
M.G9A;'5E+6]F('-E;&5C=#TB8V]L=6UN6T!N86UE/2=P97)C96YT7V-O;7!L
M971E)UTB("\^/"]41#X-"@D)"3Q41#X\>'-L.G9A;'5E+6]F('-E;&5C=#TB
M8V]L=6UN6T!N86UE/2=S=6UM87)Y7V9I;&4G72(@+SX\+U1$/@T*"0D)/%1$
M/CQX<VPZ=F%L=64M;V8@<V5L96-T/2)C;VQU;6Y;0&YA;64])W)U;E]T:6UE
M)UTB("\^/"]41#X-"@D)"3Q41#X\>'-L.G9A;'5E+6]F('-E;&5C=#TB8V]L
M=6UN6T!N86UE/2=R=6Y?9&%T92==(B O/CPO5$0^#0H)"2 @(" @(" @(" @
M(" @/"]44CX-"@D@(" @(" @(" @/"]X<VPZ9F]R+65A8V@^#0H)/"]404),
M13X-"B @(" @(" @(#PO0D]$63X-"B @(" @(" \+TA434P^#0H@(" \+WAS
@;#IT96UP;&%T93X-"CPO>'-L.G-T>6QE<VAE970^#0H`
`
end

begin 666 testclipdata.xml
M/#]X;6P@=F5R<VEO;CTB,2XP(B!E;F-O9&EN9STB551&+3@B/SX-"CP_>&UL
M+7-T>6QE<VAE970@='EP93TB=&5X="]X<VPB(&AR968](F-L:7!D871A+GAS
M;"(_/@T*/"%$3T-465!%(')E<W5L='-E="!;#0H@(" @/"%%3$5-14Y4(')E
M<W5L='-E=" H<F5S=6QT<V5T9&%T82D@/@T*(" @(#PA14Q%345.5"!R97-U
M;'1S971D871A("AR;W<I*B ^#0H@(" @/"%%3$5-14Y4(')O=R H8V]L=6UN
M*2L@/@T*(" @(#PA14Q%345.5"!C;VQU;6X@*"-00T1!5$$I/@T*(" @(#PA
M05143$E35"!C;VQU;6X-"B @(" @(" @;G5L;" H=')U92!\(&9A;'-E*2 B
M9F%L<V4B#0H@(" @(" @(&YA;64@0T1!5$$@(TE-4$Q)140-"B @(" ^#0I=
M/@T*/')E<W5L='-E=#X-"B @(" \<F]W/@T*(" @(" @(" \8V]L=6UN(&YA
M;64](G!R;VIE8W1I9"(^-38\+V-O;'5M;CX-"B @(" @(" @/&-O;'5M;B!N
M86UE/2)P<F]J96-T;F%M92(^3F]N3F%M93$\+V-O;'5M;CX-"B @(" @(" @
M/&-O;'5M;B!N86UE/2)P<F]J96-T<W1A='5S(CY./"]C;VQU;6X^#0H@(" @
M(" @(#QC;VQU;6X@;F%M93TB;6%C:&EN96YA;64B/DA/55-%3T9#05)$4SPO
M8V]L=6UN/@T*(" @(" @(" \8V]L=6UN(&YA;64](G!E<F-E;G1?8V]M<&QE
M=&4B(&YU;&P](G1R=64B/CPO8V]L=6UN/@T*(" @(" @(" \8V]L=6UN(&YA
M;64](G-U;6UA<GE?9FEL92(^0SI<1&%T85PP,# P,#$Q-2XP,#%</"]C;VQU
M;6X^#0H@(" @(" @(#QC;VQU;6X@;F%M93TB<G5N7W1I;64B/C$Q.C P.C P
M+C P,#PO8V]L=6UN/@T*(" @(" @(" \8V]L=6UN(&YA;64](G)U;E]D871E
M(CXR,# U+3$P+3 T/"]C;VQU;6X^#0H@(" @/"]R;W<^#0H@(" @/')O=SX-
M"B @(" @(" @/&-O;'5M;B!N86UE/2)P<F]J96-T:60B/C4W/"]C;VQU;6X^
M#0H@(" @(" @(#QC;VQU;6X@;F%M93TB<')O:F5C=&YA;64B/DYO3F%M93PO
M8V]L=6UN/@T*(" @(" @(" \8V]L=6UN(&YA;64](G!R;VIE8W1S=&%T=7,B
M/DX\+V-O;'5M;CX-"B @(" @(" @/&-O;'5M;B!N86UE/2)M86-H:6YE;F%M
M92(^2$]54T5/1D-!4D13/"]C;VQU;6X^#0H@(" @(" @(#QC;VQU;6X@;F%M
M93TB<&5R8V5N=%]C;VUP;&5T92(^,3PO8V]L=6UN/@T*(" @(" @(" \8V]L
M=6UN(&YA;64](G-U;6UA<GE?9FEL92(^0SI<1&%T85PP,# P,#$Q-2XP,#%<
M/"]C;VQU;6X^#0H@(" @(" @(#QC;VQU;6X@;F%M93TB<G5N7W1I;64B/C$Q
M.C R.C(U+C P,#PO8V]L=6UN/@T*(" @(" @(" \8V]L=6UN(&YA;64](G)U
M;E]D871E(CXR,# U+3$P+3 T/"]C;VQU;6X^#0H@(" @/"]R;W<^#0H\+W)E
*<W5L='-E=#X-"@``
`
end

.

Quantcast