LIS 600 Independent Study
Transforming XML to Microsoft XML
Dr. Terry Brooks
Winter 2006

Tutorials:

Microsoft Word and WordprocessingML:

• Overview of XML in Word
• Create a hand-coded Microsoft Word XML (WordprocessingML) file
• Adding styles to WordprocessingML
• Transform a plain XML file to WordprocessingML using XSL
• Transform a specially-designed XML file to WordprocessingML using XSLT
• Harvesting all text from an existing Word document into plain text file
• Creating XML Templates in Word

Microsoft Excel and SpreadsheetML:

• Overview of XML in Excel
• Create a hand-coded SpreadsheetML file
• Transform a plain XML file to SpreadsheetML using XSLT
• Harvest from SpreadsheetML

Importing and Exporting XML with Access:

• Overview of XML in Access -- Importing and Exporting XML from Access

Resources:

Books:

Office 2003 XML by Evan Lenz, Mary McRae & Simon St. Laurent (2004)

Powering Office 2003 with XML by Peter G. Aitkien (2004)

XSLT: Mastering XML Transformations by Doug Tidwell (2001)

Online Resources:

MSDN XML Developer Center

Brian Jones Blog (Microsoft Office program manager working on XML formats)

• Intro to Word XML Part 1: Simple Word Document
• Intro to Word XML Part 2: Simple Formatting
• Intro to Word XML Part 3: Using Your Own Schema
• Intro to Word XML Part 4: Schema Validation
• Intro to Word XML Part 5: Opening custom XML
• Intro to Word XML Part 6: Locking down your XML structures
• Intro to Excel XML Part 1: Creating a Simple Table
• Intro to Excel XML Part 2: Displaying your Data