RE: [xsl] Excel Column Number To Column Name (XSLT 2.0)

Subject: RE: [xsl] Excel Column Number To Column Name (XSLT 2.0)
From: "Michael Kay" <mike@xxxxxxxxxxxx>
Date: Sun, 17 May 2009 20:22:33 +0100
> > Anybody already have this function?
> > 
> > 1 - A
> > 26 - Z
> > 27 - AA
> > and so on - limited only by excell
> 
>    <xsl:number format="A" value="$n"/>
> should do that I think.
> 

Or something similar. I think excel's "and so on" is BB, CC, DD whereas
xsl:number's is likely to be AB, AC, AD

Regards,

Michael Kay
http://www.saxonica.com/
http://twitter.com/michaelhkay 

Current Thread