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.

01. Introduction to Microsoft Office Open XML
│ 01. Introduction.mp4
│ 02. Overview.mp4
│ 03. Motivating the Open XML File Formats.mp4
│ 04. Working with Word.mp4
│ 05. Working with Excel.mp4
│ 06. Working with PowerPoint.mp4
│ 07. Examining the Format.mp4
│ 08. Imagining Code to Retrieve Information.mp4
│ 09. Summary.mp4
│
├───02. Working with the Open XML SDK 2.5
│ 01. Introduction.mp4
│ 02. Overview.mp4
│ 03. SDK Contents.mp4
│ 04. SDK Demo.mp4
│ 05. Introducing the SDK Tool.mp4
│ 06. Demonstrate the SDK Tool.mp4
│ 07. SDK Tips.mp4
│ 08. Working with Excel.mp4
│ 09. Working with Word.mp4
│ 10. Summary.mp4
│
├───03. Using the Open XML SDK with Excel
│ 01. Introduction.mp4
│ 02. Assumptions and Warnings.mp4
│ 03. Introduce Retrieve Cell Value.mp4
│ 04. Retrieve Cell Value Demo.mp4
│ 05. Introduce Write Cell Value.mp4
│ 06. Write Cell Value.mp4
│ 07. Summary.mp4
│
├───04. Using the Open XML SDK with Word
│ 01. Introduction.mp4
│ 02. Assumptions and Warnings.mp4
│ 03. Introduce Retrieve Plain Text.mp4
│ 04. Retrieve Plain Text.mp4
│ 05. Introduce Create Table.mp4
│ 06. Create Table.mp4
│ 07. Summary.mp4
│
├───05. Using the Open XML SDK with PowerPoint
│ 01. Introduction.mp4
│ 02. Assumptions, Warnings, and Help.mp4
│ 03. Create and Examine Sample Presentation.mp4
│ 04. Introduce Retrieve All Text.mp4
│ 05. Retrieve All Text.mp4
│ 06. Introduce Modify Slide Title.mp4
│ 07. Modify Slide Title.mp4
│ 08. Summary.mp4
│
└───06. Using the Open XML SDK Summary
01. Introduction.mp4
02. Summary.mp4

Download File Size:612.39 MB

---