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

Removing Comments from Excel and PowerPoint Files

In a previous post, I showed you how to remove comments from a Word file. In today’s post, I am going to show you how to accomplish the same scenario, but this time with Excel and PowerPoint files. Excel and PowerPoint have a Document Inspector feature, which is able to remove multiple types of data/content,…

8

Importing a Table from WordprocessingML to SpreadsheetML

In a previous post, I showed you how to import charts from spreadsheets to a Wordprocessing document. Today, as promised in my last post, I am going to show you how to import a table from a Wordprocessing document into a spreadsheet. Solution To import a table from a Wordprocessing document to a spreadsheet we…

4

Importing Charts from Spreadsheets to Wordprocessing Documents

There have been several requests made by people asking how to import a chart from one document type to another document type. In a previous post, I showed you how to push data into a spreadsheet to create a chart. Today, I am going to show you how to import a chart from a spreadsheet…

6

How to Copy a Worksheet within a Workbook

As promised in my previous post about reusable methods for manipulating WordprocessingML, I mentioned I would write a post on how to copy a worksheet within a workbook. Note that this blog post talks about copying a worksheet within the same package. Perhaps sometime in the future I will write a post on how to…

5

Reading Data from SpreadsheetML

In my last post, I showed you how to create a spreadsheet based on data from a database using the Open XML SDK. Today I am going to show you how to do the reverse, specifically, how to read data from a spreadsheet and insert it into some data source, like a database. Again, if…

6

Why there’s no “Microsoft” in Open XML

Here are a couple cool screenshots from Stephen McGibbon where he shows an OpenXML spreadsheet file created with Gnumeric (runs on Linux & Windows), and the file is then opened up in Numbers (Apple’s new spreadsheet app for the Mac). Gnumeric Numbers This is pretty cool as it shows how the Open XML formats allow…

100

Going offline for a week

I’ll be offline for the next week or so. Sorry if I don’t answer your e-mails or comments during that time. I’ll try to get caught up early August. In the mean time though, check out this article up on eweek: Setting a New Standard As a user of OpenOffice.org on Linux who works in…

5

Open XML news

Here are a few interesting links related to the Open XML formats US technical committee reaches deadlock – Doug talks about how the discussions went in the US technical committee tasked with reviewing the Open XML formats. It sounds like they were just one vote short of getting approval, which means it’s now off to…

1