Introduction to Microsoft Office Open XML

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 info
Rating
(100)
Level
Intermediate
Updated
Jan 22, 2014
Duration
3h 45m
Table of contents
Description
Course info
Rating
(100)
Level
Intermediate
Updated
Jan 22, 2014
Duration
3h 45m
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.

About the author
About the author

Ken Getz is a software developer and a founding partner with MCW Technologies, LLC. He has been providing instructor-led, video, and online training since 1993. He has written hundreds of technical articles, and produced many training videos for Microsoft over the years. When not being a geek, he spends his time playing the piano in local theaters.

More from the author
Custom VBA Class Development
Intermediate
3h 32m
Jun 27, 2014