XMLTransorm() takes some XML and applies an XSLT Stylesheet to it, returning the transformed XML. An XSLT transformation will always output another XML document so XMLTransform() is not what you need.
A schema is a set of rules for a particular flavour of XML for it to validate against. I.e. XHTML has a schema and when you validate your XHTML web pages on W3C or the like, you are validating against that schema. I'd say you're only problem is getting that date to appear correctly. I've never exported XML to excel so I'm curious as to what your XML looks like. Could you post a sample? Dominic On 23/08/07, Dave Watts <[EMAIL PROTECTED]> wrote: > > > I want to make an xml file available to my clients that they > > can easily import into excel. I can generate the xml file no > > problem and it imports into excel pretty good, but some of > > the date fields give the little exclamation mark, because > > excel doesn't know them to be date fields. > > > > Do I use xmltransform to attach a stylesheet? I can use an > > xsd file and define the datatypes, but I am getting confused > > on the difference between a stylesheet and a schema and how > > to use xmltransform. This is my first foray into xml. > > What do you see if you export from Excel to XML? > > If you're generating the XML yourself, you don't need to transform it; > just > generate what you need in the first place. > > Stylesheets (CSS/XSL) are used to format or transform XML. Schemas are > used > to validate XML. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287013 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
