SpreadsheetML

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Open XML Formats support accessibility in a number of ways. In explaining this support to its customers, partners and assistive technology vendors, Microsoft has created a preliminary draft report describing how Open XML compares to W3C Web Content Accessibility Guidelines and W3C XML Accessibility guidelines....

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

Exporting html data into Excel/spreadsheet ML by Muthu Kumar Arjunan of Sonata Softwares ltd explains how to export data from HTML to Excel/Spreadsheet ML document....

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

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 by Muthu Kumar Arjunan of Sonata Software Ltd. ...

This article explains how a generic xml file (generated from a Spreadsheet ML document) can be converted to HTML table that could be displayed in a browser, using XSLT by Muthukumar Arjunan of Sonata Software Ltd. This article caters to all those who are interested in learning how to convert XML to HTML table....