Friday Thoughts 12-01-2006

I wanted to point out a few interesting things that have popped up over the past couple weeks:

IDC Report on Open Standards

Interesting study by IDC where they polled companies in Finland, Sweden, Norway, and Denmark to try and gauge the level of interest in open document standards. As you would imagine, the level of interest in the Open XML formats continues to grow, especially with the standardization vote only a week away and Office 2007 already out the door with full support for the final draft.

CompTIA believes Open XML will benefit the industry

"Our members believe that approval of Open XML by ECMA as an open standard will be a key advancement to the IT industry and provide critically needed choice in the document format space allowing for greater vendor independence and reduced lock-in. Competition among multiple open document standards will enhance innovation in document formats and increase flexibility and interoperability all to the benefit of software consumers. The approval of Open XML as an open standard will ensure that digital content is more efficiently stored and managed today as well as into the future."

Office 2007 "Business Launch"

Yesterday we announced the business launch of Windows Vista; Office 2007; and Exchange Server 2007. There is a blog describing all the details from the launch.

40 example code snippets for Open XML

Kevin Boske has an update on the code snippets that we last published back in June. They have now all been updated to work with the final draft of the Ecma standard. These are really great for folks trying to get started with development on top of the open xml formats. Kevin just had a baby girl (congratulations Kevin), so I'm not sure how active he'll be on his blog, but I'm sure he'll be checking every once in a while if you have any questions.

The snippets show how to do the following:

Excel Snippets

  • Add Custom UI
  • Delete Comments by a specific User
  • Delete Worksheet
  • Delete Excel 4.0 Macro sheets
  • Retrieve hidden rows or columns
  • Export Chart
  • Get Cell Value
  • Get Comments as XML
  • Get Hidden Worksheets
  • Get Worksheet Information
  • Get Cell for Reading
  • Get Cell for Writing
  • Insert Custom XML
  • Insert Header or Footer
  • Insert a Numeric Value into a Cell
  • Insert a String Value into a Cell
  • Set Recalc Option

PowerPoint Snippets

  • Delete Comments by User
  • Delete Slide by Title
  • Get Slide Count
  • Get Slide Titles
  • Modify Slide Title
  • Reorder Slides
  • Replace Image
  • Retrieve Slide Location by Title

Word Snippets

  • Accept Revisions
  • Add Header
  • Convert DOCM to DOCX
  • Remove Comments
  • Remove Headers and Footers
  • Remove Hidden Text
  • Replace Style
  • Retrieve Application Property
  • Retrieve Core Property
  • Retrieve Custom Property
  • Retrieve Table of Contents
  • Set Application Property
  • Set Core Property
  • Set Custom Property
  • Set Print Orientation

Doug Mahugh talks about arbitrary content within an Office Open XML file

Doug has a post where he talks more about the packaging conventions, and what you can to to put your own content into an Open XML file while still maintaining it's validity.

Technorati Profile