Subject: Re: Re: Producing Excel spreadsheet from XML data
From: "Thomas B. Passin" <tpassin@xxxxxxxxxxxx>
Date: Mon, 11 Jun 2001 11:36:16 -0400
|
[MacEwan, James]
> Thanks to all for your comments. I have summarized the responses (so far)
> below:
>
Thanks for giving us this summary. Much apprciated.
>
> My solution will probably be as follows: (1) no XSL transformation occurs
> on Unix (2) FTP the XML document to NT (3) write a VB program that
traverses
> the XML and writes interesting bits of data into the right spots into the
> Excel (COM that calls MSXML3 and Excel's automation interfaces).
>
Sounds like a good approach. Whether you have a separate VB program or use
VBS from within Excel won't be much different in practice, I believe.
Cheers,
Tom P
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|