Introduction to Microsoft Office Open XML
Pluralsight
Course Summary
Learn to retrieve information from and to modify Office documents using Open XML, and the Open XML SDK. You don't need to open a copy of Microsoft Word, Excel, or PowerPoint to work with the documents. Instead, you can use the Open XML File Formats and the Open XML SDK to write code that interacts with the data in the documents.
-
+
Course Description
Working with data in Microsoft Office documents can be slow and error-prone if you rely on Automation. Starting with Office 2007, Microsoft introduced a new file format, the Open XML File formats, that stores the content of Microsoft Word, Excel, and PowerPoint documents in an XML-based structured set of folders inside a standard ZIP file. The Open XML File formats are easy to use, easy to view, and far easier to work with than the previous binary formats. The XML content is, however, somewhat daunting to manipulate programmatically, and Microsoft has released the Open XML SDK to make it simpler. This course focuses both on examining and understanding enough about the Open XML File formats to get you started, and shows several examples using the Open XML SDK with each type of supported document. You'll learn to both retrieve and modify data in an example for each type of document. By the time you're done with the course, you'll have a basic understanding of the tools you need, and the locations for finding help.
-
+
Course Syllabus
Introduction to Microsoft Office Open XML- 46m 15s
—Introduction 2m 17s
—Overview 4m 7s
—Motivating the Open XML File Formats 4m 32s
—Working with Word 4m 53s
—Working with Excel 6m 44s
—Working with PowerPoint 5m 20s
—Examining the Format 12m 52s
—Imagining Code to Retrieve Information 4m 50s
—Summary 0m 36sWorking with the Open XML SDK 2.5- 55m 48s
—Introduction 0m 18s
—Overview 4m 58s
—SDK Contents 3m 56s
—SDK Demo 11m 38s
—Introducing the SDK Tool 3m 34s
—Demonstrate the SDK Tool 12m 0s
—SDK Tips 3m 48s
—Working with Excel 7m 42s
—Working with Word 6m 42s
—Summary 1m 7sUsing the Open XML SDK with Excel- 46m 5sUsing the Open XML SDK with Word- 35m 56sUsing the Open XML SDK with PowerPoint- 35m 7sUsing the Open XML SDK Summary- 5m 36s