Writing Large Excel Files with the Open XML SDK

In my last post, I showed you guys how to use the Open XML SDK to read and parse large Excel files. Today, I am going to show you how to write large Excel files with the Open XML SDK. Like in the case of reading, the Open XML SDK provides two approaches for writing…

6

Parsing and Reading Large Excel Files with the Open XML SDK

I want to thank you guys for leaving blog post requests. Today’s post will focus on one of your requests: parsing and reading large Excel files with the Open XML SDK. The Open XML SDK provides two approaches for parsing Open XML files: 1. using the SDK DOM, 2. using the SAX-like reading/writing capabilities. The…

13

Announcing the Release of the Open XML SDK 2.0

Today, I am really excited to announce the worldwide availability of the Open XML SDK 2.0 for Microsoft Office! The Open XML SDK plays an integral part in creating Office document solutions that work on the client or server. The Open XML SDK allows you to create, consume, and manipulate Open XML files without needing…

16

Finding Open XML Errors with Open XML SDK Validation

In a previous post, I gave you an overview of the functionality added to the Open XML SDK 2.0 August 2009 CTP. Today, I want to deep dive into the schema and semantic level validation support within the SDK. Specifically, I am going to show you guys the Open XML SDK code needed to actually…

2

Open XML SDK Code Snippets

In my previous post, I announced the release of the Open XML SDK August 2009 CTP. Today, I want to announce the release of the Open XML SDK code snippets. This package of code snippets provides over fifty reusable code samples, in both C# and VB.NET, which accomplish many common tasks involving Excel, PowerPoint, or…

8

Announcing the Release of the August 2009 CTP for the Open XML SDK

I’m really happy to announce the release of the 3rd CTP for the Open XML SDK 2.0 for Microsoft Office! So what did we do in this CTP? Well, there were three main improvements we made to the SDK: Add semantic level validation support Add markup compatibility/extensibility support General improvements based on your feedback Semantic…

4

Adding Repeating Data to PowerPoint

In a previous post, I showed you how to create a product catalog in a Word document using the Open XML SDK. I also showed you how to make PowerPoint a reporting application based on data within a database. Today, I am going to show you how to create a product catalog in a PowerPoint…

4

The Open XML SDK and Fluent UI Extensibility

Fluent UI, or the Ribbon, was introduced as part of Office 2007 as a replacement of the previous system of toolbars and menus. The Fluent UI technology, like the Open XML formats, is based on xml, which allows for a much richer extensibility story for developers. In Erika Ehril’s blog post she described several tools…

4

More on yesterday’s ODF announcement

Gray Knowlton had a great post yesterday laying out more of the details on the “Save as ODF” functionality that will be built in natively for Office 2007 SP2: http://blogs.technet.com/gray_knowlton/archive/2008/05/21/microsoft-adds-save-as-odf-to-office-2007-service-pack-2.aspx Even though ODF 1.0 is the official ISO version of the format, the decision was made to use version 1.1 which had some accessibility improvements….

18

Big Interoperability Announcement

I’m traveling right now and don’t have a lot of time to go really deep on this, but today’s interoperability announcement is great for Microsoft for a lot of reasons. Gray Knowlton posted on this today, it’s a great read if you want to understand how Office and file formats are affected. Here’s an excerpt…

22