|
[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
[Recent Entries]
[Reply To This Message]
Re: XSL/XML to Excel
Subject: Re: 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/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
 |
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
| RSS 2.0 |
|
| Atom 0.3 |
|
|
Cart
