Link
Summary
Author
Keywords
Open Specifications Interactive Pivot
Silverlight pivot that enables exploring of all the content on the Open Specifications site.
InteroperabilityIntroduction
Level: 100Pages: Code: NoneMedia:
Beginning WordprocessingML
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.
InteroperabilityWordprocessingML
Level: 100Pages: Code: C#Media: Article, Video
Beginning SpreadsheetML
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.
InteroperabilitySpreadsheetML
Level: 100Pages: Code: Media: Article, Video
Beginning PresentationML
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.
InteroperabilityPresentationML
Intermediate WordprocessingML
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
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
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.
Advanced WordprocessingML
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
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
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.
Linking Word 2007 Content Controls to Custom XML
Andrew Coates
Open XML SDKWordprocessingMLContent Controls
Level: 200Pages: 5Code: 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
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.
Ankush Bhatia
System.IO.PackagingDigital Signature
Level: 300Pages: 3Code: C#Media: Article
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.
Open XML SDKSpreadsheetML
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.
Aurora Queen
Introduction
Level: 200Pages: Code: NoneMedia: Video
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.
Beth Massi
WordprocessingML
Level: 300Pages: 1Code: VBMedia: Article
Mail Merging Into a Single Word Document Using XML Literals
Open XML SDKWordprocessingML
Level: 300Pages: 6Code: VBMedia: Article
Merging Text & Photos into a Word Document using Open XML SDK
Level: 300Pages: 10Code: VBMedia: Article
Generalized Approach to Open XML Markup References
Bob McClellan
Open XML SDKDocument BuilderPowerToolsWordprocessingML
Level: 200Pages: 4Code: NoneMedia: Article
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
Brian Keller
PowerTools
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)?
Charles
Interoperability
Level: 100Pages: Code: Media: Video
What's so open about Open XML? Part 2
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.
Open XML SDK
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
XSLT and Open XML
Working with XSLT in .NET
Chris Predeek
XSLT
Level: 200Pages: 14Code: NoneMedia: Ppt
Module 08: PresentationML
This PowerPoint presentation will build on our understanding of the basics of PresentationML.
Doug MahughChris Predeek
PresentationML
Level: 200Pages: 52Code: NoneMedia: Ppt
Module 06: SpreadsheetML Basics
This PowerPoint presentation will explain basics of SpreadsheetML.
SpreadsheetML
Level: 200Pages: 35Code: NoneMedia: Ppt
Module 03: WordprocessingML Basics
This PowerPoint presentation will explain basics of WordprocessingML.
Level: 200Pages: 42Code: NoneMedia: Ppt
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
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.
Dimitris
WordprocessingMLContent ControlsDOCX Generation
Level: 200Pages: 2Code: NoneMedia: Article
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.
doncho
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.
Donovan Follette
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
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.
Introduction to the Open XML Module
Donovan and Chris provide a brief introduction to 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.
SharePoint
Open XML support in new tools, apps, and custom solutions
Doug Mahugh
Level: 100Pages: 4Code: NoneMedia: Article
Open XML Power Tools
Describes OpenXML PowerTools
Level: 100Pages: 3Code: 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.
Level: 100Pages: 1Code: NoneMedia: Article
Content Control Toolkit
Describes 'Content Control Toolkit' developed by Microsoft's Matt Scott.
Content ControlsWordprocessingML
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-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.
Java
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.
WordprocessingMLInteroperability
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.
OPC
Module 07A: SpreadsheetML Advanced
This PowerPoint presentation covers SpreadsheetML concepts that are used in typical spreadsheet documents
Level: 200Pages: 38Code: NoneMedia: Ppt
Module 04: WordprocessingML Advanced
This PowerPoint presentation will build on our understanding of the basics of WordprocessingML.
Level: 200Pages: 58Code: NoneMedia: Ppt
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.
DrawingML
Level: 200Pages: 43Code: NoneMedia: Ppt
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
System.IO.Packaging
Level: 200Pages: 13Code: NoneMedia: Ppt
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
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
Level: 200Pages: 3Code: 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.
Open XML SDKWordprocessingMLContent ControlsDOCX Generation
Level: 200Pages: 1Code: NoneMedia: Article
Create DOCX Sample Program
This post covers a very simple program for creating an Office Open XML word-processing document.
IntroductionWordprocessingML
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)
SpreadsheetMLSystem.IO.Packaging
Level: 300Pages: 5Code: C#Media: Article
OpenXML Content Types in an XML Document
Eric White
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.
Using the SharePoint 2010 Client Object Model with Open XML
Level: 100Pages: 2Code: NoneMedia: Article
Open XML Package Editor Power Tool for Visual Studio 2010
Using the Open XML SDK from within a Managed Add-In
Determining if an Open XML WordprocessingML Document contains Tracked Changes
Using Content Controls to give Semantic Meaning to Content in Open XML WordprocessingML Documents
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.
Formats Supported for altChunk
This post lists formats supported for imported content by the altChunk importing functionality of Word.
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.
Generating Open XML WordprocessingML Documents
This is a blog post series on parameterized Open XML WordprocessingML document generation.
Level: 100Pages: Code: NoneMedia: Article
Transforming Open XML Documents using XSLT
XSLTOPCFlat OPC
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.
OPCFlat OPCXSLT
Level: 200Pages: 7Code: NoneMedia: 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
Interrelated Markup in Open XML Word Processing Documents
Seven Key Benefits of Open XML
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.
Inserting Content That Contains Images Using altChunk
Using Nested Content Controls for Data and Content Extraction from Open XML WordprocessingML Documents
Level: 200Pages: 3Code: C#Media: Article
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
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.
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
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
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
Level: 300Pages: 17Code: C#Media: Article
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
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.
Open XML SDKWordprocessingMLSharePoint
Level: 300Pages: 10Code: 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.
WordprocessingMLContent Controls
Level: 300Pages: 6Code: C#Media: Article
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.
WordprocessingMLDOCX Generation
Level: 300Pages: 10Code: NoneMedia: Article
Transforming Open XML WordprocessingML to XHTML Using the Open XML SDK 2.0
Level: 300Pages: 12Code: C#Media: Article
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
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
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.
Level: 300Pages: 21Code: C#Media: Article
Simplifying Open XML WordprocessingML Queries by First Accepting Revisions
Transforming Open XML Documents to Flat OPC Format
OPCFlat OPC
Transforming Flat OPC Format to Open XML Documents
Creating Data-Bound Content Controls using the Open XML SDK and LINQ to XML
Level: 300Pages: 13Code: C#Media: Article
How to Create a List of All Parts in an Open XML Document
Level: 300Pages: 4Code: C#Media: Article
OpenXmlCodeTester: Validating Code in Open XML Documents
Validating Code in Open XML Documents.
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.
Using the Open XML SDK and LINQ to XML to Remove Comments from an Open XML Wordprocessing Document
Level: 300Pages: 2Code: C#Media: Article
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'
Level: 300Pages: 9Code: C#Media: Article
How to Extract Comments from Open XML Documents
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
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.
Level: 300Pages: 8Code: C#Media: Article
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
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.
Comparing Two Open XML Documents using the Zip Extension Method
Splitting Runs in Open XML Word Processing Document Paragraphs
Comparison of Navigating Parts between System.IO.Packaging and the Open XML SDK
Open XML SDKOPC
Merging Comments from Multiple Open XML Documents into a Single Document
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
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
Creating a Template Open XML Document in Memory
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.
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.
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
Search and Replace Text in an Open XML WordprocessingML Document
Level: 300Pages: Code: C#Media: Article,Video
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.
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.
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.
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.
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
Importing HTML that contains numbering using altChunk
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.
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
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.
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.
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.
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.
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.
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.
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 SDK 2.0 RTM is live! Find Articles, Videos, Code Samples, and Resources on MSDN
Erika Ehrli
Level: 100Pages: 8Code: NoneMedia: Article
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
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.
Open XML SDKWordprocessingMLDOCX Generation
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.
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.
Level: 300Pages: 22Code: 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.
Frank Rice
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
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
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
WordprocessingMLPresentationMLSpreadsheetMLDOCX Generation
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
Creating Documents by Using the Open XML Format SDK 2.0 (Part 3 of 3)
WordprocessingMLPresentationMLSpreadsheetML
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
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
Independent Implementations of Open XML
Jason Matusow
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
Level: 100Pages: Code: NoneMedia: Video
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.
Jean-Christophe Cimetiere
Level: 300Pages: 9Code: JavaMedia: Articles
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
Joel Krist
Level: 300Pages: 16Code: 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
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.
PowerToolsWordprocessingMLDOCX Generation
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.
SpreadsheetMLSilverlight
Level: 300Pages: 20Code: C#Media: Article,Video
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
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.
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.
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.
Level: 300Pages: 11Code: C#Media: Article,Video
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.
Open XML SDKPresentationML
Level: 300Pages: 17Code: 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
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.
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
Joel Rayes
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
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.
Jon Udell
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.
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.
Ken Getz
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.
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.
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
Office Open XML Formats: Setting Custom Word 2007 Document Properties
Setting Custom Word 2007 Document Properties using Open XML SDK.
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
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.
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
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
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.
Office Open XML Formats: Retrieving Excel 2007 Cell Values
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.
Kevin Boske
Generating a document using PowerTools for Open XML and PowerShell
Lawrence Hodson
PowerToolsDOCX Generation
Level: Pages: 12Code: Media: Article
Adding Headers and Footers with SDK2.0
Adding Headers and Footers to Word Document with SDK2.0
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.
Maarten Balliauw
SpreadsheetMLInteroperability
Level: 300Pages: 5Code: PHPMedia: Article
Copy table from WordprocessingML to SpreadsheetML
Open XML SDK, WordprocessingML, Content Controls
Mallika Biswas
WordprocessingMLSpreadsheetMLSystem.IO.PackagingXSLTContent Controls
Level: 300Pages: 5Code: C#, XSLTMedia: Article
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.
WordprocessingMLSystem.IO.Packaging
Deleting Comments from Word document using Core Java
This article explains about how to delete comments from the WordprocessingML document using Core Java
WordprocessingMLJava
Level: 300Pages: 7Code: JavaMedia: 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.
Matt Scott
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.
Matthew Scott
Using PHP and XSLT to Create a Word 2007 Document
Learn how to use PHP to transform XML data into the Open XML format.
Michael Case
InteroperabilityXSLTOpen XML SDKWordprocessingML
Level: 300Pages: 10Code: PHPMedia: 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 LINQ to Query Tables in Excel 2007
Learn how to use LINQ to query data that is stored in Excel 2007 worksheets.
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.
Michael Scherotter
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
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
PresentationMLSystem.IO.Packaging
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.
XSLTSpreadsheetML
Level: 300Pages: 13Code: XSLTMedia: Article
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.
Announcing Open XML Rendering Extensions for Microsoft Word and Excel
Riccardo Muti
WordprocessingMLSpreadsheetML
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.
Sheela E N
Digital Signature in WordprocessingML
This article explains about Digital Signature and how Digital Signature details are stored in Open XML file format in WordprocessingML.
Digital SignatureWordprocessingML
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.
DrawingMLSpreadsheetML
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
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.
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.
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.
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.
Stephanie Krieger
Level: 100Pages: Code: Media: Article
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
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
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.
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
Stephen Oliver
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.
Steve Hansen
Open XML SDKSpreadsheetMLXLSX Generation
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.
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
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
Building Office Open XML Files
This post explores how you can extend and customize Microsoft Office system applications and file formats.
Ted Pattison
Level: 300Pages: 15Code: VBMedia: Article
Server-Side Generation of Word 2007 Docs
Level: 300Pages: 12Code: VBMedia: Article
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.
Todd Baginski
Open XML SDKSharePointSpreadsheetMLXLSX Generation
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.
Vijayeta Tilak
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.
Content ControlsWordprocessingMLSystem.IO.Packaging
Move Slides Across Multiple Presentation Documents In a Browser
This article describes an application that presents two existing presentation documents in a browser, with a drag&drop interface (implemented in JavaScript) for creating a new presentation from selected slides in the two existing presentations. This type of application is useful in scenarios where a user needs to create a PresentationML document but doesn't have client software available that supports PresentationML.
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.
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.
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
System.IO.PackagingPresentationML
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.
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.
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.
Vineela Kavoori
Level: 300Pages: 8Code: JavaMedia: Article
2007 Office Document: Open XML Markup Explained
Wouter van Vugt
WordprocessingMLSpreadsheetMLPresentationML
Level: 200Pages: 174Code: NoneMedia: Article
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.
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.
WordprocessingMLCode Snippets
This post will represent the most up-to-date blog map for topics on the Open XML SDK.
Zeyad Rajabi
IntroductionOpen XML SDK
Level: 100Pages: 13Code: NoneMedia: Article
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 and Office Services
Summary of Open XML and Office Services
Open XML SDKSharePoint
Level: 100Pages: 3Code: NoneMedia: Artilce
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.
PowerToolsOPCSystem.IO.Packaging
Translating OpenXML into DAISY
The first alpha build of the OpenXML to DAISY translator is available up on SourceForge.
Level: 100Pages: 2Code: NoneMedia: Artilce
WordprocessingML Document Model
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
Create a rich Word document based on your own custom XML (without the need for XSLT)
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.
Open XML SDK Code Snippets
Summary of Open XML SDK Code Snippets
Open XML SDKCode Snippets
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.
Taking Advantage of Bound Content Controls
Learn how to leverage bound content controls to bind to custom XML.
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
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.
SpreadsheetMLWordprocessingML
Level: 300Pages: 15Code: C#Media: Article,Video
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
SharePointSpreadsheetMLWordprocessingML
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
2009 PDC - Open XML SDK + Office Services