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
(98)
Level
Intermediate
Updated
Jan 22, 2014
Duration
3h 44m
Table of contents
Description
Course info
Rating
(98)
Level
Intermediate
Updated
Jan 22, 2014
Duration
3h 44m
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
Section Introduction Transcripts
Section Introduction Transcripts

Working with the Open XML SDK 2.5
Hi. This is Ken Getz with Pluralsight, and this is the second of a set of modules introducing Microsoft Office Open XML. In this module we'll focus on working with the Open XML SDK 2. 5.

Using the Open XML SDK with Excel
Hi. This is Ken Getz with Pluralsight, and this course covers an Introduction to Microsoft Office Open XML. This module focuses specifically on using the Open XML SDK with Microsoft Excel. We'll look at ways to retrieve information from, and write information to cells in an Excel spreadsheet. These are just two in the millions of tasks you could take on using the Open XML SDK, and Microsoft Excel. And these are just representative of the kinds of things you can do using the Open XML SDK. The code we'll look at isn't completely bulletproof, it's just example code to show how you need to look at things in order to read and write values in Excel. There are a million different options, a million different settings, and all sorts of things you can do using the Open XML SDK, and the point of this demonstration is just to get you started working with data in Excel.

Using the Open XML SDK with Word
Hi. This is Ken Getz with Pluralsight. In this module, as part of the course on an introduction to Microsoft Office Open XML, we'll focus on using the Open XML SDK with Microsoft Word. You'll see how to retrieve information from a Word document, and how to write information back into a Word document. Everything you do with Word boils down to dealing with XML content, so we'll dig in to how the XML within a Word document allows you to work with paragraphs, runs, and text elements. It's not trivial, but as long as you're willing to dig into the XML, it all makes sense.

Using the Open XML SDK with PowerPoint
Hi. This is Ken Getz with Pluralsight, and in this module of the course Introduction to Microsoft Office Open XML, we'll be focusing on the intricacies of working with Open XML and PowerPoint. You may not think of yourself as a PowerPoint developer, but there are times when it's very helpful to be able to interact with the PowerPoint Data Store without having to load PowerPoint. Perhaps you want to retrieve a list of all the slides in a deck, or perhaps you want to modify the text in a slide, or insert a shape onto every slide into a presentation. You can do that using Open XML. We won't cover all those things here but at least we'll get you started interacting with PowerPoint programmatically using the Open XML SDK.

Using the Open XML SDK Summary
Hi. It's Ken Getz from Pluralsight, and it's time to put our little course on an Introduction to Microsoft Office Open XML to rest. In this summary module, we'll look at some of the things we've talked about, and summarize the places you can go to get some more help.