There is a time for all good things to come to an end, and the time has come to shut down OpenXmlDeveloper.org.
Screen-casts and blog posts: Content on OpenXmlDeveloper.org will be moving to EricWhite.com.
Forums: We are moving the forums to EricWhite.com and StackOverflow.com. Please do not post in the forums on OpenXmlDeveloper.org. Instead, please post in the forums at EricWhite.com or at StackOverflow.com.
Please see this blog post for more information about my plans moving forward. Cheers, Eric
Office 2010 Sample: Open XML SDK 2.0 Code Snippets for Visual Studio 2010
Download this package to install the Open XML SDK 2.0 code snippets for use with Visual Studio 2010.
Level: 100Pages: 5Code: NoneMedia: Article
Open XML SDK Code Snippets
Summary of Open XML SDK Code Snippets
Open XML SDKCode Snippets
Level: 300Pages: 3Code: C#Media: Article
WordprocessingML Snippets: Part 1, utility snippets
This first article on working with the WordprocessingML snippets will go into the details of three snippets you can use to form a basic framework for handling WordprocessingML files. They provide basic plumbing code which you will need to perform the most common action.
Wouter van Vugt
Using Content Controls to give Semantic Meaning to Content in Open XML WordprocessingML Documents
Open XML SDKWordprocessingMLContent Controls
Level: 100Pages: 1Code: NoneMedia: Article
Word Content Control Toolkit
This toolkit makes binding content controls to XML data in your Word document as easy as a drag and drop.
Level: 100Pages: 2Code: NoneMedia: Article
Generating Open XML WordprocessingML Documents
This is a blog post series on parameterized Open XML WordprocessingML document generation.
Open XML SDKWordprocessingMLContent ControlsDOCX Generation
Level: 100Pages: Code: NoneMedia: Article
Content Control Toolkit
Describes 'Content Control Toolkit' developed by Microsoft's Matt Scott.
Using Nested Content Controls for Data and Content Extraction from Open XML WordprocessingML Documents
Level: 200Pages: 3Code: C#Media: Article
Matthew Scott: Application Development using the Open XML File Formats
In this video we talk with Matthew Scott, a developer on the Word team who takes us through the design and development of the Word 2007 Content Control Toolkit, an application that natively reads and writes Word documents saved in the Open XML file format. This application has been released to the developer community on Codeplex as an open source project, with full C# source code.
Level: 200Pages: Code: NoneMedia: Video
Linking Word 2007 Content Controls to Custom XML
Level: 200Pages: 5Code: NoneMedia: Article
Generating Open XML WordprocessingML Documents using XPath Expressions in Content Controls
Introduces the approach of configuring the document generation process by entering XPath expressions in content controls in a template document.
Level: 200Pages: 9Code: NoneMedia: Article
Introduces this blog post series on generating WordprocessingML documents, outlines the goals of the series, and describes various approaches that I may take as I develop some document generation examples.
Level: 200Pages: 2Code: NoneMedia: Article
Release V2 of Open XML document generation system
This post describes Eric White's release V2 of simple Open XML document generation system, a high-performance tool for generating customized documents from any data source that can be serialized as XML.
Level: 200Pages: 1Code: NoneMedia: Article
Dynamic production of repeating content controls by a WCF service
Briefly discusses architecture and issues in developing a WCF Service based parameterized Server-side document Generation System.
WordprocessingMLContent ControlsDOCX Generation
Content controls demo: invoice creation
Describes an application which demonstrates the use of content controls and custom XML to map data to each of these content controls in the word document.
Level: 200Pages: 3Code: NoneMedia: Article
Using Open XML to Improve Automation Performance in Word 2010 for Large Amounts of Data
Learn how to insert large amounts of data quickly by using Open XML. On a typical 4-GHz computer with a single processor, you can insert a 300-row table with an image in each cell by using a content control in less than five seconds. Using Word automation, this process takes much more than a minute.
Anil KumarAnsari MSarang DatyeSunil Kumar
Level: 300Pages: 11Code: C#Media: Article
Building Publishing Systems that Use Word 2010 or Word 2007
Using Word 2010 or Word 2007 as an important part of a content publishing system is a powerful approach. This article contains guidance and direction about how to build a content management system, and transforming Open XML WordprocessingML documents to other document formats.
Level: 300Pages: 6Code: C#Media: Article
Creating Data-Bound Content Controls using the Open XML SDK and LINQ to XML
Level: 300Pages: 13Code: C#Media: Article
Using LINQ to XML to Retrieve Content Controls in Word 2007
Content controls are an effective way to add structure to word processing documents. This post explains how to write a very small LINQ query to retrieve the contents of content controls.
Level: 300Pages: 4Code: C#Media: Article
Using DocumentBuilder with Content Controls for Document Assembly
DocumentBuilder is an example class that's part of the PowerTools for Open XML project that enables you to assemble new documents from existing documents. Document builder fixes up interrelated markup when assembling a new document from existing documents. This post shows how to use DocumentBuilder in concert with content controls to control the document assembly.
Open XML SDKDocument BuilderPowerToolsWordprocessingMLContent Controls
Level: 300Pages: 17Code: C#Media: Article
Generating Documents from SharePoint with Open XML Content Controls
I'll present some guidance and sample code for creating a document-generation system that uses SharePoint lists to populate tables in an Open XML word-processing document.
Open XML SDKWordprocessingMLSharePointContent ControlsDOCX Generation
Level: 300Pages: 16Code: C#Media: Article
Taking Advantage of Bound Content Controls
Learn how to leverage bound content controls to bind to custom XML.
Change the Schema for Simple Free Doc Generation System
Three minute screen-cast that demonstrates changing the schema for simple document generation system that you configure by placing XPath expressions in content controls.
Level: 300Pages: Code: C#Media: Article,Video
Release of V2 of Doc Gen System: XPath in Content Controls
In this post, I release V2 of this simple document generation example. I provide a 2-minute screen-cast that shows the document generation process, generating 3000 documents in less than 30 seconds.
Replacing a Picture in a Picture Content Control in an Open XML WordprocessingML Document
Shows code to replace a picture in a picture content control in an Open XML WordprocessingML document.
Level: 300Pages: 1Code: C#Media: Article
Changing the Schema for this Open XML Document Generation System
In the following screen cast shows the process of adjusting the XML data that drives the document generation system, as well as adjusting the template document to use that data.
Release of V1 of Simple DOCX Generation System
Eric White has developed a preliminary version of this simple DOCX generation system, which you can download, unzip, and try. This article lists two screen casts, first 90 second screen-cast shows how to run the doc gen system after you download and unzip the zip file.The second 2 1/2 minute video shows using the document generation system at scale. It shows generating 3000 documents in under a minute.
Video of use of Document Generation Example
Eric White has completed a rough first version of this document generation system that is driven by C# code that you write in content controls in a Word document. As an intro, he has recorded a small screen-cast that shows the doc gen system in action.
A Super-Simple Template System
This post details my super-simple template system, which will be more than adequate for building this first version of a doc gen system.
More Enhancements to the Document Template
Discusses enhancements that enable the template designer to write infrastructure code for the document generation process. Also discusses how the document generation process will work.
Level: 300Pages: 9Code: C#Media: Article
Using a WordprocessingML Document as a Template in the Document Generation Process
This post examines the approaches for building a template document for the document generation process. A template document is a DOCX document that contains content controls that will control the document generation process.
Copy table from WordprocessingML to SpreadsheetML
Open XML SDK, WordprocessingML, Content Controls
Level: 300Pages: 5Code: C#, XSLTMedia: Article
Iterating through all Content Controls in an Open XML WordprocessingML Document
Sometimes you want to iterate over all content controls in a WordprocessingML document. You may want to search for a content control with a specific tag, or you may want to process all content controls of a specific type. This blog post shows how to iterate over all content controls.
You may have a picture content control where you want to replace the picture with a different picture. This post shows the Open XML SDK V2 code that is necessary to find a picture content control with an alias of "MyPicture". It then finds the ImagePart, and then replaces the contents of the image part with a different image.
Level: 300Pages: 2Code: C#Media: Article
Digital Signature in WordprocessingML
This article explains about Digital Signature and how Digital Signature details are stored in Open XML file format in WordprocessingML.
Sheela E N
Level: 200Pages: 7Code: NoneMedia: Article
How to Sign the SignatureLine using Office Open XML
We can use PackageDigitalSignatureManager class available in System.IO.Packaging namespace to sign any part of an Open XML document. However, when we try to sign a document that has a signature line using this class, we will notice that though the document appears as signed, the signature line still appears as needs to be signed. In order to have the signature appear in the signature line, we will need to do some additional tasks which are mentioned in the resolution section below.
Generalized Approach to Open XML Markup References
Open XML SDKDocument BuilderPowerToolsWordprocessingML
Level: 200Pages: 4Code: NoneMedia: Article
Interrelated Markup in Open XML Word Processing Documents
Comparison of altChunk to the DocumentBuilder Class
This post compares and contrasts two approaches to assemble multiple Open XML word processing documents into a single document
Generating a document using PowerTools for Open XML and PowerShell
Level: Pages: 12Code: Media: Article
Automated Processing of Open XML Documents using PowerShell
Processing Open XML documents using PowerShell is a powerful approach for creating, modifying, and transforming Open XML documents. The PowerTools for Open XML are examples and guidance that show how to do this. They consist of PowerShell cmdlets, and a number of example scripts that demonstrate the use of the cmdlets. Examples include automated word processing document and spreadsheet generation, and preparing documents for distribution external to a company, including removing comments, accepting revisions, applying a uniform theme to them, and applying a watermark to them.
PowerToolsDOCX GenerationXLSX Generation
Generating a Word 2007 Document by Using PowerTools for Open XML and Windows PowerShell
Learn how to use PowerTools for Open XML and Microsoft Windows PowerShell to create a Microsoft Office Word 2007 document that contains property data from other Word 2007 documents.
Level: 300Pages: 16Code: C#Media: Article,Video
Building Document Generation Systems from Templates with Word 2010 and Word 2007
Some business scenarios require generation of many documents by using a template document and a data source. This article contains guidance for this scenario and links to MSDN articles and blog posts.
Level: 300Pages: 10Code: NoneMedia: Article
Server-Side Generation of Word 2007 Docs
Level: 300Pages: 12Code: VBMedia: Article
Creating Documents by Using the Open XML Format SDK 2.0 (Part 1 of 3)
Explore the architecture and advantages of using the Open XML Format SDK 2.0 (CTP). Additionally, see in-depth scenarios of how to assemble and manipulate data in Microsoft Office Excel 2007 workbooks, Microsoft Office PowerPoint 2007 presentations, and Microsoft Office Word 2007 documents by using the Open XML Format SDK APIs.
Zeyad RajabiFrank Rice
Level: 300Pages: 8Code: C#Media: Article
Generating Documents with Headers and Footers in Word 2007 by Using the Open XML SDK 2.0 for Microsoft Office
Learn how to use the Open XML Software Development Kit 2.0 for Microsoft Office to programmatically create Word 2007 documents that contain headers and footers.
Open XML SDKWordprocessingMLDOCX Generation
Level: 300Pages: 11Code: C#Media: Article,Video
Building Server-Side Document Generation Solutions Using the Open XML Object Model (Part 1 of 2)
Learn the basics of the Open XML architecture and WordprocessingML. Discover the advantages of creating document packages and manipulating document parts by using the new Open XML object model.
Level: 300Pages: 7Code: VB,C#Media: Article
Building Server-Side Document Generation Solutions Using the Open XML Object Model (Part 2 of 2)
In this second part of a two-part series, continue to explore the architecture of a server-side document integration solution. Discover the advantages of creating document packages and manipulating document parts by using the new Open XML object model.
Generating Dynamic OpenXML Docx Files
Covers the design of a set of classes for working with Open XML documents. This approach reflects a common business need: set up a standardized look and feel in a template, which can be used as a starting point for generating dynamic data-driven documents that all share common formatting characteristics.
Mohammad Nour El-din Marwan
Level: 300Pages: 5Code: C#Media: Article
Module 05: Custom XML
DrawingML is extremely complex, a huge topic.
In this PowerPoint presentation we'll focus on the things you're most likely to use, and leave other details for your own research later if desired.
Level: 200Pages: 43Code: NoneMedia: Ppt
Technical Analysis between DrawingML and Scalable Vector Graphics(SVG)
The attached white paper broadly describes how DrawingML is different from Scalable Vector Graphics (SVG) in terms of design goals, target audience and the problem areas intended to address.
DrawingML implementation for Image/Picture in SpreadsheetML
This article explains the DrawingML implementation in Spreadsheet and how a drawing object is stored in SpreadsheetML using DrawingML.
Changing chart type in a SpreadsheetML document
This article explains the process of changing type of chart in a SpreadsheetML document programmatically using Open XML SDK API.
Transforming Open XML Documents using XSLT
The Flat OPC Format
Transforming Open XML documents using XSLT is an interesting scenario, but before we can do so, we need to convert the Open XML document into the Flat OPC format. We then perform the XSLT transform, producing a new file in the Flat OPC format, and then convert back to Open XML (OPC) format. This post is one in a series of four posts that present this approach to transforming Open XML documents using XSLT.
Transforming Open XML Documents to Flat OPC Format
Transforming Flat OPC Format to Open XML Documents
What's so open about Open XML? Part 1
What's so open about Open XML? How does it represent a major shift in the way some Office applications construct and store data? What are the implications of Open XML on interoperability (do you even need Office to open an Open XML-based Office document)?
Level: 100Pages: Code: Media: Video
What's so open about Open XML? Part 2
Binary(doc,xls,ppt) to OpenXMLTranslator
The main goal of the Office Binary (doc, xls, ppt) Translator to Open XML Project is to create software tools, plus guidance, showing how a document written using the Binary Formats (doc, xls, ppt) can be translated to Office Open XML.
Open XML File Format Converter for Mac 1.0
Open XML Converter allows you to convert Open XML files that were created in Office 2008 for Mac or Office 2007 for Windows so that you can open, edit, and save them in earlier versions of Office for Mac.
Translating OpenXML into DAISY
The first alpha build of the OpenXML to DAISY translator is available up on SourceForge.
Level: 100Pages: 2Code: NoneMedia: Artilce
Open XML support on Apple iPhone
Simple demo showing how to view Open XML document (.DOCX & .XLSX ) on Apple iPhone
Level: 100Pages: Code: NoneMedia: Video
Open Specifications Interactive Pivot
Silverlight pivot that enables exploring of all the content on the Open Specifications site.
Level: 100Pages: Code: NoneMedia:
Beginning WordprocessingML is a self-directed learning module that helps the reader understand the syntax and structure of WordprocessingML, which is defined in the ISO/IEC 29500 Office Open XML File Formats (Open XML) standard.
Level: 100Pages: Code: C#Media: Article, Video
Beginning SpreadsheetML is a self-directed learning module that helps the reader understand the syntax and structure of SpreadsheetML, which is defined in the ISO/IEC 29500 Office Open XML File Formats (Open XML) standard.
Level: 100Pages: Code: Media: Article, Video
Beginning PresentationML is a self-directed learning module that helps the reader understand the syntax and structure of PresentationML, which is defined in the ISO/IEC 29500 Office Open XML File Formats (Open XML) standard.
Linux/Java interoperability with Open XML
The sample application is running on a Linux server (in a VPC for this demo). The user connects to this server from a Vista/IE machine, makes a few selections, and creates a DOCX that gets passed back to the client. The user then makes changes in Word 2007 and uploads their modified version to the Linux server, where Java code runs to extract the revision-tracking history and show the document's changes through a browser interface.
Intermediate WordprocessingML is a self-directed learning module that helps you advance their knowledge of the syntax and structure of WordprocessingML, which is defined in the ISO/IEC 29500 Office Open XML File Formats (Open XML) standard. This module builds on the concepts presented in Beginning WordprocessingML.
Level: 200Pages: Code: Media: Article, Video
Intermediate SpreadsheetML is a self-directed learning module that helps you advance your knowledge of the syntax and structure of SpreadsheetML, which is defined in the ISO/IEC 29500 Office Open XML File Formats (Open XML) standard. This module builds on the concepts presented in Beginning SpreadsheetML.
Intermediate PresentationML is a self-directed learning module that helps you advance your knowledge of the syntax and structure of PresentationML, which is defined in the ISO/IEC 29500 Office Open XML File Formats (Open XML) standard. This module builds on the concepts presented in Beginning PresentationML.
Using PHP and XSLT to Create a Word 2007 Document
Learn how to use PHP to transform XML data into the Open XML format.
InteroperabilityXSLTOpen XML SDKWordprocessingML
Level: 300Pages: 10Code: PHPMedia: Article,Video
Creating an Open XML spreadsheet in PHP
This article covers the dynamic creation of invoices using PHPExcel (www.codeplex.com/phpexcel). It covers the example code 05featuredemo.php which can be found in the PHPExcel package project on Codeplex.
Level: 300Pages: 5Code: PHPMedia: Article
Advanced WordprocessingML is a self-directed learning module that helps increase your knowledge of WordprocessingML, which is defined in the ISO/IEC 29500 Office Open XML File Formats (Open XML) standard. This module builds on the concepts presented in Beginning WordProcessingML and Intermediate WordprocessingML.
Level: 300Pages: Code: Media: Article, Video
Advanced SpreadsheetML is a self-directed learning module that helps you build your knowledge of SpreadsheetML, which is defined in the ISO/IEC 29500 Office Open XML File Formats (Open XML) standard. This guide builds on the concepts presented in Beginning SpreadsheetML and Intermediate SpreadsheetML.
Advanced PresentationML is a self-directed learning module that helps you build your knowledge of PresentationML, which is defined in the ISO/IEC 29500 Office Open XML File Formats (Open XML) standard. This guide builds on the concepts presented in Beginning PresentationML and Intermediate PresentationML.
Introducing Open XML
This video introduces you to the interoperability of documents and the Open XML file formats. It also discusses the benefits of using Open XML.
Office Open XML and the ECMA-376 Specification
This article contains a brief overview of Office Open XML (Open XML), explains its uses, and helps the reader become familiar with the ECMA-376 Office Open XML File Formats specification that defines Open XML.
Level: 100Pages: 6Code: NoneMedia: Article
Open XML Package Editor Power Tool for Visual Studio 2010
Office Open XML I: Exploring the Office Open XML Formats
The new Office Open XML Formats provide a wide range of functionality in the 2007 Office system programs and can help you reduce file size, improve document security, and troubleshoot problem documents far more easily than ever before. In this course, the first in a series of three, learn the basics of working with these new file formats and get an introduction to the XML structure behind your documents.
Level: 100Pages: Code: Media: Article
Information about how to work with Open XML Format files in Microsoft Office 2004 for Mac
Level: 100Pages: 9Code: NoneMedia: Article
Why Open XML?
Significance of Open XML.
Open XML as a Standard
This Power Tool is a Visual Studio add-in that provides an easy way to parse and edit Open Packaging Conventions files, including Word, Excel and PowerPoint documents. This Power Tool enables you to do the following tasks:
Open XML SDK 2.0 RTM is live! Find Articles, Videos, Code Samples, and Resources on MSDN
Level: 100Pages: 8Code: NoneMedia: Article
This post will represent the most up-to-date blog map for topics on the Open XML SDK.
IntroductionOpen XML SDK
Level: 100Pages: 13Code: NoneMedia: Article
Open XML support in new tools, apps, and custom solutions
Level: 100Pages: 4Code: NoneMedia: Article
Open XML development videos
Doug Mahugh interviewed several of the most active contributors to OpenXmlDeveloper. The videos are up on Channel 9 and the links included in article.
MSDN Articles on Open XML and Related Topics
The following is an overview of some of the Open XML information that is available on MSDN, including general XML resources, information about Open XML development, and documentation of Microsoft schemas that can be used with Open XML due to its flexible support for custom schemas.
Open XML Explained e-book
This article has attached downloadable copyof "Open XML Explained" by Wouter Van Vugt, the first book on Open XML development. The sample documents for the book are also available for download.
Open XML Architecture
This video drills into the architecture of Open XML, file formats packaging, file extensions, reference and custom schemas and how to manage data using Open XML.
Level: 200Pages: Code: Media: Video
Seven Key Benefits of Open XML
TechNet Radio - Open XML Formats in Office 2007
How Open XML Formats are intended to be standard file formats to which any Developer or Implementer will have access, key aspects of the modular architecture, why Microsoft chose to standardize the Open XML Formats, and how the design of the Open XML Format makes solution development much simpler than it's been in the past.
Jon Udell: Brian Jones on Office XML
Brian Jones has been working on infusing XML smarts into Office for six years. In this episode we discuss the history of, the current status of, and future prospects for XML-enabled Office applications.
Module 00: Open XML Architecture
In this Presentation, we will learn about the architecture of the Office Open XML formats.
Primary focus is on concepts that apply to all three main document types.
Level: 200Pages: 30Code: NoneMedia: Ppt
Introduction to the Open XML Module
Donovan and Chris provide a brief introduction to Open XML.
A conversation with Doug Mahugh about his OOXML world tour
Office Open XML evangelist Doug Mahugh has visited more places in the past few months than many folks see in a lifetime.
In this conversation we talk about the skills, interests, and concerns of Office developers around the world, and about some of the applications they're creating.
Office Open XML enables round-trip interoperability between Word 2007 and Mindjet's MindManager
In this screencast, Mindjet's Michael Scherotter demonstrates a solution that deeply integrates a MindManager map with Word 2007.
Independent Implementations of Open XML
Line shape details in SpreadsheetML documents
This article explains how line properties (like color, width, and head/tail etc.) and details of line shape are represented in DrawingML language within drawing part stored in SpreadsheetMLdocument.
Chhavi Kumar Agrawal
Level: 200Pages: 6Code: NoneMedia: Article
How to Solve Open XML Developer Problems
Article contains screen-cast that shows the general approach that could be used to solve Open XML developer problems. The general gist of the approach is to create two documents, one without the feature of interest, and one with. Then use the Open XML SDK productivity toolto compare the two and find out the differences.
Level: 200Pages: Code: NoneMedia: Article,Video
Open XML Demos
Open XML Demo Pack is a project containing 8 innovative scenarios where you can use Office Open XML File Formats. Each scenario is implemented in a Demo/Proof-of-concept way to show the feasibility. If you are interested in any scenario, you can download the source code and try in your machine. You can also copy and paste any part of the source code, since its licenced under MS-PL.
Level: 300Pages: Code: JavaMedia: Article
Introducing the Office (2007) Open XML File Formats
Learn the benefits of the Office Open XML Formats. Users can exchange data between Office applications and enterprise systems using XML and ZIP technologies. Documents are universally accessible. And, you reduce the risk of damaged files.
Level: 300Pages: 26Code: VBMedia: Article
How to: Manipulate Office Open XML Formats Documents
Office Open XML Formats files replace legacy binary Office system files. Learn about the components that are included in a formatted file and about several scenarios that show the versatility of these files.
Level: 300Pages: 25Code: VB,C#Media: Article
Using Office Open XML Formats to Support Electronic Health Records Portability and Health Industry Standards
Use Office Open XML Formats and HL7 CDA to exchange health data securely using industry standard formats.
Ted PattisonChris PredeekWouter van Vugt
Level: 300Pages: 24Code: C#Media: Article
Create DOCX Sample Program
This post covers a very simple program for creating an Office Open XML word-processing document.
Open-source Open XML API for Java
Julien Chable has been working on an open-source API project that would give Java developers a tool for rapid development of Open XML solutions. Since the Java environment doesn't have the .NET Framework 3.0 packaging API (System.IO.Packaging) to support the low-level details, the first phase of this project is to clone the packaging API in Java, which is an ambitious task. Nonetheless, Julien has already delivered the basics of iterating through package parts and writing documents, and he is now looking for contributors to expand the project significantly in the months ahead.
Open XML made easier for Java developers with Apache POI
For Java developers and Microsoft Office file formats there's a very interesting solution with the Apache POI project, which provides a Java API to access Microsoft Office formats.
Level: 300Pages: 9Code: JavaMedia: Articles
Deleting Comments from Word document using Core Java
This article explains about how to delete comments from the WordprocessingML document using Core Java
Level: 300Pages: 7Code: JavaMedia: Article
Removing macro from WordprocessingML document using Java
This article describes how to remove macro related details from the existing macro enabled word document using core Java.
Level: 300Pages: 8Code: JavaMedia: Article
OpenXML Content Types in an XML Document
Native Code Open Packaging Convention APIs
Level: 100Pages: 1Code: NoneMedia: Artilce
More Open XML Solution Tools
Shares information on two useful tools developers can leverage when building Open XML solutions. The first tool is PowerTools for Open XML.Second is Win32 version of System.IO.Packaging called WinOPC.
Essentials of the Open Packaging Conventions (OPC), and other Open XML Links
This article presents the basics that you need to know about Open Packaging Conventions if you are building applications using the Open XML SDK or System.IO.Packaging.
Package Explorer for Open XML
You can work with OPC packages (as used by Open XML, XPS, and various other formats) using simple tools such as WINZIP and Notepad, but if you're trying to be productive you'll find that approach tedious.If you want a better tool for this kind of work, and one that can also validate the parts within an OPC package or handle other common Open XML development chores, look no further: Package Explorer is what you want, and it's an open-source project on Codeplex so you can get it with full source code.
Module 02: Open XML Packages, Parts and Relationships
Introduction to the Open Packaging Convention.
Working with System.IO.Packaging
Level: 200Pages: 40Code: NoneMedia: Ppt
libOPC version 0.0.1 released
The first release of libOPC, a new API for Open XML development, was published on Codeplex last week. This API is the first open-source cross-platform API for developers working with Open Packaging Convention (OPC) packages as used by Open XML, XPS, and other formats
Essentials of the Open Packaging Conventions
Understanding Open Packaging Conventions is key to working with Open XML. Review the structure and learn about the underlying architecture. Compare the different approaches to working with the Open Packaging Conventions and the Open XML Formats
Retrieving Content from Different Parts: Explicit or Implicit Relationships in the Open XML SDK 2.0 for Microsoft Office
How to use the Open XML Software Development Kit 2.0 for Microsoft Office to retrieve content from a Microsoft Office Word 2007 document programmatically by using explicit and implicit relationships
Open XML SDKOPC
Working with In-Memory Open XML Documents
Working with Open XML Documents without loading from a file or saving to a file is important when you build applications that work with Microsoft SharePoint Server 2010 or Microsoft ASP.NET Web applications. In addition, some interesting scenarios benefit from creating an in-memory copy of an existing document. Learn how to create and work with in-memory copies of Open XML documents.
Open XML SDKOPCSharePoint
How to Create a List of All Parts in an Open XML Document
Sometimes you want to work with Open XML documents in memory. This blog post presents a bit of code that shows how to work with in-memory documents as a MemoryStream.
Comparison of Navigating Parts between System.IO.Packaging and the Open XML SDK
Creating a Template Open XML Document in Memory
Using the Open XML SDK from within a Managed Add-In
Open XML SDKWordprocessingML
Determining if an Open XML WordprocessingML Document contains Tracked Changes
Using Open XML WordprocessingML Documents as Data Sources
You can use Microsoft Office 2010 or the 2007 Microsoft Office system as part of a comprehensive collaboration system. You can send preformatted documents to your customers and extract data and content from those documents after they are returned. This article contains guidance and links to other resources to help you get started.
Level: 100Pages: 3Code: NoneMedia: Article
Formats Supported for altChunk
This post lists formats supported for imported content by the altChunk importing functionality of Word.
ARCast.TV - Building an Integrated Office Solution Using Word, OpenXML and SharePoint 2010
Building an Integrated Office Solution Using Word, OpenXML and SharePoint 2010
Jawa BuddhavarapuMurali Bala
Open XML SDKWordprocessingMLSharePoint
Open XML SDK 2.0 for Microsoft Office
This download provides strongly typed part and content classes for use with Open XML documents.
Open XML SDK
Open XML Format SDK 1.0
This download provides strongly typed part classes for use with Open XML documents. This download is scheduled for removal; a more recent version (Open XML SDK 2.0 for Microsoft Office) is available. See the link in the Overview section.
Open XML at TechEd 2010
Open XML was a big part of my first session at TechEd 2010 called, "Office 2010: Developing the Next Wave of Productivity Solutions". The thing that gets the biggest reaction is the Open XML SDK 2.0 "Productivity Tool"-- especially the ability to reflect over an Office document to produce C# code that will produce the target document.
John R. Durant
Level: 100Pages: 2Code: NoneMedia: Article,Video
Working with Animation
This topic discusses the Open XML SDK 2.0 Animate class and how it relates to the Open XML File Format PresentationML schema.
Open XML SDKPresentationML
Tutorial: Manipulating Content in a WordprocessingML Document
This tutorial shows how to apply the functional transformational approach and LINQ to XML to manipulate XML documents. The C# and Visual Basic examples query and manipulate information in Office Open XML WordprocessingML documents that are saved by Microsoft Word.
Open XML SDK Documentation
The Open XML Format SDK 2.0 is a superset of the Open XML SDK 1.0. In addition to the functionality provided by the Open XML SDK 1.0, it leverages.NET Language-Integrated Query (LINQ) and provides classes to construct and query the contents of parts within a package. You can use functional construction for composing documents, and LINQ queries for extracting information from documents.
Writing Semantically Aware LINQ Queries Against Excel Tables
Learn how to write a generic LINQ query that can work against any data source, including an Excel table.
Open XML SDKSpreadsheetML
Open XML and Office Services
Summary of Open XML and Office Services
Open XML SDKSharePoint
Level: 100Pages: 3Code: NoneMedia: Artilce
WordprocessingML Document Model
Open XML Tools and APIs
This video provides guidance on the tools and APIs available for Open XML. The Open XML SDK is provided by Microsoft but other tools are also available from the community and are discussed here.
Getting Started with the Open XML SDK 2.0 for Microsoft Office
This article explains how to add references to DLLs in OpenXML SDK after OpenXML SDK is installed.
Retrieving the Table of Contents from Word 2010 Documents Using Open XML SDK 2.0
Use the strongly typed classes in the Open XML SDK 2.0 to retrieve an XML block that contains the TOC from Open XML document.
Level: 200Pages: 8Code: VB,C#Media: Article,Video
Adding Table to Word 2010 Documents by Using the Open XML SDK 2.0
Use the strongly typed classes to add a simple table to a Word document.
Level: 200Pages: Code: VB,C#Media: Article,Video
Deleting Comments by all or a Specific Author in Word 2010 Documents by Using the Open XML SDK 2.0
Use the strongly typed classes in the Open XML SDK 2.0 to delete comments by all or specific authors in a Word document, without loading the document into Microsoft Word.
Level: 200Pages: Code: C#Media: Article,Video
Deleting Headers and Footers from Word 2010 Documents by Using the Open XML SDK 2.0
Use the strongly typed classes in the Open XML SDK 2.0 to delete all headers and footers in a Microsoft Word document, without loading the document into Word.
Level: 200Pages: 7Code: VB,C#Media: Article,Video
Replacing the Styles Parts in Word 2010 Documents by Using the Open XML SDK 2.0
Use the strongly typed classes in the Open XML SDK 2.0 to replace the styles in a Word document with an XDocument instance that contains the styles or stylesWithEffects part from a Microsoft Word document, without loading the document into Word.
Level: 200Pages: 4Code: VB,C#Media: Article,Video
Extracting Styles from Word 2010 Documents by Using the Open XML SDK 2.0
Use the strongly typed classes in the Open XML SDK 2.0 to retrieve an XDocument instance that contains the styles or stylesWithEffects part from a Microsoft Word document, without loading the document into Word.
Deep Dive Open XML and the Open XML SDK
Using Open XML 2.0 you can create and edit documents on the server without needing to resort to COM-based Office automation. This session presents a basic understanding of how to use Open XML 2.0 for creating documents, spreadsheets, and presentations. It also describes how to use the Open XML SDK and other various tools to make your development life easier. This session provides everything you need to start building document automation processes.
Level: 200Pages: Code: C#Media: Video
Inserting Content That Contains Images Using altChunk
Table Markup in Open XML SpreadsheetML
This post presents a summary of the Open XML SpreadsheetML markup that you use to define or query a table.
Level: 200Pages: 7Code: Open XMLMedia: Article
Open XML SDK CTP Released - What is it?
Chris Bryant is a Senior Product Manager on the Office Platform team (and Darth Vader fan). Here, we chat about the Open XML SDK, what it means for Office developers, general purpose programmers, mom and pop. We also touch on why Open XML is interesting.
Building Word 2007 Documents Using Office Open XML Formats
The Office Open XML Formats are based on XML and ZIP archive technologies. The new file format in Microsoft Office Word 2007 divides the file into document parts, each of which defines a part of the overall contents of the file. You can easily create, change, add, or delete data in a Word 2007 file programmatically or manually.
Erika EhrliZeyad Rajabi
Level: 200Pages: 9Code: NoneMedia: Article,Video
Exploring Margins in Open XML WordprocessingML Documents
Article has a short screen-cast that shows the markup for various ways of setting margins - for cells, paragraphs, and sections. In addition, the video shows general approach for researching Open XML markup.
In-Depth Exploration of WordprocessingML Fields
First video in a two-part series that explains how field markup works.
How to Create Protected Spreadsheets with Locked and Unlocked Cells
Article has a 7-minute video which shows markup related to protected sheets with locked and unlocked cells.
Open XML Presentation Generation using a Template Presentation
Article discusses an approach of creating an Open XML template presentation that you can use to generate multiple presentations from data.
Open XML SDKPresentationMLPPTX Generation
Level: 200Pages: 4Code: C#Media: Article,Video
Searching for Content in Word 2007 Documents by Using the Open XML SDK 2.0 for Microsoft Office
Learn how to use the typesafe classes and enumerations that are in the Open XML Software Development Kit (SDK) 2.0 for Microsoft Office to find paragraphs in a Microsoft Office Word 2007 document by style name or content. In addition, view and compare sample code that uses two different ways to accomplish the task; one by using the Open XML Format SDK 2.0 classes, and the other by using .NET Language Integrated Query for XML Data (XLINQ).
Level: 300Pages: 19Code: C#Media: Article,Video
Using XSLT and the Open XML SDK 2.0 to Create a Word 2007 Document
Learn how to transform XML data into a Word 2007 document by starting with an existing document that has the desired layout.
Open XML SDKXSLT
Level: 300Pages: 12Code: C#Media: Article,Video
Using the SharePoint Foundation 2010 Managed Client Object Model with the Open XML SDK 2.0
The Microsoft SharePoint Foundation 2010 managed client object model enables you to write applications that are based on the Microsoft .NET Framework that access SharePoint content from clients without installing code on the server that runs SharePoint Foundation 2010. By using these two technologies together you can write client-side applications that work with Open XML documents that are stored in document libraries.
Level: 300Pages: 10Code: C#Media: Article
Creating Form Letters in Word 2010 by Using Bookmarks and Office Open XML Files
Learn how to automatically populate bookmarks in Word to create documents such as form letters.
Level: 300Pages: 12Code: C#Media: Article
Connecting PivotTables in Excel 2007 to Data Stored in SharePoint Lists
Learn how to use the Open XML SDK 2.0 to create Microsoft Office Excel 2007 PivotTables that are connected to data stored in SharePoint lists.
Level: 300Pages: 18Code: C#Media: Article
Transforming Open XML WordprocessingML to XHTML Using the Open XML SDK 2.0
Identifying Open XML Word-Processing Documents with Tracked Revisions
Determining whether an Open XML WordprocessingML document contains tracked revisions is important. You can significantly simplify your code to process Open XML WordprocessingML if you know that the document does not contain tracked revisions. This article describes how to determine whether a document contains tracked revisions.
Level: 300Pages: 10Code: VB,C#Media: Article
Mastering Text in Open XML WordprocessingML Documents
Understand how to reliably retrieve text from Open XML WordprocessingML documents.
Level: 300Pages: 31Code: C#Media: Article
Developing with SharePoint 2010 Word Automation Services
Learn to use Word Automation Services to do server-side document conversions to and from a variety of document formats. By using the Open XML SDK, you can accomplish tasks that are difficult such as updating the table of contents or repaginating documents.
Eric WhiteTristan DavisZeyad Rajabi
Open XML SDKSharePointWordprocessingML
Level: 300Pages: 27Code: VB,C#Media: Article
Inserting a Header or Footer into an Excel 2010 Workbook by Using the Open XML SDK 2.0
Use strongly typed classes in the Open XML SDK 2.0 for Microsoft Office to insert a new header or footer into a Microsoft Office or Microsoft Excel 2010 document, without loading the document into Excel.
Level: 300Pages: 15Code: VB,C#Media: Article,Video
Retrieving the Values of Cells in Excel 2010 Workbooks by Using the Open XML SDK 2.0
Use the strongly-typed classes in the Open XML SDK 2.0 to retrieve the value of a cell in an Excel 2007 or Excel 2010 document, without loading the document into Microsoft Excel.
Level: 300Pages: 8Code: VB,C#Media: Article,Video
Setting Custom Properties in Word 2010 Documents by Using the Open XML SDK 2.0
Use strongly typed classes in the Open XML SDK 2.0 to modify custom document properties in a Word 2007 or Word 2010 document, without loading the document into Microsoft Word.
Creating Open XML WordprocessingML Tables with Vertically Merged Cells
Learn to create tables with vertically-merged cells in Open XML WordprocessingML documents.
Level: 300Pages: 15Code: C#Media: Article
Retrieving Lists of Hidden Rows or Columns in Excel 2010 Workbooks by Using the Open XML SDK 2.0
Use strongly typed classes in the Open XML SDK 2.0 to retrieve a list of hidden rows or columns in a Microsoft Excel 2007 or Excel 2010 worksheet, without loading the document into Excel.
Level: 300Pages: 12Code: VB,C#Media: Article,Video
Converting Word 2010 Documents from the DOCM to DOCX File Format by Using the Open XML SDK 2.0
Use the strongly typed classes in the Open XML SDK 2.0 to convert a Word document including VBA code (with a DOCM extension) to a standard document (with a DOCX extension), without loading the document into Microsoft Word.
Level: 300Pages: 6Code: VB,C#Media: Article,Video
Reordering Slides in PowerPoint 2010 Presentations by Using the Open XML SDK 2.0
Use the strongly typed classes in the Open XML SDK 2.0 for Microsoft Office to reorder slides in a Microsoft PowerPoint 2010 document given the old and new positions, without loading the document into PowerPoint.
Retrieving Dictionaries of All Named Ranges in Excel 2010 Workbooks by Using the Open XML SDK 2.0
Use strongly typed classes in the Open XML SDK 2.0 to retrieve a Dictionary that contains the names and ranges of all defined names in an Excel workbook, without loading the document into Microsoft Excel.
Level: 300Pages: 7Code: VB,C#Media: Article,Video
Deleting Comments by all or a Specific Author in PowerPoint 2010 Documents by Using the Open XML SDK 2.0
Use the strongly typed classes in the Open XML SDK 2.0 for Microsoft Office to delete comments by all or specific authors in a PowerPoint document, without loading the document into PowerPoint.
Changing the Print Orientation of Word 2010 Documents by Using the Open XML SDK 2.0
Use the strongly typed classes in the Open XML SDK 2.0 to specify the print orientation for a Word document, without loading the document into Microsoft Word.
Level: 300Pages: 9Code: VB,C#Media: Article,Video
Creating and Publishing Excel 2010 Documents with Custom SharePoint 2010 Workflows
Learn to generate Excel 2010 spreadsheets inside SharePoint workflows and publish them to SharePoint sites.
Open XML SDKSharePointSpreadsheetMLXLSX Generation
Level: 300Pages: 21Code: C#Media: Article
Creating Custom SmartArt Layouts with Office Open XML for Office 2007 and Office 2010
Explore the components of a SmartArt graphic layout, learn how to customize SmartArt layouts in the XML, and how to create your own custom layout files. Additionally, learn how to customize the SmartArt Styles and Colors galleries, and walk through the markup of a complete custom layout.
Level: 300Pages: 37Code: NoneMedia: Article
Generating Excel 2010 Workbooks by Using the Open XML SDK 2.0
This document demonstrates how to using the Open XML SDK 2.0 to manipulate an Microsoft Excel 2010 workbook.
Open XML SDKSpreadsheetMLXLSX Generation
Displaying Open XML SpreadsheetTables in the Browser Using Silverlight
This Visual How To shows how to create a Silverlight UserControl and associated ASP.NET web application that allows a user to select a table defined in a pre-existing Excel 2007 workbook located on the server. The UserControl uses the Silverlight Grid control to render the contents of the selected table.
Office Developer Cente
Level: 300Pages: Code: C#Media: Video
Searching for Content in Word 2007 Documents by Using the Open XML Format SDK 2.0 for Microsoft Office
Learn how to use the typesafe classes and enumerations provided with the Open XML Format SDK 2.0 for Microsoft Office to find paragraphs in a Word 2007 document by style name or content.
Open XML SDK and LINQ to XML
This blog post has some code that uses the Open XML SDK and LINQ to XML to query an Open XML document. It also is an example of code written in the functional style.
Level: 300Pages: 7Code: C#Media: Article
Using LINQ to Query Excel Tables
Excel has a very cool feature where you can declare that a range of cells is a table. It is a feature that allows you to use Excel very much like a database. Because these tables are stored in Open XML documents, we can implement some simple extension methods and some classes so that we can query these tables using LINQ in a manner that is similar to querying a SQL database. This post presents a bit of code to do this.
Simplifying Open XML WordprocessingML Queries by First Accepting Revisions
OpenXmlCodeTester: Validating Code in Open XML Documents
Validating Code in Open XML Documents.
Using the Open XML SDK and LINQ to XML to Remove Comments from an Open XML Wordprocessing Document
Using the Open XML SDK and LINQ to XML to Remove Personal Information from an Open XML Wordprocessing Document
Source Code Available: Complete Implementation of 'Accept All Changes (Tracked Revisions) in Open XML Documents'
How to Extract Comments from Open XML Documents
How to Use altChunk for Document Assembly
Merging multiple word processing documents into a single document is something that many people want to do. An application built for attorneys might assemble selected standard clauses into a contract. An application built for book publishers can assemble chapters of a book into a single document. This post explains the semantics of the altChunk element, and provides some code using the Open XML SDK that shows how to use altChunk.
Inserting / Deleting / Moving Paragraphs in Open XML Wordprocessing Documents
If you are making a tool to manipulate paragraphs in Open XML Documents, then this post lists some of the constraints that you must pay attention to.
Level: 300Pages: 24Code: XMLMedia: Article
Remove Rsid Attributes and Elements before Comparing Open XML Documents
A convenient way to explore Open XML markup is to create a small document, modify the document slightly in the Word user interface, save it, and then compare it with the Open XML Diff utility that comes with the Open XML SDK V2. However, Word adds extraneous elements and attributes that enable merging of two documents that have forked. These elements and attributes show up as changed, and obscure the differences that we're looking for. An easy way to deal with this is to remove these elements and attributes before comparing documents. We can safely do so without changing the content of the document. This post presents a bit of code to do this.
Inner Join of Two Excel Tables
I recently posted some code that allows you to use LINQ to query Excel tables. The source for these queries is the Open XML document - you don't need to involve the Excel application to query the data in these tables. In that post, I presented a few examples of queries of various types. This post shows a join of two tables using the extension methods and classes presented in that post.
Joining LINQ to SQL and LINQ to Excel
This post explains how to open the Excel spreadsheet, query a database using LINQ to SQL, and project a collection of an anonymous type that contains data from both data sources
Comparing Two Open XML Documents using the Zip Extension Method
Splitting Runs in Open XML Word Processing Document Paragraphs
Merging Comments from Multiple Open XML Documents into a Single Document
Finding Paragraphs by Style Name or Content in an Open XML Word Processing Document
Level: 300Pages: 28Code: C#Media: Article
Move/Insert/Delete Paragraphs in Word Processing Documents using the Open XML SDK
Enabling Better Transformations by Simplifying Open XML WordprocessingML Markup
When transforming Open XML markup to another XML vocabulary (such as XHtml), you can sometimes simplify the transform by first transforming the original document to a new, valid WordprocessingML document that contains much simpler markup, and therefore is easier to process. This blog post describes a utility class, MarkupSimplifier, which is part of the PowerTools for Open XML project.
Retrieving the Default Style Name of an Open XML WordprocessingML Document
Whenever you write some Open XML SDK code that processes paragraphs based on style name, you need to retrieve the default style name for a document.
ListItemRetriever: Accurately Retrieving Text of a Open XML WordprocessingML Paragraph
Accurately Retrieving Text of a Open XML WordprocessingML Paragraph. (This is one in a series of posts on transforming Open XML WordprocessingML to XHtml.)
Validate Open XML Documents using the Open XML SDK 2.0
Transforming WordprocessingML to Simpler XML for Easier Processing
Processing all Content Parts in an Open XML WordprocessingML Document
This post shows how to search for all content controls in a document, regardless of whether those content controls are in the main document part, in the headers/footers, or in endnotes/footnotes. This example uses LINQ to XML.
Testing for Base Styles in Open XML WordprocessingML Documents
Modifying an Open XML Document in a SharePoint Document Library
On a fairly regular basis, I need to write an example that retrieves an Open XML document from a SharePoint document library, modify the document, and save the document back to the document library. The correct approach is to use a CAML query to retrieve the document. This post presents the minimum amount of code to use the SharePoint object model to do this.
Inserting Repeating Data Items into a Word 2007 Table by Using the Open XML API
Walk through a solution that solves the problem of displaying an arbitrary number of data items on the surface of a Microsoft Office Word 2007 document by using Open XML Formats and the Microsoft .NET Framework 2.0
Office Open XML Formats: Setting Custom Word 2007 Document Properties
Setting Custom Word 2007 Document Properties using Open XML SDK.
Programmatically Update Multiple External Data Connections in Excel 2007 by Using Open XML (July 2009)
Create a Windows User Form project that allows you to update external data connections in Excel 2007 workbooks without opening Excel 2007. See how easy it is to work with Office Open XML files.
Level: 300Pages: 11Code: VBMedia: Article
Building Office Open XML Files
This post explores how you can extend and customize Microsoft Office system applications and file formats.
Level: 300Pages: 15Code: VBMedia: Article
Using the Open XML SDK 2.0 Classes Versus Using .NET XML Services
Learn about some of the benefits of using the typesafe classes in the Open XML Software Development Kit 2.0 for Microsoft Office. In addition, compare code that manipulates document content by using the SDK classes, to code that manipulates that same content by using .NET XML services.
Creating Documents by Using the Open XML Format SDK 2.0 (Part 2 of 3)
See common scenarios simplified by using the Open XML Format APIs. Assemble and manipulate data in Microsoft Office Excel 2007 workbooks by using the Open XML Format Software Development Kit (SDK version 2.0
Working with Slide Masters
This topic discusses the Open XML SDK 2.0 SlideLayout class and how it relates to the Open XML File Format PresentationML schema.
Level: 300Pages: 5Code: VB,C#Media: Article
Working with Comments
This topic discusses the Open XML SDK 2.0 Comment class and how it relates to the Open XML File Format PresentationML schema.
Level: 300Pages: 6Code: VB,C#Media: Article
Working with Notes Slides
This topic discusses the Open XML SDK 2.0 NotesSlide class and how it relates to the Open XML File Format PresentationML schema.
Working with Handout Master Slides
This topic discusses the Open XML SDK 2.0 HandoutMaster class and how it relates to the Open XML File Format PresentationML schema.
Embedding Documents in Word 2007 by Using the Open XML SDK 2.0
Learn how to use the Open XML Software Development Kit 2.0 for Microsoft Office to embed a Word 2007 document programmatically into another Word 2007 document.
How to Delete a Worksheet from Excel using Open XML SDK 2.0
Recently I worked on a scenario where a user wanted to delete a worksheet from a workbook using Open XML SDK 2.0. The worksheet may contain some formulas, defined names, pivot tables etcâ€¦ Though MSDN provides a code snippet which explains how to delete a worksheet, it doesn't cover the scenarios when we have formula, defined names, pivot tables etc. If you delete the worksheet following the MSDN article, Excel may not open the workbook and would throw an error.This blog post demonstrates how to delete a worksheet so that the Workbook opens without errors.
Office Open XML Formats: Retrieving Lists of Excel 2007 Worksheets
Learn how to retrieve lists of worksheets from Excel programmatically.
Level: 300Pages: 7Code: VB.C#Media: Article
Merging PowerPoint 2007 Decks Together by Using the Open XML SDK 2.0 for Microsoft Office
Learn how to use the Open XML SDK 2.0 for Microsoft Office to merge Microsoft Office PowerPoint 2007 decks together programmatically.
Level: 300Pages: 17Code: C#Media: Article,Video
Office Open XML Formats: Retrieving Lists of PowerPoint 2007 Slides
Learn how to retrieve lists of PowerPoint slides programmatically using code snippets for use with Visual Studio 2005.
Level: 300Pages: 10Code: VB,C#Media: Article,Video
Merging Simple Content from Excel 2007 Workbooks and Worksheets by Using the Open XML SDK 2.0
Learn how to use the Open XML SDK 2.0 for Microsoft Office to merge simple content from multiple Microsoft Office Excel 2007 workbooks and worksheets programmatically.
Level: 300Pages: 18Code: C#Media: Article,Video
Manipulating Excel 2007 and PowerPoint 2007 Files with the Open XML Format API (Part 1 of 2)
This article, the first in a series of two, describes the Open XML object model code that you can use to access and manipulate Microsoft Office Excel 2007 and Microsoft Office PowerPoint 2007 files.
Open XML SDKSpreadsheetMLPresentationML
Level: 300Pages: 11Code: VB,C#Media: Article
Manipulating Excel 2007 and PowerPoint 2007 Files with the Open XML Format API (Part 2 of 2)
This article, the second in a series of two, describes the Open XML object model code that you can use to access and manipulate Microsoft Office Excel 2007 and Microsoft Office PowerPoint 2007 files.
Level: 300Pages: 17Code: VB,C#Media: Article
Manipulating Word 2007 Files with the Open XML Format API (Part 1 of 3)
This series of articles describes the Open XML object model code that you can use to access and manipulate Microsoft Office Word 2007 files.
Level: 300Pages: 26Code: VB,C#Media: Article
Manipulating Word 2007 Files with the Open XML Format API (Part 2 of 3)
This is the second in a series of three articles that describes the Open XML object model code that you can use to access and manipulate Microsoft Office Word 2007 files.
Level: 300Pages: 8Code: VB,C#Media: Article
Manipulating Word 2007 Files with the Open XML Format API (Part 3 of 3)
This is the third in a series of three articles that describes the Open XML Application Programming Interface (API) code that you can use to access and manipulate Microsoft Office Word 2007 files.
Level: 300Pages: 16Code: VB,C#Media: Article
Office Open XML Formats: Inserting Values into Excel 2007 Cells
Learn how you can add information to a specific cell in a Microsoft Office Excel 2007 workbook or set of workbooks without having to open Excel.
Retrieve cell values from worksheets in Excel 2007 programmatically.
Using LINQ to Query Tables in Excel 2007
Learn how to use LINQ to query data that is stored in Excel 2007 worksheets.
How Do I: Manipulate Custom XML Parts Outside of Word
In this video Steve Hansen will teach you how to use classes in the System.IO.Packaging namespace to manipulate custom XML parts within a Word 2007 document.
Level: 300Pages: Code: VBMedia: Video
How Do I: Use Custom XML Parts with Excel?
This video demonstrates how you can use custom XML parts to store critical business data and keep the data in sync with ranges from the workbook.
Mail Merging Into a Single Word Document Using XML Literals
Level: 300Pages: 6Code: VBMedia: Article
How Do I: Manipulate Custom XML Parts in Word 2007
In this video Steve Hansen will teach you how to inspect, manipulate, and bind to a custom XML part within Word 2007 using the Word object model.
Level: 300Pages: Code: VBMedia: Article
Adding Images to Documents in Word 2007 by Using the Open XML SDK 2.0 for Microsoft Office
Learn how to use the Open XML Software Development Kit 2.0 for Microsoft Office to programmatically create Word 2007 documents that contain inline and floating images.
Merging Text & Photos into a Word Document using Open XML SDK
Level: 300Pages: 10Code: VBMedia: Article
How Do I: Create a Word Document Using the SDK for Open XML Formats?
In this video, Steve Hansen demonstrates how to use the SDK for Open XML formats to create a Word document from scratch without opening Word or using the Word object model.
Level: 300Pages: Code: VB,C#Media: Video
Working with Presentations
This topic discusses the Open XML SDK 2.0 for Microsoft Office Presentation class and how it relates to the Open XML File Format PresentationML schema.
Working with Presentation Slides
This topic discusses the Open XML SDK 2.0 Slide class and how it relates to the Open XML File Format PresentationML schema.
Writing Large Excel Files with the Open XML SDK
Like in the case of reading, the Open XML SDK provides two approaches for writing Open XML files: 1. using the DOM, 2. using the SAX-like writing capability. All of my examples on this blog have been around using the Open XML SDK DOM to write Open XML files. The DOM makes it easy because everything is strongly typed. Unfortunately, the DOM approach requires loading entire Open XML parts in memory, which can result in Out of Memory exceptions, especially when dealing with very large files. Let's compare the DOM and SAX-like approaches.
Level: 300Pages: 8Code: C#Media: Article,Video
Document Assembly Solution for SpreadsheetML
In this post, the author shows how to populate a spreadsheet with data from a real SQL database and create a cool looking chart based on that data, all without using Excel client.
Open XML SDK... The Basics
Explains the Open XML SDK and its design concepts.
Traversing in the Open XML DOM
Covers the basic techniques of traversing in the Open XML DOM tree using the Open XML SDK.
Finding Open XML Errors with Open XML SDK Validation
Deep dive into the schema and semantic level validation support within the SDK. Specifically, Author shows the Open XML SDK code needed to actually validate your Open XML files.
The Easy Way to Assemble Multiple Documents
Learn how to leverage altChunks to easily create a robust document assembly solution in less than a thirty lines of code.
Pushing Data from a Database into a Word Document
Learn how to build a repeating table within WordprocessingML based on data within a database.
Removing Comments from a Wordprocessing Document Programmatically
Learn how to remove comments from a Word document.
Retrieving Word Content Based on Styles
Learn how to retrieve content in a document based on style information.
Removing Page and Section Breaks from a Word Document
Learn how to remove page and section breaks in a Word document.
Learn how to populate a spreadsheet with data from a real SQL database and create a cool looking chart based on that data.
Read Data from SpreadsheetML
Learn how to read data from a spreadsheet and insert it into some data source, like a database.
How to Copy a Worksheet within a Workbook
Learn how to copy a worksheet within the same workbook.
Removing Comments from Excel and PowerPoint Files
Learn how to remove comments from an Excel workbook.
Creating a Presentation Report Based on Data
Learn how to create a rich presentation report based on data from a database.
How to Assemble Multiple PowerPoint Decks
Learn how to merge multiple PowerPoint decks together.
Adding Repeating Data to PowerPoint
Learn how to create repeating data within a table on a PowerPoint slide.
Importing Charts from Spreadsheets to Wordprocessing Documents
Learn how to import a chart from a spreadsheet to a Word document.
Open XML SDKSpreadsheetMLWordprocessingML
Importing a Table from WordprocessingML to SpreadsheetML
Learn how to import a table from a Wordprocessing document into a spreadsheet.
Importing SmartArt from PowerPoint to Word
Learn how to import SmartArt from a PowerPoint deck into a Word document.
Open XML SDKPresentationMLWordprocessingML
Embedding an Open XML File in another Open XML File
Learn how to embed Open XML files within other Open XML documents.
Level: 300Pages: 10Code: C#Media: Article,Video
Embedding Any File Type, Like PDF, in an Open XML File
Learn how to embed any file within Open XML documents.
The Open XML SDK and Fluent UI Extensibility
Learn how to add custom UI to a set of documents within a directory.
Level: 300Pages: 6Code: C#Media: Article,Video
Document Assembly: Merging Excel, PowerPoint, and Word Content Together
Learn how to take multiple Word, Excel and PowerPoint documents and merge them all together to form a final Word document.
WordprocessingMLSpreadsheetMLPresentationMLOpen XML SDK
Level: 300Pages: 24Code: C#Media: Article,Video
2009 PDC - Open XML SDK + Office Services
Search and Replace Text in an Open XML WordprocessingML Document
Using XML DOM to Detect Tracked Revisions in an Open XML WordprocessingML Document
Screen-cast: Exploring Margins in Open XML WordprocessingML Documents
This blog has recorded short screen-cast that explores some approaches to setting margins in a word-processing document. It shows setting margins for cells, paragraphs, and sections.
Update Data behind an embedded Chart in an Open XML WordprocessingML Document
11 minute video that walks through the process of embedding a chart in a word-processing document, and then programmatically updating that data so that the chart reflects the new data.
Importing HTML that contains numbering using altChunk
Getting Started with Open XML PowerTools Markup Simplifier
In PowerTools, in the HtmlConverter project, there is a class called MarkupSimplifier, which can remove proofing errors. In addition, it can simplify WordprocessingML markup in a variety of ways, including removal of comments, content controls, and etc.
Here is a small screen-cast that shows the use of MarkupSimplifier. This screen-cast uses Open XML Package Editor Power Tool for Visual Studio 2010.
Open XML SDKWordprocessingMLPowerTools
Adding Headers and Footers with SDK2.0
Adding Headers and Footers to Word Document with SDK2.0
This post presents some example code that implements a correct algorithm to search and replace text.
Many developers do not have option of using LINQ to process XML. This post presents a code which uses XML DOM API to detect tracked revisions
How to Insert a Page Break between Imported Content
Describes how to Insert a Page Break between Imported Content.
Updating Data for an Embedded Chart in an Open XML WordprocessingML Document
This blog post shows how to update Data in an embedded chart in an Open XML WordprocessingML Document.
Retrieving Fields in Open XML WordprocessingML Documents
The markup for fields in WordprocessingML documents is fairly involved. This post presents some code to accurately parse field markup.
In-Depth Exploration of WordprocessingML Fields - Part 2
See how to use a MarkupSimplifier utility program to make field markup more understandable. In walk through two cases where fields can be embedded in other fields.
Open XML Markup Simplifier Application makes it easier to research WordprocessingML
This article describes WinForms Application which makes it easier to research OpenXML markup, by creating documents, altering documents, and then comparing the two documents. The MarkupSimplifier class (which is part of the PowerTools for Open XML project) can help, but as downloaded fromCodePlex it is simply a class.
Accepting Revisions in Open XML Word-Processing Documents
Revision tracking markup in Open XML word-processing documents is one of the more complex areas of the standard. Accepting tracked revisions makes processing of text in word-processing documents simpler. Learn about the Open XML markup that deals with revision tracking, and how to programmatically accept tracked revisions using the Open XML Format SDK 2.0.
Level: 400Pages: 19Code: C#Media: Article
Working with Numbered Lists in Open XML WordprocessingML
Learn about lists in Open XML. Word 2010 documents often contain numbered and bulleted lists. This area of WordprocessingML is justifiably complex. Numbered lists and bulleted lists have many features, each used by a different set of uses.
Level: 400Pages: 51Code: NoneMedia: Artcile
Open XML Power Tools
Describes OpenXML PowerTools
This Week on C9: Office 2010, PowerShell for OpenXML, and would you help a robot
Dan and Brian discuss the week's top developer news including:
Create Word documents using PowerShell with Power Tools for Open XML, via Greg Duncan
PowerTools for Open XML
Combining the technologies of PowerShell and Open XML is a powerful and convenient way to do server-side document processing. The PowerTools for Open XML are sample source code and guidance for developers showing how to build PowerShell cmdlets that can create and modify Open XML documents. Also included are a number of examples of PowerShell scripts that use the cmdlets.
Radio-Research Firm Reduces Production Time and Costs with Presentation Solution
RDI needed to reduce the amount of time required to produce and customize large, complex radio-audience data presentations for its customers. The company engaged MicrosoftÂ® Gold Certified Partner PSC Group, LLC to develop a new system for producing data presentations using Microsoft Office PowerPointÂ® 2007 and Open XML Formats.
Creating a PresentationML Document through a browser interface
This article shows how a simple browser on any client machine can create a PresentationML document (PPTX) on a web server. The browser provides the GUI, and the server software uses the .NET 3.0 System.IO.Packaging API to create the document.
Muthu Kumar Arjunan
Creating a PresentationML document with .NET
The objective of this article is to create an OpenXML PresentationML using the .NET 3.0 System.IO.Packaging API.
Module 08: PresentationML
This PowerPoint presentation will build on our understanding of the basics of PresentationML.
Doug MahughChris Predeek
Level: 200Pages: 52Code: NoneMedia: Ppt
2007 Office Document: Open XML Markup Explained
2007 Office Document: Open XML Markup Explained
Level: 200Pages: 174Code: NoneMedia: Article
Introducing the Open XML Format External File Converter for 2007 Microsoft Office System SP2
Get the details about the interfaces that you need to use to create an Open XML Format External File Converter for the 2007 Microsoft Office system Service Pack 2 (SP2)
Level: 200Pages: 16Code: NoneMedia: Article
Move Slides Across Multiple Presentation Documents In a Browser
Display Slides in a Webpage
The article describes an application that would display contents of a presentation document in a web page.
This application, which basically uses a packaging architecture to read any PresentationML document and use a simple browser on any client machine, uses System.IO.Packaging API.
Animation in PresentationML
This Article is all about exploring one of the features of a presentation document, Animation, using System.IO.Packaging API and ASP.NET
Office Open XML Formats: Replacing PowerPoint 2007 Slide Images
Imagine that you need to replace a single image on a specific slide in one or more PowerPoint 2007 presentations. Perhaps a logo changed, or a particular common graphic element was updated. The ability to perform this operation without requiring you to load PowerPoint 2007 and then load the presentations, one after another, can be an incredible time saver. The Office Open XML File Formats make this task possible. Working with the Office Open XML File Formats requires knowledge of the way PowerPoint stores the content, the System.IO.Packaging API, and XML programming.
Level: 300Pages: 14Code: VB,C#Media: Article,Video
Open XML Converter Interface Sample Code
This sample code provides the technical information and files necessary to develop an external Open XML file converter that is able to import and export content between Microsoft Office Word, Microsoft Office Excel, or Microsoft Office PowerPoint for Microsoft Windows and external files.
Level: 300Pages: 1Code: C++Media: Articles
Creating Documents by Using the Open XML Format SDK 2.0 (Part 3 of 3)
Level: 300Pages: 22Code: C#Media: Article
Creating a PresentationML Document from a Database
This article explains how to fetch data from a database and use that data to create a PresentationML document. Each slide in the presentation consists of a heading and a subtitle, and the data for these textboxes is retrieved from a table in database.
Using the SharePoint 2010 Client Object Model with Open XML
Open XML Programming Lab
In this lab you will create a SharePoint event handler that will automatically mark an Open XML document as finalized when its status has changed to completed. This is a common practice in the final steps of a workflow or other process that is intended to move the document through a specific lifecycle.
Level: 300Pages: 1Code: VBMedia: Article
Leveraging the Power of Word Automation Services and the Open XML SDK
Learn how to use Word Automation Services to update a table of contents of several documents that have been merged with the Open XML SDK
Level: 300Pages: 15Code: C#Media: Article,Video
Open XML SDK and Office Services: Better Together
Learn how to leverage all three components, the SDK and the two Office services, to create a very cool mash up document assembly solution
2008 PDC - Open XML Format SDK: Developing Open XML Solutions
Displaying Open XML Spreadsheet Tables in a Browser by Using Silverlight
Learn how to use a Microsoft Silverlight application to display data from Open XML spreadsheet tables.
Level: 300Pages: 20Code: C#Media: Article,Video
Announcing Open XML Rendering Extensions for Microsoft Word and Excel
Introduction to new file-name extensions
The 2007 Microsoft Office system introduces a new file format based on XML. It is called Open XML Formats and applies to Microsoft Office Word 2007, Microsoft Office Excel 2007, and Microsoft Office PowerPoint 2007. This article describes what the new file name extensions are, how you can share the 2007 Office release files with people using earlier versions of Office, and you can learn about the benefits.
Module 07A: SpreadsheetML Advanced
This PowerPoint presentation covers SpreadsheetML concepts that are used in typical spreadsheet documents
Level: 200Pages: 38Code: NoneMedia: Ppt
Module 06: SpreadsheetML Basics
This PowerPoint presentation will explain basics of SpreadsheetML.
Level: 200Pages: 35Code: NoneMedia: Ppt
Header and Footer section in SpreadsheetML
This article explains how header and footer details and the style applied are stored in SpreadsheetML document and the options that are available in Office Open XML file format to apply header, footer in SpreadsheetML document.
Custom XML Mapping in SpreadsheetML
The XML mapping feature enables us to add arbitrary XML data structures and XML schema definitions to the workbook and map XML nodes to cells and cell ranges in the workbook. Once the mapping is set up, the application will be able to import and export XML data according to the schema.
Level: 200Pages: 11Code: NoneMedia: Article
Office Open XML Formats: Retrieving Excel 2007 Cell Values
Editing Data in an Excel 2007 Open XML File with VBA
Explore different ways to find particular XML data in an Excel 2007 file, retrieve the data, and then write it back to the file all by using Office Open XML.
Jan Karel Pieterse
Level: 300Pages: 14Code: VBMedia: Article
Extending the Reach of Excel Services with the Open XML SDK
Learn how to extend the reach of Excel Services and hosted charts to gather data from within a library of Word documents.
XSL transformation of SpreadsheetML to HTML -- Part 1
This article explains how a generic xml file(generated from a Spreadsheet ML document) can be converted to a HTML table that could be displayed in a browser using XSLT and styled using CSS.
Level: 300Pages: 13Code: XSLTMedia: Article
Create Xlsx sample program
This post covers the code for a CreateXlsx program that creates a simple Open XML spreadsheet from scratch using the .NETFramework 3.0 packaging API (System.IO.Packaging)
Video: Welcome to Open XML Training
In this workshop, you will learn:
1. Open XML file formats architecture
2. Practical details of the Open XML schemas
3. How to work with the new .NET 3.0 packaging API
4. How to create rich data-driven Open XML documents programmatically
Level: 200Pages: 13Code: NoneMedia: Ppt
Delete footnote/endnote from word document using System.IO.Packaging API
This article explains how to delete footnotes and endnotes from an existing word document using System.IO.Packaging API.
Mail merge in WordprocessingML using System.IO.Packaging API
This article explains the process of adding mail merge in WordprocessingML using System.IO.Packaging API.
Converting macro-enabled document to macro-free document
This article explains the process of extracting and removing macro enabled part from a document using Open XML SDK.
Adding Header - Footer to any WordprocessingML
This article describes how a footer or header can be programmatically added to a word document from a .NET application using the System.IO.Packaging API.
Getting Started with Office Open XML and WinFX
This post discusses how you can use the WinFX System.IO.Packaging assemblies with .NET 2.0 to manipulate the new Office Open XML file format.
Bulk Convert DOC to DOCX
Microsoft has a bulk conversion utility that can convert multiple DOC files to DOCX files. This blog post presents very basic information on its use.
OpenXML Document Viewer
The OpenXML Document Viewer project is an outcome of the feedback from participants of a series of Document Interoperability Initiative workshops. The main goal of the OpenXML Document Viewer project is to create software tools, plus guidance, showing how documents created using Open XML Format can be translated to HTML.
MS Virtual Labs: Microsoft Open XML and LINQ to XML
This demo/lab showcases Office Open XML and the LINQ to XML technology. The lab covers the following topics:
1. Opening Open XML documents programmatically
2. Performing queries using LINQ to XML
Module 04: WordprocessingML Advanced
This PowerPoint presentation will build on our understanding of the basics of WordprocessingML.
Level: 200Pages: 58Code: NoneMedia: Ppt
Module 03: WordprocessingML Basics
This PowerPoint presentation will explain basics of WordprocessingML.
Level: 200Pages: 42Code: NoneMedia: Ppt
Real-World Open XML and Ribbon Customization: Using Microsoft Office Word 2007 to Modify Mindjet Min
Join Don Campbell, Technical Evangelist for Microsoft, and Michael Scherotter, Solutions Platform Evangelist for Mindjet, to see a demonstration solution from the Mindjet Labs that uses the Open XML file format of Microsoft Office Word 2007 to transform business data from MindManager to Word 2007 and back again.
This technical demonstration shows how high-fidelity round-trip scenarios are possible with the Open XML file formats when used in conjunction with other XML-based applications, like Mindjet MindManager.
Using Office Open XML to Customize Document Formatting in the 2007 Office System
Introduces and demonstrates how to apply custom formatting not available from within the user interface (UI) to a document in the 2007 Microsoft Office system by using Office Open XML.
Level: 200Pages: 8Code: NoneMedia: Article
Getting More from Document Themes in the 2007 Office System with Office Open XML
Explore how document themes straddle the power user environment and developer environment and how they can be an ideal way for you to start using Office Open XML.
Chapter 22: Office Open XML Essentials
This partial chapter is an excerpt from Advanced Microsoft Office Documents 2007 Edition Inside Out by Stephanie Krieger
Level: 200Pages: 13Code: NoneMedia: Article
Open XML II: Editing Documents in the XML
Get more from your documents and save time by learning the basics of how to troubleshoot document issues and edit document content directly in the XML.
Level: 200Pages: Code: NoneMedia: Course
Bookmarks in Word document
This article covers the basics of bookmark, including:
How bookmarks are represented in Open XML.
How to programmatically iterate through bookmarks in a Word document.
How to view the bookmarked text.
How to create a new document based on the bookmark selected.
Create a rich Word document based on your own custom XML (without the need for XSLT)
The Legacy Hashing Algorithm in Open XML
In Open XML, there is a feature whereby you can restrict editing, and allow only users who have a password to modify the file. Note that this isn't a password that protects the file from viewing or modification.
Level: 300Pages: 4Code: C++Media: Article
Taking the 2007 Office System Further with VBA and Open XML Formats
Learn the types of things that you can accomplish using the Microsoft Office extensibility tools including Microsoft Visual Basic for Applications (VBA) and Office Open XML.
Working with Open XML in Visual Basic
This sample demonstrates how to get started with the Open XML SDK and also has examples of manipulating Word document formats using Visual Basic's XML literals. It also includes a presentation that you can use at your user groups.
Office Open XML Formats: Removing Comments from a Word 2007 Document
Use Office Open XML Formats to remove comments programmatically from a Microsoft Office Word 2007 document.
Walkthrough: Word 2007 XML Format
Walk through the new default file format for Microsoft Office Word 2007. Read detailed descriptions of the file format architecture, key components, and ways in which you can programmatically modify content.
WordprocessingML Snippets: Part 5, Files and Images
This article shows how to add an image to your document. The basic actions you need to take to do this is first store the image as a PackagePart inside the Package, next add the necessary WordprocessingML xml nodes to the document.
XSLT and Open XML
Working with XSLT in .NET
Level: 200Pages: 14Code: NoneMedia: Ppt
http://www.pandoraring.us/ pandora ring
http://www.pandora.org.au/ pandora australia
http://www.asicsshoes.com.au/ asics shoes
www.louisvuittonoutlet8.com louis vuitton outlet
www.michael-kors-outlet.us michael kors
http://www.piratesystem.us/ pirate system
http://www.uggboots.org.au/ ugg boots
www.abercrombieoutlet.us abercrombie outlet
http://www.michael-kors.ca michael kors canada
www.moncler-jacket.co.uk moncler jacket
www.michaelkorsoutletbags.us michael kors bags
www.michaelkorsoutlet.info michael kors
http://www.jordan-retro.us/ Jordan Retro Shoes
www.nike-jordan-shoes.us nike jordan
www.burberry-outlets.us burberry outlets
www.coachfactoryoutlet.co coach factory outlet
http://www.sheepskinboots.us/ sheepskin boots
http://www.rayban-outlet.us Ray Ban Outlet
http://www.lebron13.in.net/ Nike Lebron 12
www.michaelkorsoutlet.info michael kors outlet
www.michael-korsoutlet.com.co michael kors outlet
http://www.joebuy.com/ china wholesale
www.katespadeoutlet.nom.co kate spade
www.michaelkorsoutlet.ca Michael Kors Canada
http://www.cheapraybans.us/ cheap ray ban sunglasses
http://www.pandora-rings.us/ pandora rings sale
http://www.nike-shoes.net.au/ nike shoes australia
www.louis-vuitton.com.au louis vuitton australia
http://www.nike--store.us/ nike shoes
http://www.coach-outlet.com.co coach outlet
www.abercrombieandfitchoutlet.net abercrombie and fitch
http://www.oakleyfrogskins.us/ oakley frogskins
www.michael-kors-outletonline.us michael kors outlet
http://www.longchamp-bag.us longchamp bag
http://www.coachoutlet.nom.co/ coach outlet
www.abercrombieandfitchoutlet.net abercrombie outlet
http://www.nike-shoes.org/ nike store
http://www.jordanshoes.co/ nike jordan shoes
http://www.michael-kors.uk michael kors uk
www.katespadeoutlet.com.co kate spade outlet
www.michael-kors-watches.org Michael Kors Watches Outlet
www.abercrombieoutlet.us abercrombie outlet us
www.coach-factory-outlet.net coach factory outlet
http://www.michael-kors.net/ michael kors online
http://www.coach--bags.us/ coach diaper bag
www.burberryoutlet-online.net burberry outlet
http://www.moncler-outlet.org/ moncler outlet
http://www.prada-tote.us.com/ prada tote
www.prada-outlet.us.com Prada Factory Outlet
http://www.nikejordan.co/ Nike Jordans
http://www.top-sunglasses.org/ top sunglasses
http://www.ugg.org.au ugg australia
http://www.chanel-outlet.co/ CHanel Factory Outlet
http://www.burberryoutlets.ca/ burberry outlet
www.pandorarings.org.uk pandora rings
http://nike.kobe9.us/ Kobe 9 Shoes
www.coach-outlet-online.org coach outlet
http://www.pradabags.co/ official prada site
http://www.michaelkorsbags.co/ michael kors outlet
http://www.air-jordan-retro.us air jordan retro
www.coachoutletonline.info coach outlet online
www.canadagooseoutlet.us canada goose outlet
www.abercrombieoutlet.ca abercrombie outlet
www.michaelkorsoutlet.it michael kors
http://www.oakleyfrogskins.us/ oakley frogskins sunglasses
http://www.katespadebags.org/ kate spade bags outlet
http://www.hermesbirkin.co.uk/ hermes uk
www.true-religion.co.uk true religion
http://www.nike-airmax.org/ nike air max
http://www.pandoraring.us/ pandora rings
http://www.mk-bags.us/ mk handbags
http://www.mizunoshoes.us/ Mizuno Running Shoes
http://www.mlb-shop.net/ major league baseball
www.raybanprescriptionsunglasses.us ray ban prescription sunglasses
www.abercrombiefitch.nl Abercrombie Fitch
http://www.hermes--uk.co.uk/ hermes uk
www.yeezyboost350.us.org Yeezy Boost 350
www.michael-kors-watches.org Michael Kors Watches Online
www.prada-outlet.us.com prada outlet
http://www.nike-outlet.co/ nike outlet
http://www.nfl-shop.co/ nfl shop
www.coachoutletonline.info coach outlet
http://www.shoes-online.us/ shoes sale
http://www.mlb-shop.net/ mlb shop
http://www.pandora--uk.co.uk/ pandora uk
http://www.polo-outlet.co.uk/ polo online
http://www.sunglassessm.com/ sunglasses sm
www.michaelkorsoutlet.it michael kors outlet
http://www.nikehuarache.co/ huarache nike
www.michaelkorsoutletbags.us michael kors outlet bags
www.pandora-rings.co.uk pandora rings
www.abercrombiefitch.fr abercrombie paris
http://www.michael-kors.net/ michael kors handbags
www.katespadehandbags.org kate spade handbags
http://www.nikeoutlet.net/ nike shox shoes
www.michaelkorsoutletstores.us michael kors outlet
http://www.michaelkors.net.co/ michael kors outlet
www.michaelkors--handbags.us michael kors outlet
http://www.ups-tracking.us/ ups tracking
www.pandora-charms.com.au pandora charms
http://www.pandora-jewelry.us pandora jewelry
www.coach-factory-outlet.net coach outlet,coach factory
www.coach-outlet-online.org coach outlet online
www.nike-jordan-shoes.us nike jordan shoes
www.burberry-factory-outlet.com Burberry Factory Outlet
www.ray-ban-sunglasses.co.uk ray-ban sunglasses
www.michaelkorsoutletbing.us michael kors outlet
http://www.balenciagabag.us/ balenciaga bag
http://www.michaelkorstote.us/ michael kors tote
http://www.ubiae.fr/ veronique Billat
http://www.prada-bags.us.com/ prada handbags
www.coach-outlet-online.org coach outlet store
http://www.tiffany-co.com.au tiffany co
www.coach-outlet-online.co Coach outlet online
http://www.moncler-outlet.us/ moncler down jackets
http://www.chanel-tote.co/ chanel tote
www.coachfactoryoutlet.co coach outlet
www.lebron-james-shoes.us nike lebron shoes
www.pandora-charms.com.au pandora australia
http://www.katespadeoutlet.cc/ kate spade outlet
www.michael-kors-uk.org.uk michael kors uk
http://www.asicsshoes.com.au/ asics shoes Australia
http://www.kd8.us/ Kevin Durant Shoes
www.coachfactoryoutlet.cc coach factory outlet
www.abercrombieandfitchsale.us abercrombie us
http://www.mlbshop.us.org/ mlb shop
www.ralphlaurenpolo.net.au Ralph Lauren Polo
www.true-religion-jeans.co.uk true religion uk
http://www.coachcarter.com.au/ coach carter
http://www.chanel.net.au/ chanel bag
www.louisvuittonoutlet.info louis vuitton outlet
http://www.mizunoshoes.us/ Mizuno Wave
http://www.moncler-outlet.us/ moncler outlet
http://www.snow-boots.org.uk/ snow boots
www.burberryoutletonline.net burberry outlet online
www.canadagooseoutlet.us canada goose jacket
www.michaelkorsoutletbags.us michael kors outlet
saclongchamp.abssice360.fr sac longchamp
http://www.katespadebags.org/ kate spade handbags
www.burberry-outlets.us Burberry Outlet
www.sunglassesoutletsky.com sunglasses outlet
http://www.coach-outlet.us coach bags
www.coach-outlet-online.us coach outlet
http://www.moncler-outlet.us/ moncler clothing
www.lebron-james-shoes.us nike lebron james
http://www.jordan-retro.us/ Jordan Retro
http://www.salomon-shoes.com/ salomon shoes
www.coach-outlet-online.net coach outlet online
http://www.pradaoutlet.co/ prada outlet online
http://www.yeezyshoes.us/ air yeezy shoes
www.pandorarings.net.au pandora rings
http://www.coachoutlet.org/ coach outlet
http://www.sunglasseshut.cc/ sunglasses hut
http://www.nike-air-jordan.us/ Nike Air Max
http://www.pandora-rings.us/ pandora rings jewelry
www.polo--ralphlauren.co.uk Polo Ralph Lauren
http://www.chanel-outlet.co/ Chanel bags Outlet
www.coach-outlet-online.us coach outlet online
www.michael-kors--outlet.com michael kors outlet
www.burberryoutlet-online.net burberry online
www.pandoracharmssale.org.uk pandora charms
http://www.whittonlodge.co.uk/ Bed and Breakfast in chesterfield
http://www.katespadeoutlet.ca/ kate spade canada
www.rayban-eyeglasses.us ray ban eyeglasses
www.michael-korsoutlet.com michael kors outlet online
www.pandora-bracelets.us pandora bracelets
http://www.jordanshoes.co/ jordan shoes
www.raybansunglasses.com.au ray-ban sunglasses
http://www.rayban-wayfarer.us/ ray ban wayfarer
http://www.nikehuarache.co/ nike huarache
http://www.prada-bags.org/ prada bags
http://www.longchamp-bag.us longchamp backpack
www.abercrombieandfitchsale.us abercrombie and fitch
www.prada-handbags.us.org prada handbags
http://www.mk-bags.us/ mk outlet
http://www.pandora-uk.org.uk/ pandora uk
www.pandoracharmssale.org.uk pandora charms sale
http://burberry.outlet.net.au/ burberry us
www.basketballshoes.in.net cheap basketball shoes
http://www.prada-bags.co/ prada bags on sale
http://www.hyperdunk.us/ Hyperdunk 2016
www.coach-outlet-online.net coach outlet
www.michael-kors-outlet.co Michael Kors Outlet
http://www.ralphlaurenuk.co.uk Ralph Lauren UK
http://www.moncler-outlet.co/ moncler coats
www.ralphlauren-uk.co.uk ralph lauren uk
http://www.coach--purses.us/ coach purses
www.burberryaustralia.com.au burberry australia
http://www.pradasunglasses.us/ prada glasses
www.moncler-jacket.co.uk moncler sale
www.michaelkorsoutleto.us michael kors outlet
www.oakleysunglasses.net.au oakley sunglasses
http://www.michael-kors.net/ official michael kors
www.ralph-lauren.net.au ralph lauren
http://www.yeezyboost-350.us/ adidas yeezy boost 350
www.menssunglassess.com mens sunglasses
http://www.nikejordan.co/ Nike Jordan Shoes
http://www.changepoints.co.uk/ change points uk
www.michaelkorsoutletcity.us michael kors outlet
www.coach-sunglasses.co Coach Sunglasses Outlet
http://www.pandoraring.us/ pandora princess ring
www.burberryoutlet-online.net burberry outlet online
http://www.mlbshop.us.org/ baseball jerseys
http://www.pandorabracelet.us Pandora bracelet
http://www.kd8.us/ KD 8 shoes
www.jordan-retro-shoes.us jordan retro shoes
http://www.shoes-online.us/ shoes online
www.louboutin-shoes.co.uk louboutin shoes
www.true-religion-jeans.co.uk true religion jeans
http://www.katespadeoutlet.ca/ kate spade
www.moncler-jacket.co.uk moncler jacket mens
http://www.nikehuarache.co/ huaraches shoes
http://www.hugo-boss.us/ Hugo Boss Outlet
http://www.nike-id.us/ nike id
http://www.nikehuarache.co/ nike air huarache
www.moncler-jacket.co.uk moncler uk
http://www.ubiae.fr/ veronique billat
http://www.katespadepurses.us/ kate spade outlet
www.louis-vuittonoutlet.org louis vuitton outlet
www.abercrombieandfitchsale.us abercrombie outlet
http://www.pandora-rings.us/ pandora rings
http://www.michaelkors.com.co/ michael kors factory outlet
http://www.whittonlodge.co.uk/ B Derbyshire
http://www.moncler-jacket.us/ moncler jacket
http://www.yeezyboost-350.us/ yeezy boost 350
http://www.pradasunglasses.us/ prada official site
www.burberryscarfoutlet.org burberry outlet
www.ray-ban-sunglasses.net ray ban sunglasses
http://www.tiffanyco.net.au tiffany co
www.burberryaustralia.net.au burberry australia
www.pandora-bracelet-charms.us pandora bracelet
http://www.coach-outlets.net coach outlet
www.ray-ban-sunglasses.com.au ray-ban sunglasses
http://www.abssice360.fr/ abssice 360
http://www.nikecom.us/ nike com
www.michaelkors--outlet.us michael kors outlet
http://www.polo-outlet.co.uk/ polo outlet online
http://www.hermes-bag.us hermes bag
http://www.nikeoutlet.net/ nike outlet
http://www.yeezy-boost-350.us/ yeezy boost 350
http://www.pandora.org.au/ pandora jewelry
www.burberryoutletonline.us burberry outlet online
www.katespadeoutlet.nom.co kate spade outlet
http://www.moncler-jacket.us/ moncler us
http://www.kate--spade.co.uk/ kate spade
www.louis-vuitton-uk.co.uk louis vuitton uk
http://www.prada-bags.us.com/ prada bags
www.burberryoutletonline.net burberry outlet
http://www.ralph--lauren.co.uk Ralph Lauren
www.coach-australia.com.au coach australia
www.abercrombieandfitchoutlet.net abercrombie & fitch
http://www.nike-shoes.net.au/ nike australia
http://www.kd8.us/ Nike KD 8
saclongchamp.abssice360.fr longchamp sac
http://www.coachoutlet.org/ coach outlet online
http://www.hermesbirkin.co.uk/ hermes birkin
http://www.hermes-outlet.org Hermes Outlet
www.louboutinshoes-uk.co.uk louboutin shoes
www.michael-kors-watches.org Michael Kors Watches
www.pandora--bracelet.co.uk pandora bracelet
http://www.jimmy-choo.com.au jimmy choo australia
http://www.coach--purses.us/ coach purse
http://www.nfl-shop.co/ nfl jerseys
www.katespadehandbags.org kate spade bags
http://www.beatsbydre.net.au/ beats studio
http://burberry.outlet.net.au/ burberry outlet
http://www.katespade.net.au kate spade
http://www.michael-kors.net/ michael kors outlet
http://www.uggs-outlet.co/ uggs outlet
http://www.lebron13.in.net/ Nike Lebron Shoes
http://www.mlbshop.us.org/ mlb store
http://www.michael-kors.it/ michael kors italy
http://www.pandoranecklace.us/ pandora necklace charms
http://www.paulsmith.org.uk/ paul smith
http://www.coach-outlet.net.co coach outlet
www.canada-goose-outlet.us canada goose jacket
http://www.paulsmith.org.uk/ paul smith sale
www.poloralph-lauren.co.uk Polo Ralph Lauren
www.pandora-rings.co.uk pandora uk
http://www.burberryscarfs.com/ burberry scarf
www.oakley-outlet.in.net Oakley Outlet
www.basketballshoes.in.net Basketball shoes
www.prada-handbags.us.org official prada site
http://www.adidas.org.au adidas australia
http://www.ralphlaurenpolo.us Ralph Lauren Polo
http://www.rb-sunglasses.us ray ban sunglasses
http://www.coach-handbags.us coach handbags
www.michaelkorsblackfridayoutlets.us michael kors black friday
http://www.coach-online.org coach online
http://www.hermespurses.co hermes purses
http://www.coach-outlet.us coach outlet
http://www.burberry-online.us burberry online
http://www.air-jordan-shoes.us air jordan shoes
www.burberry-outletonline.us Burberry outlet online
http://www.moncler-outlet.co/ moncler outlet
http://www.rayban-glasses.us/ ray ban glasses
http://www.burberrypurse.com/ burberry purse
http://www.michaelkorstote.us/ michael kors jet set tote
www.adidasaustralia.com.au adidas australia
http://www.burberryoutlets.ca/ burberry outlet canada
http://www.joebuy.com/ china factory sale
www.coach-factory-outlet.net coach factory outlet online
http://www.prada-outlet.net/ prada outlet
www.michaelkorsblackfridayoutlets.us michael kors outlet
www.pandoracharms-uk.co.uk pandora charms
http://www.yeezyboost-350.us/ yeezy boost 350 shoes
www.abercrombiefitch.fr abercrombie fitch
http://www.chanel.net.au/ chanel australia
http://www.chanel-tote.co/ chanel tote bag
http://www.coachshoes.us coach shoes
http://www.pradasunglasses.us/ prada sunglasses
http://www.coach-outlet.cc/ Coach Outlet Store
www.pandorarings.net.au pandora australia
http://www.michaelkorsbags.co/ michael kors bags
www.oakley---sunglasses.org oakley sunglasses
http://www.prada-bags.co/ prada bags
http://www.prada-bags.org/ prada handbags
http://www.mcmoutlet.net MCM Outlet
www.flashsunglasses.com flash sunglasses
www.coach-outlet-online.us coach factory outlet
http://www.salomon-shoes.com/ salomon hiking shoes
http://www.paulsmith.org.uk/ paul smith uk
http://www.michaelkors.com.co/ michael kors
http://www.katespadepurses.us/ kate spade purses outlet
http://www.chanel-tote.co/ Chanel Tote Bag 2015
http://www.sunglasseshut.co/ sunglasses hut
http://www.nike-shoes.org/ nike outlet
www.michael-kors-outlet.us michael kors us
www.oakley-australia.com.au oakley australia
www.true-religion.co.uk true religion uk
http://www.oakleyoutlet.co/ oakley outlet
http://www.ugg--boots.co.uk/ ugg boots
www.michael-korsoutlet.com michael kors outlet
http://www.michaelkors.com.co/ michael kors outlet
www.yeezyboost350.us.org Yeezy 350
www.burberryoutletonline.net burberry online
http://www.apph.co.uk/ landing gear
www.kate-spadeoutlet.com kate spade outlet
www.michael-kors-outlet.us michael kors outlet
http://www.polo-outlet.co.uk/ polo outlet
http://www.nike.net.au nike australia
www.sunglasses-onsale.com R.B Sunglasses
www.ray-ban--sunglasses.com ray ban sunglasses
http://www.burberryoutlets.ca/ burberry canada
www.basketballshoes.in.net nike basketball shoes
www.pandorabracelet.org.uk pandora bracelet
www.jordan-retro-shoes.us Jordan retro
http://www.yeezyshoes.us/ yeezy shoes adidas
http://www.mizunoshop.us/ MIZUNO Shop US
http://www.longchampoutlet.cc/ longchamp outlet
www.michael-korsoutlet.org michael kors outlet
www.ralphlauren-shirts.co.uk ralph lauren shirts
www.burberry-factory-outlet.com burberry outlet
http://www.coach-outlet.cc/ Coach Outlet Online
www.raybanclubmaster.us ray ban clubmaster
www.yeezyboost350.us.org Adidas Yeezy Boost 350
http://www.prada-bags.us.com/ prada us
http://www.apph.co.uk/ landing gears
www.ralphlauren-uk.co.uk ralph lauren
http://www.coachcarter.com.au/ coach australia
http://www.coach--outlet.org/ coach outlet
http://www.jordanshoes.co/ air jordan shoes
http://www.pradapurses.org/ prada purses
http://www.yeezyshoes.us/ yeezy shoes
http://www.katespadebags.org/ kate spade bags
http://www.raybanpolarized.us/ ray ban polarized
www.abercrombieoutlet.us abercrombie us
http://www.ugg--boots.co.uk/ ugg uk
www.coachfactoryoutlet.co coach factory
http://www.nikejordan.co/ Nike Air Jordan
http://www.sunglassessm.com/ brand sunglasses
http://www.clkbenz.com clk benz
http://www.lebron13.in.net/ Lebron 13
www.michaelkorsoutletonlinepro.us michael kors outlet
www.burberry--outlet.org burberry outlet
http://www.longchamp-bag.us Longchamp Bags
www.moncler-jacket.co.uk moncler mens jackets
http://www.michael-kors.net/ michael kors bags
www.michaelkorspurses.us michael kors purses on sale
http://www.pandoranecklace.us/ pandora necklace
www.pandora--rings.co.uk pandora rings
www.abercrombiefitch.nl bercrombie Nederland
www.coach-sunglasses.co coach sunglasses for women
www.coachoutletonline.info coach online
www.pandoracharms-uk.co.uk pandora charms uk
http://www.hugo-boss.us/ Hugo Boss Store
www.timberland-boots.org.uk timberland boots
http://www.coachoutlet.co/ coach outlet
www.burberryscarfoutlet.org burberry scarf
http://www.nike-air-jordan.us/ Nike Air Jordan
http://www.coach-usa.us coach usa
http://www.kate-spade.net.au Kate Spade Australia
http://www.nike-shoes.net.au/ nike shoes
www.abercrombiefitch.fr abercrombie and fitch
www.canada-goose-outlet.us canada goose sale online
www.michaelkorspurses.us michael kors purses outlet
http://www.hyperdunk.us/ Nike Hyperdunk Shoes
www.asics-gel-kayano.com asics kayano
http://www.michael-kors.net.au michael kors australia
http://www.moncler-outlet.co/ piumini moncler replica
http://www.ugg-slippers.co.uk/ ugg slippers
http://www.ugg--boots.us/ ugg boots outlet
http://www.hugo-boss.us/ Hugo Boss Online
http://www.mizunoshoes.us/ Mizuno Shoes
www.canadagooseoutlet.us canada goose sale
http://www.pandoranecklace.us/ pandora necklaces
http://www.beatsbydre.net.au/ beats headphones
www.michael-korsoutlet.org michael kors
http://www.cheapraybans.us/ ray ban online
http://www.coach-outlet.cc/ Coach Outlet
http://www.michaelkorstote.us/ michael kors totes
http://www.nike--store.us/ nike store
www.timberland-boots.org.uk timberland uk
http://www.prada-outlet.net/ prada outlet online
www.oakley-sunglasses.net.au oakley sunglasses
http://www.katespadeoutlet.cc/ kate spade outlet online
www.burberry--outlet.net burberry outlet
www.raybannewwayfarer.us ray ban new wayfarer
http://www.asicsshoes.com.au/ asics Australia
http://www.chanel-outlet.co/ Chanel Outlet
http://www.balenciagabag.us/ balenciaga bags
http://www.mizunoshop.us/ Mizuno Shop Japan
www.raybanprescriptionglasses.us ray ban prescription glasses
www.katespadeoutlet.nom.co kate spade black friday
http://www.burberry-scarf.net/ burberry scarf
http://www.beatsbydre.net.au/ beats by dre
http://www.prada-bags.org/ prada online
http://www.ray-ban-outlet.us ray ban outlet
http://www.sheepskinboots.us/ sheepskin boots on sale
http://www.coachoutlets.net coach outlet
http://www.nike-free-run.us/ Nike Free
www.michaelkorsoutlethandbag.us michael kors handbags
www.michaelkorspurses.us michael kors purses
http://www.ugg--boots.us/ ugg boots
www.michaelkors--outlet.net michael kors outlet
http://www.michael--kors.us/ michael kors outlet
www.ralphlauren-shirts.co.uk Official Ralph Lauren UK Online Store
www.asics-gel-kayano.com asics gel
http://www.ugg--boots.us/ ugg boots sale
http://www.adidas-shoes.com.au adidas shoes
http://www.ugg-slippers.us/ ugg slippers
http://www.oakleyholbrook.us/ Oakley Holbrook
http://www.moncler-jacket.us/ cheap moncler jacket
http://www.michael-kors.net/ michael kors outlet online
http://www.coach--bags.us/ coach bags
http://www.burberryscarfs.com/ burberry scarfs
www.ralphlauren-shirts.co.uk ralph lauren uk
www.burberry-online-outlet.us Burberry online
http://www.michael-kors.com.au michael kors australia
http://www.michaelkorsbags.co/ michael kors bags outlet
http://www.prada-tote.us.com/ prada tote bag
http://www.michael-kors.net/ michael kors wallet
www.michaelkorsoutletonlinepro.us michael kors outlet online
http://www.sheepskinboots.us/ sheepskin boots for women
www.michael-korsoutletonline.us michael kors outlet
www.michaelkorsoutlethandbag.us michael kors outlet
http://www.longchamp-outlet.co Longchamp Outlet
http://www.raybanaviator.us/ ray ban aviator
http://www.michael-kors.net/ michael kors purses
www.katespadehandbags.org kate spade black friday
http://www.katespadeoutlet.ca/ kate spade outlet
http://www.prada-tote.us.com/ Prada Shopper Tote
http://www.burberryoutlet.org/ burberry outlet
http://www.ugguk.co.uk/ ugg uk
www.katespadeoutlet.com.co kate spade outlet online
http://www.pradaoutlet.co/ prada outlet
www.coach-sunglasses.co coach sunglasses
http://www.coachoutlet.org/ coach factory outlet
http://www.nike-free-run.us/ Free Run
www.coach-australia.net.au coach australia
www.lebron-james-shoes.us lebron james shoes
http://www.mk-bags.us/ mk bags
www.michaelkors--handbags.us michael kors handbags outlet
www.ugg-boots-uk.org.uk ugg boots uk
http://www.oakleyholbrook.us/ Oakley Holbrook sunglasses
www.louisvuitton-outlet.org louis vuitton outlet
www.michaelkorsoutlet.nom.co michael kors outlet
www.canada-goose-outlet.us Canada Goose Outlet
http://www.kate--spade.co.uk/ kate spade UK
http://www.prada-bags.co/ Prada Outlet
http://www.pradabags.co/ prada bag
http://www.cheapraybans.us/ Cheap Ray Ban
http://www.coach--purses.us/ cheap coach purse
www.michaelkorsoutlet.ca Michael Kors Outlet
http://nike.kobe9.us/ Nike Kobe 9
http://www.pdcharm.it/ Pandora Charm
http://www.nike-shoes.org/ nike shoes
http://nike.kobe9.us/ Kobe X Shoes
www.michaelkorsbagsoutlet.us.com michael kors outlet store
http://www.ugg--boots.co.uk/ ugg boots uk
http://www.coach--bags.us/ coach bag
http://www.uggboots.org.au/ ugg australia
http://www.nike-id.us/ nike shox
http://www.shoes-online.us/ shoes online sale
www.michaelkors--handbags.us michael kors handbags
http://www.coachoutlet.nom.co/ coach outlet online
http://www.nikehuarache.co/ nike huarache shoes
http://www.nike-air-jordan.us/ nike jordan shoes
http://www.coach-outlet.us/ coach handbags
http://www.pandora-charms.us/ pandora charms
www.prada-outlet.us.com prada outlet online
http://www.nikecom.us/ nike free run
www.asics-gel-kayano.com asics gel kayano
http://www.hermes-bag.co.uk hermes bag
www.hermesbirkinprice.co hermes birkin price
http://www.michael-kors.net/ michael kors tote
http://www.mizunoshop.us/ Mizuno Shop
http://www.pradabags.co/ prada bags
http://www.whittonlodge.co.uk/ Whitton Lodge Chesterfield Derbyshire UK
http://www.moncler-jacket.org/ moncler jacket
http://www.hyperdunk.us/ Nike Hyperdunk 2015
http://www.nike-outlet.co/ nike shoes
http://www.balenciagabag.us/ balenciaga us
http://www.raybanaviator.org/ rayban aviator
http://www.katespadepurses.us/ kate spade purses
www.ralph-lauren.net.au ralph lauren australia
http://www.pandora-charms.us/ pandora jewelry