comparison rect.xsl @ 13:f78e8c55c06b

three steps now
author Henry S. Thompson <ht@markup.co.uk>
date Mon, 03 Apr 2017 14:46:01 +0100
parents 01e125d722be
children 2bbd067529b6
comparison
equal deleted inserted replaced
12:01e125d722be 13:f78e8c55c06b
1 <?xml version='1.0'?> 1 <?xml version='1.0'?>
2 <!DOCTYPE doc SYSTEM "../../../lib/xml/xsl.dtd" > 2 <!DOCTYPE doc SYSTEM "../../../lib/xml/xsl.dtd" >
3 <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="3.0" xmlns:s="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:e="http://markup.co.uk/excel" exclude-result-prefixes="xs s xpf" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:xpf="http://www.w3.org/2005/xpath-functions"> 3 <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="3.0" xmlns:s="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:e="http://markup.co.uk/excel" exclude-result-prefixes="xs s xpf" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:xpf="http://www.w3.org/2005/xpath-functions">
4 <xsl:strip-space elements="s:sheetData"/>
4 5
5 <xsl:function name="e:a2n" as="xs:integer"> 6 <xsl:function name="e:a2n" as="xs:integer">
6 <!-- Convert an alphabetic excel column 'index' into a number, 7 <!-- Convert an alphabetic excel column 'index' into a number,
7 a sort of base 26 + 1, since 'A' is 1 and 'AA' is 27 --> 8 a sort of base 26 + 1, since 'A' is 1 and 'AA' is 27 -->
8 <xsl:param name="aa" as="xs:string"/> 9 <xsl:param name="aa" as="xs:string"/>