[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Producing Excel spreadsheet from XML data

Subject: Producing Excel spreadsheet from XML data
From: "MacEwan, James (Information Services)" <James.MacEwan@xxxxxxxxxxxxxxxxxx>
Date: Fri, 8 Jun 2001 11:28:49 -0500
spreadsheet xmldata
Hi,

My question is of the general architectural type, similar to the one about
Quark yesterday.

I am investigating populating an Excel 97 spreadsheet with an XSLT
transformation of existing XML data.  I would like to produce the
spreadsheet file as an enhancement to an existing batch process on a (DONS
ASBESTOS SUIT) Unix server (ASBESTOS SUIT OFF).  

Similar to the answers about Quark, I suspect that an XSL solution that
directly produces a pretty, formatted spreadsheet will be really ugly if not
impossible under Unix.

Instead will I have to implement a three step process?  (1) call an XSL
script to transform my input XML into an output document (say a CSV text
file) that contains the desired data. (2) FTP the output document to my NT
server (3) write VBScript to import the output document into the pretty
Excel spreadsheet.

Does anyone have any comment on the appropriateness of the above approach?
Are there any better suggestions?

BTW:  I had a look at the Microsoft site at the Office XP product
http://msdn.microsoft.com/msdnnews/2001/may/Excel/Excel.asp
and it looks as though this version of Excel separates data from
presentation.  Is this true? 
If so then I could choose to do the XSLT processing on Unix to produce an
XML document.  My users are not likely to be on this version of Excel for a
long time, so it does not appear that I can take advantage of this
technology any time soon.

Thanks,


James MacEwan
Software Developer
Investors Group Inc.
mailto:James.MacEwan@xxxxxxxxxxxxxxxxxx
v: (204) 956-8515
f: (204) 943-3540


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.