Browse by Tags

Most users of Microsoft Office are aware that you can directly embed an Excel spreadsheet (XLSX) in a Word document (DOCX). In Open XML terms, the XLSX is stored in a binary part. In addition, there is an image of the view of that spreadsheet, also in its own separate part. This screen-cast shows how...

Sometimes developers need to create huge spreadsheets, perhaps with 100's of thousands of rows, and many columns. A worksheet that contains 1,000,000 rows and 10 columns will contain upwards of 20,000,000 nodes in the worksheet part. This presents a problem when using a DOM approach. Both XmlDocument...

When working with SpreadsheetML, one of the most common needs is to retrieve the data from a worksheet or a table in as easy a fashion as possible. There has been a fair amount written for C# developers to do this, but not nearly as much for VB.NET. Some time ago, I wrote a blog post, Using LINQ to Query...

Last week, the Office Interoperability team updated the Learn Open Specifications and Interoperability page in the Open Specifications Developer Center . This update features the debut of the Open Specifications Interactive Pivot, 9 new learning modules, and one new article. Check out the Open Specifications...

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...

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 Chhavi Kumar Agrawal, Sonata Software Limited This article explains about line shape and how line properties like color, width, and head/tail etc details of line shape are represented in DrawingML language within drawing part stored in SpreadsheetML document. The line shape inserted on the...

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 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...

The attached white paper broadly describes how DrawingML is different from Scalable Vector Graphics (SVG) in terms of design goals, target audience and the problem areas intended to address. This paper hopes to raise the level of awareness and education of “Why DrawingML cannot be merged with SVG” In...

Article by Sheela E.N, Sonata Software Limited This article explains how header and footer details and the style applied are stored in SpreadsheetML document and the options that are available in Office Open XML file format to apply header, footer in SpreadsheetML document. When applying header/footer...

Article by Sheela E.N, Sonata Software Limited This article explains the DrawingML implementation in Spreadsheet and how a drawing object is stored in SpreadsheetML using DrawingML. When an image/picture is inserted in a Spreadsheet document, DrawingML specifies the location and appearance of drawing...

Article by - Sheela E.N, Sonata Software Limited The XML mapping feature enables us to add arbitrary XML data structures and XML schema definitions to the workbook and map XML nodes to cells and cell ranges in the workbook. Once the mapping is set up, the application will be able to import and export...

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...

This article has upated versions of the simple sample Open XML documents that were posted in March 2006. The latest versions attached here were created with the shipping version of the 2007 Microsoft Office system as of August 2007.

Attached is a downloadable copy of "Open XML Explained" by Wouter Van Vugt, the first book on Open XML development. The sample documents for the book are also available for download here . This 128-page book covers the basics of Open XML, including many of the topics covered in the Open XML developer...

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...

Update: I've updated this paper based on feedback I've received from the community. I'd like to thank those people who have provided support in helping clarify the level of Accessibility in the specification. This report is still in DRAFT form. Again, it is intended to serve as a basis for public comment...

Author: Maarten Balliauw This article covers the dynamic creation of invoices using PHPExcel ( www.codeplex.com/phpexcel ). It covers the example code “05featuredemo.php” which can be found in the PHPExcel package project on Codeplex. Here's what the output document will look like: Getting started… First...

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...

By Muthu Kumar Arjunan of Sonata Software Ltd. This article explains how to “Page” an HTML table generated from Spreadsheet ML document, using XSL transformation & XMLHttp & Java Script . “ XSL transformation of Spreadsheet ML to HTML – Part 1 ” dealt with conversion of spreadsheet ML document...