This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
Re: Re: Producing Excel spreadsheet from XML data
- To: <xsl-list at lists dot mulberrytech dot com>
- Subject: Re: [xsl] Re: Producing Excel spreadsheet from XML data
- From: "Thomas B. Passin" <tpassin at mitretek dot org>
- Date: Mon, 11 Jun 2001 11:36:16 -0400
- References: <DD3244BDF5B4D411BB9D0060948A3B630162BC7F@IGMAIL4>
- Reply-To: xsl-list at lists dot mulberrytech dot com
[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