Tuesday, February 22, 2011

Open XML 2.0 Code Snippets for VS2010 (and VS2008 too)

Microsoft Downloads - 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.

Office2007OpenXML20Snippets.msi  <- VS 2008 Snippets
417KB

OpenXMLSDKSnippetsForVS2010.msi
396KB

Version: 02/11

Date Published: 2/21/2011

...

The snippets in this download use the Open XML SDK 2.0 to accomplish many tasks involving Microsoft Excel, Microsoft PowerPoint, and Microsoft Word 2007 and 2010 documents. You can use the enclosed code snippets with the Microsoft Visual Studio 2010 Code Snippet Manager. Each snippet provides unique functionality that you can reuse within an application. This download provides snippets written in Microsoft Visual Basic and Microsoft Visual C# development languages. Download and install these snippets to your Visual Studio code snippet folder and use them with the Visual Studio Code Snippets Manager.

You can still download the code snippets file, Office2007OpenXML20Snippets.msi, for use with the Microsoft Visual Studio 2008 Code Snippet Manager. That download provides snippets written in Microsoft Visual Basic and Microsoft C# development languages.

...

The download file, OpenXMLSDKSnippetsForVS2010.msi, works with documents or files produced with the following Office applications:

  • Microsoft Office 2010
  • Microsoft Office Excel 2010
  • Microsoft Office PowerPoint 2010
  • Microsoft Office Word 2010
  • 2007 Microsoft Office System
  • Microsoft Office Excel 2007
  • Microsoft Office PowerPoint 2007
  • Microsoft Office Word 2007

...

By default, this download installs files to the following locations:

  • Visual C# snippets. PersonalFolder\Visual Studio 2010\Code Snippets\Visual C#\Open XML SDK 2.0 for Microsoft Office 2010
  • Visual Basic snippets. PersonalFolder\Visual Studio 2010\Code Snippets\Visual Basic\Open XML SDK 2.0 for Microsoft Office 2010

After you install this download, use the Visual Studio 2010 Code Snippets Manager as you normally would.  ..."

Sometimes snippets are just what you need to get started. Programming against OpenXML files is very different that using the Office API's. It's much closer to the metal and so having these snippets will not only save you some time, but also give you a leg up on learning other parts of the Open XML 2.0 SDK.

At first glance, looks like the same 52 snippets...  Meaning the details in my Open XML Format SDK 2.0 Code Snippets for Visual Studio 2008 – 52 C#/VB Code Snippets to help ease your Open XML coding post likely apply to the 2010 version too

 

Related Past Post XRef:
Open XML Format SDK 2.0 Code Snippets for Visual Studio 2008 – 52 C#/VB Code Snippets to help ease your Open XML coding

Where to go to scratch your OpenXML dev info itch…
Open XML File Format Code Snippets for Visual Studio 2005 (Office 2007 NOT required)

2 comments:

Oxymoron said...

I have used this codes for my projects thank you so much.
if you need more codes then use this . i am also using this codes and more. Thank you Xml http://www.hscripts.com/codes-snippets/index.php

Anonymous said...

i have used this article and it is extremly helpfull.
Thanks,
rama