> 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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287010 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
