Edit & Continue with C#
Never met

Getting Data from Excel 2003

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.

Christian

Comments

Feed You can follow this conversation by subscribing to the comment feed for this post.

cheap beats by dr dre sales

beats by dre on sale for cheap beats by dre dr cool beats website

The comments to this entry are closed.