Monday, 20 April 2009

XSLT, text-transform:captialize and Excel workbooks

Quick note on parsing an Excel Workbook using XSLT. In this case, there was a requirement to transform a column of upper-case city names into capitalized city names in much the same style as using the text-transform:capitalize css property:

(This example put together with some significant guidance from this link: http://www.biglist.com/lists/xsl-list/archives/200509/msg00542.html)

Source XML document:


XSL Stylesheet:

1 comment:

- RJ - said...

I'm trying to go the other way - from HTML to XLS(X). Have you ever done an XSL transformation starting with raw HTML?