Lately I've posted about creating Word documents with XSLT. Office 2003 has another cool XML feature:
I needed data from an Excel sheet in a special format for processing. With XML schemas this can be done very easily:
- Create an XML schema
- With the Excel task pane (XML Source), the schema can be referenced by adding an XML map.
- Within the task pane the XML elements can be selected and moved to the corresponding Excel columns
- Save as XML data stores the data in an XML format that corresponds to the schema.
Now it's possible to transform the data as needed using XSLT.