Lets Learn

Opinion Matters

Open XML SDK Learning Resources

Posted by Ankush on February 24, 2011


Open XML SDK 2.0 FAQ
http://social.msdn.microsoft.com/Forums/en-US/oxmlsdk/thread/19032efe-80af-4a16-b954-1f5a6d2f2236

Building Office Open XML Files
http://msdn.microsoft.com/en-us/magazine/cc163478.aspx

Introducing the Office (2007) Open XML File Formats
http://msdn2.microsoft.com/en-us/library/ms406049.aspx

How to: Manipulate Office Open XML Formats Documents
http://msdn2.microsoft.com/en-us/library/aa982683.aspx#Office2007ManipulatingXMLDocs_creating

Building Server-Side Document Generation Solutions Using the Open XML Object Model
http://msdn.microsoft.com/en-us/library/bb735940.aspx (Part 1 of 2)
http://msdn.microsoft.com/en-us/library/bb735939.aspx (Part 2 of 2)

How to use the Office XML file format and the packaging components from the .NET Framework 3.0 to create a simple Excel 2007 workbook or a simple Word 2007 document
http://support.microsoft.com/?id=931866

How Do I…Open XML SDK v2.0
http://msdn.microsoft.com/en-us/library/bb491088(office.14).aspx

Nanipulating Excel 2007 and PowerPoint 2007 Files with the Open XML Object Model (Part 1 of 2)
http://msdn.microsoft.com/en-us/library/bb739834.aspx

Manipulating Excel 2007 and PowerPoint 2007 Files with the Open XML Object Model (Part 2 of 2)
http://msdn.microsoft.com/en-us/library/bb727373.aspx

Reading Data from SpreadsheetML
http://blogs.msdn.com/brian_jones/archive/2008/11/10/reading-data-from-spreadsheetml.aspx

How to use components of the .NET Framework 3.0 to create and then to stream an Office Word 2007 document and an Office Excel 2007 workbook to a client computer
http://support.microsoft.com/kb/932921

Welcome to the Open XML Developer Workshop
http://msdn.microsoft.com/en-us/office/bb738430.aspx

Open XML Explained e-book
http://openxmldeveloper.org/articles/1970.aspx

Good Site to Search ECMA standard online :
http://www.documentinteropinitiative.org/default.aspx

Open XML SDK Documentation
http://msdn.microsoft.com/en-us/office/ee441239.aspx

Open XML Format SDK 2.0: Getting Started Best Practices
http://blogs.msdn.com/erikaehrli/archive/2009/05/14/open-xml-format-sdk-2-0-getting-started-best-practices.aspx

Office Open XML Formats: Retrieving Lists of Excel 2007 Worksheets
http://msdn.microsoft.com/en-us/library/bb332456.aspx

Manipulating Excel 2007 and PowerPoint 2007 Files with the Open XML Format API (Part 1 of 2)
http://msdn.microsoft.com/en-us/library/bb739834.aspx

Manipulating Excel 2007 and PowerPoint 2007 Files with the Open XML Format API (Part 2 of 2)
http://msdn.microsoft.com/en-us/library/bb727373.aspx

2007 Office System Sample: Open XML Format SDK 2.0 Code Snippets for Visual Studio 2008
http://www.microsoft.com/downloads/details.aspx?FamilyID=78bea298-a3f9-44cf-bde0-b4f30dc986df&displaylang=en

Writing Large Excel Files with the Open XML SDK
http://blogs.msdn.com/b/brian_jones/archive/2010/06/22/writing-large-excel-files-with-the-open-xml-sdk.aspx

Parsing and Reading Large Excel Files with the Open XML SDK
http://blogs.msdn.com/b/brian_jones/archive/2010/05/27/parsing-and-reading-large-excel-files-with-the-open-xml-sdk.aspx

How to efficiently generate OpenXML Workbook from Excel files containing very large amount of data
http://blogs.msdn.com/b/vsod/archive/2010/05/31/how-to-efficiently-generate-openxml-workbook-from-excel-files-containing-very-large-amount-of-data.aspx

Very very very good blogs to through..Its must if you would like to know more about formats:

Where is the documentation for Office’s docx/xlsx/pptx formats? Part 1: Office 2007
http://blogs.msdn.com/b/chrisrae/archive/2010/09/25/where-is-the-documentation-for-office-2010-s-docx-xlsx-pptx-formats.aspx

Where is the documentation for Office’s docx/xlsx/pptx formats? Part 2: Office 2010
http://blogs.msdn.com/b/chrisrae/archive/2010/10/06/where-is-the-documentation-for-office-s-docx-xlsx-pptx-formats-part-2-office-2010.aspx

I’ll keep on updating this list and will try to categorize it as it becomes bigger 🙂

Advertisements

4 Responses to “Open XML SDK Learning Resources”

  1. katie said

    yeah nice

  2. Jahedur Rahman said

    Hi…thanks a lot for providing the list of helpful links.
    I am wondering if you can find a link that demonstrates how to create pivot table using Open XML SDK 2.0.
    Thanks in advance…

    • Ankush said

      Hi Jahedur,

      As such there is no MSDN link which talks about how to generate the pivot tbale but you can use SDK tools to start orking on it. But Open XML SDK is always helpful when you have the template and ready and then you want to manuplate it.

      Thanks
      Ankush

  3. prasad said

    hi,
    i would like to read an excel file and read teh headers in the excel file and insert the records into sp 2010 splist/doc lib.
    is it possible, any sample code is appeciated

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: