Browse by Tags

by Lawrence Hodson In this article I have a go at creating an Open XML Document using Microsoft’s excellent PowerShell command-line environment. To do so I use PowerTools for Open XML, recently updated on CodePlex ( http://www.codeplex.com/PowerTools ). As you’ll see it makes an otherwise difficult task...

by Lawrence Hodson (aka Sharky) For Microsoft .NET developers the Open XML SDK v2.0 promises a friendlier API for delving into the new Office document formats. It is built over the System.IO.Packaging API, but adds strongly-typed classes, so I thought I’ve give it a whirl. I’ve not used either API’s...

Displaying Open XML documents in Silverlight with TextGlow By James Newton-King The Office Open XML file format has opened up a new range of possibilities to working with documents. The Microsoft Office 2007 suite of products replaces the old binary formats and produces documents in a parser friendly...

You may have seen that the implementer notes for Office 2007 SP2 for ECMA-376 and ODF1.1 are now available. ECMA-376 Implementer Notes for Office 2007 SP2 On the ECMA-376 Implementer Notes Site you will find detailed information about Office’s support for the ECMA-376 specification . These notes will...

Open XML SDK V2. The first CTP of V2 of the Open XML SDK is now available for download. This release includes a high-level DOM (document object model) for Open XML development, as well as several tools to streamline Open XML development: The OpenXmlDiff utility identifies differences in the markup in...

The Open XML Power Tools, an open source project on Codeplex to create PowerShell cmdlets for automating Open XML document management tasks, has been released on Codeplex at http://www.codeplex.com/PowerTools . Non-developers can use these cmdlets to build PowerShell scripts that automate processes such...

Microsoft announced this week the release of Version 1 of the Open XML Formats SDK, an API that allows .NET developers to read, write, and modify Open XML documents. Follow these links to download the API or get more information: Open XML Formats SDK download link: http://go.microsoft.com/fwlink/?LinkId...

Article by Sheela E.N, Sonata Software Limited This article explains about changes made in Open XML SDK April 2008 CTP compared to Open XML SDK June 2007 CTP Open XML SDK provides a set of strongly typed classes to create and consume Office Open XML based documents (i.e Word 2007, Excel 2007 and PowerPoint...

Article by Mallika Biswas,Sonata software Limited. This article explains how to copy table content of a WordprocessingML document to a SpreadsheetML document using System.IO.Packaging API. Steps: 1. Take an existing word document having a table with any no of rows and column. 2. Write a XSLT code which...

Microsoft unveiled today the roadmap for the Open XML SDK that was released last June as a CTP (Community Technology Preview) version. After collecting developer feedback through the CTP release, they've put together a two-phased release plan to get developers a released version of the API quickly (May...

Article by Mallika Biswas, Sonata Software Limited This article explains how to delete footnotes and endnotes from an existing word document using System.IO.Packaging API in C# project. Steps to be followed: 1. Create a new C# project. Go to references, add the WindowsBase.dll. · Go to Add reference...

Article by Sheela E.N, Sonata Software Limited This article explains about how to delete track changes (revision) details from the SpreadsheetML document using System.IO.Packaging API in C# project. Whenever changes are made to the shared workbook, the information about the edit performed on each cell...

Article by Sheela E.N, Sonata Software Limited This article explains the process of adding mail merge in WordProcessingML using System.IO.Packaging API in C# project. 1. Create a C# project and a reference to WindowsBase.dll located at C:\Program Files\Reference Assemblies\Microsoft\Framework\v3.0 (This...

Article By - Sheela E.N, Sonata Software Limited This article explains the process of changing type of chart in a SpreadsheetML document programmatically using Open XML SDK API. In this article, we will be replacing a bar chart embedded in the excel work sheet to pie chart. We will be loading the pre...

MSDN has published a comprehensive set of videos of a 2-day Open XML developer workshop . These videos cover the content that was posted on OpenXMLDeveloper recently here . The instructors for this workshop were Doug Mahugh of Microsoft and Chris Predeek of the Ted Pattison Group , and the workshop was...

During the first half of 2007, trainers from Microsoft, Sonata, InfoSupport, Allette, Predeek Consulting and others delivered Open XML developer workshops in over 30 countries. These workshops were all structured around a set of inter-related presentations and hands-on labs that cover typical Open XML...

Article by - Sheela E.N, Sonata Software Limited Macro-enabled files (.docm) have the same file format as macro-free files (.docx), but contain additional parts that macro-free files do not. The Open XML format stores the various components of the document, the charts, graphics, macros, and other elements...

(Updated to v2) Greetings, Due to my work as an ISV DE in MS, I had just recently been requested by an organisation to produce a small demo to demonstrate how the new custom xml parts could help them deal with an issue that is causing them trouble. More specifically, they have many client stores that...

By Vijayeta Tilak of Sonata-Software Limited The Article describes an application which demonstrates the use of content controls and custom XML to map data to each of these content controls in the word document. This application uses System.IO.Packaging API (in .NET Framework 3.0) and is freely downloadable...

Several of the most active contributors to OpenXmlDeveloper were in Redmond last week for the MVP Summit and an Open XML workshop, so Doug Mahugh interviewed them on some Open XML development topics. The videos are up on Channel 9 at the links included below. Open-source Open XML API for Java Julien...

Mohammad Nour El-din Marwan of Cairo University's Computer Engineering Department has posted a detailed how-to article that covers the design of a set of classes for working with Open XML documents. His approach reflects a common business need: set up a standardized look and feel in a template, which...

By Vijayeta Tilak of Sonata Software Limited. This article describes an application that presents two existing presentation documents in a browser, with a drag&drop interface (implemented in JavaScript) for creating a new presentation from selected slides in the two existing presentations. This type...

By Vijayeta Tilak of Sonata Software Limited. The article describes an application that would display contents of a presentation document in a web page. This application, which basically uses a packaging architecture to read any PresentationML document and use a simple browser on any client machine,...

By Muthu Kumar Arjunan of Sonata Software Ltd. The previous articles in this series ( article1 , article 2 on XSL transformation of Spreadsheet ML to HTML – Part 1 & 2) explained an XSLT-based approach for displaying the data from a SpreadsheetML document in a web page (HTML). In continuation of...

Using the Packaging API and Office Open XML to create Excel 2007 files on the server by Dr. John Tunnicliffe Introduction The adoption of XML as the native file format for Excel 2007 has opened up a whole host of new possibilities. Now for the first time we can create native Excel files on the server...