New Office Visual How-tos: Excel 2007 and the Office Open XML Formats
We have some documentation on Word and the Office Open XML Formats, but few documentation about Excel and PPT + the Office Open XML Formats. I am working with Joanna Bichsel and Mr. Ken Getz to get you all more samples that show you how to work with the System.IO.Packaging API to manipulate Excel workbooks and PPT slide decks. These samples have code in C# and VB.NET and they include a cool video that walks you through the process.
Ken repurposed 5/40 of the Office 2007 Open XML File Format code snippets and wrote great walkthroughs and videos that show you how it all works together. Today we published two of them:
- Office Open XML Formats: Retrieving Excel 2007 Cell Values
- Office Open XML Formats: Retrieving Lists of Excel 2007 Worksheets
We have three more coming soon:
- Office Open XML Formats: Replacing PowerPoint 2007 Slide Images
- Office Open XML Formats: Retrieving Lists of PowerPoint 2007 Slides
- Office Open XML Formats: Setting Custom Word 2007 Document Properties
We have more Office Visual How-Tos about Excel, Access, Excel Services, the BDC, PPT, the Fluent Ribbon extensibility, and Item-Level Auditing that will be available soon. We will start updating the MSDN Office Developer How To Center as soon as we publish them.
Comments
Anonymous
March 08, 2007
I just got an email from Erika that read "I have a surprise for you!" and included a link to her latestAnonymous
March 11, 2007
Erika Ehrli has two more great articles in the "Office Visual How-To" series for developers. See Erika'sAnonymous
March 14, 2007
Erika is working on pulling together more coding examples for the OpenXML formats. We've seen a bunchAnonymous
March 14, 2007
Erika is working on pulling together more coding examples for the OpenXML formats. We've seen a bunchAnonymous
March 14, 2007
You probably read the MSDN Magazine article: Setting Word Document Properties the Office 2007 Way byAnonymous
July 03, 2007
Hello, I am trying to insert customXML data into Excel documents and map its nodes from the cells so that I do not have to access cell[A1], ... but the corresponding node <employees><employee>Pepe... May you speak about how to achieve this customXML mapping in Excel? RegardsAnonymous
April 28, 2008
Hello, I have to upgrade native MFC/C++ applications to support examining and reading Office Open XML Format spreadsheets. Can you suggest any library that I could use to provide this support? Help will be greatly appreciated. Heniek