2014
Pluralsight
Ken Getz
3h 44m
English

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

http://pluralsight.com/

Download File Size:612.36 MB

---