Here is a simple WordPress plugin that extrapolates a set of data from Piwik – which is an open source real time web analytics application and update a pivot table in an excel document.

The plugin captures the users Piwik API key and display a link to an excel document on a custom dashboard widget.

To read the full article click here.

This article will show you how to build an add-in to PowerPoint that will look at every slide that is shown, and if the slide has been tagged with a Twitter tag, it will insert the latest Tweets in it. Actually, it won’t, but it will look like that. What actually happens is that the add-in copies the current slide into a new temporary slideshow and saves it to disk. It then calls on a class called Twitterizer that will get the latest Tweets and then use the Open XML SDK to add the tweets to the slide and save the temporary slideshow again. The add-in will then read the updated slideshow, copy the “twitterized” slide back into the current slideshow and tell PowerPoint to show it. As the slideshow moves to a new slide, the “twitterized” slide is deleted from the slideshow.

To view the full article click here.

The goal with this article is, as I mentioned before, to create a relatively simple spreadsheet implementation based on the Ag.OpenXML library off Codeplex. It will result in an application that can create a spreadsheet document with a table and a formula based cell.

To see the entire article click here.

Microsoft has released an RTM version of Open XML SDK 2.0 for Microsoft Office today. The SDK is a collection of classes that let developers create and manipulate Open XML documents – documents that adhere to the Office Open XML File Formats Standard. Because the SDK provides an application program interface that lets developers manipulate Open XML documents directly, they can do so without the need for the Office client products themselves in both client and server operating environments.

 

Open XML SDK 2.0 for Microsoft Office offers a number of tools and resources to improve programmatic document processing thus making a task of the developer more efficient. The SDK also carries an interoperability improvements for open XML implementers as well as it is  designed to let Open XML developers build high performance client-side or server-side solutions that handle complex operations using only a small amount of program code.

 

To discuss issues and questions related to Open XML SDK 2.0 click here.

To view the article click here.

Read the full interview with Eric White here.

Eric White is a Technical Writer for Microsoft who focuses on SharePoint, Office, and Open XML.

In this interview we talk to Eric about topics such as the synergies between functional programming and Open XML, aswell as the transformation of Open XML documents into other forms.

As the Open XML SDK is not available for Silverlight developers, Chris Klug set out to create a tiny library with few pre-built features that was flexible and easy to modify and extend.

This sample aims to show how to use this library to create Word documents as well as how to extend it to support new features. It will also show how the existing library can create simple Word documents with text and styles, as well as how you can add support for features that are missing. In this case I will focus on how to implement support for headers and footers.

To view the full article click here.

There are two new Open XML videos available.  To view them click the links below:

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. To view the video click here.

Wouter Van Vugt is the architect of Package Explorer, and Doug Mahugh sat down with Wouter in Building 20 recently to discuss the status of the program and see a demonstration of some of its recently added new functionality. If you're doing Open XML development, this utility is a must-have for your Open XML toolbox! To view the video click here.