[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
Hey Lee
The trick to get excel to show the leading zero is to use = (for example if you were outputting to a table for excel...):
Hope this helps,
Ro.
_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Re: [xsl] XSL/XML to Excel
Subject: Re: [xsl] XSL/XML to Excel From: "Ronan Phelan" <ro_spod@xxxxxxxxxxx> Date: Thu, 23 Jan 2003 08:22:16 +1300 |
Hey Lee
The trick to get excel to show the leading zero is to use = (for example if you were outputting to a table for excel...):
<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=Content-Type content="text/html; charset=UTF-8"> <meta name=ProgId content=Excel.Sheet> </head> <table> <tr> <th>Name</th> <th>Username</th> <th>Address_1</th> <th>Address_2</th> <th>Address_3</th> <th>Address_City</th> <th>Address_Postcode</th> </tr> <tr> <td>MR A</td> <td>="012345"</td> <td>Stan</td> <td>Here St</td> <td>This Place</td> <td>Cristchurch</td> <td>="00125"</td> </tr> <tr> <td>Mrs B</td> <td>="000882"</td> <td>Fran</td> <td>Here St</td> <td>This Place </td> <td>Aukland</td> <td>="00126"</td> </tr> </table> </html>
Hope this helps,
Ro.
From: "Lee, Insoo" <Insoo.Lee@xxxxxx> Reply-To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx To: "'xsl-list@xxxxxxxxxxxxxxxxxxxxxx'" <xsl-list@xxxxxxxxxxxxxxxxxxxxxx> Subject: [xsl] XSL/XML to Excel Date: Wed, 22 Jan 2003 11:39:11 -0500
Not sure if this is the appropriate newsgroup, but any help would be appreciated. I'm using XSL to stylesheet XML and output it to html and excel and they work great. Only thing is for excel, I noticed that it drops all leading zeroes by default so that
<myTag>0000123</myTag> would show up 123 in excel cell in stead of 0000123
Any trick I can use in XSL to show it correctly in excel? Thanks
IL
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] XSL/XML to Excel, cknell | Thread | RE: [xsl] XSL/XML to Excel, Wilder, Bill FIIS |
Re: [xsl] dynamic construction of p, Oleg Tkachenko | Date | [xsl] how to match attributes in te, Alice Fan |
Month |