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:

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?