[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: XML data to MS-Excel??
>I want to convert my xml data to Ms-Excel can some one suggest me how to start? Output *just* the values of the nodes you want (without mark-up) into a TAB-delimited file - which you can then just import into Excel. Use <xsl:text>	</xsl:text> to create TABs. If you have missing or empty nodes in your source, you will have to maintain the column order of the output with something like: <xsl:choose> <xsl:when test="./YourNodeName"> <xsl:apply-templates/><xsl:text>	</xsl:text> </xsl:when> <xsl:otherwise><xsl:text>	</xsl:text></xsl:otherwise> </xsl:choose> Hope that helps, Matt H ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|