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

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

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

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

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 to a Word document...

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

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 you have any specific...

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

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 a mostly Microsoft...

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

I'm going to try to get back on top of all the e-mails folks have been sending me. If you've e-mailed me over the past 6 months the odds are that I didn't reply yet, and I'm sorry about that. I'll start reading through the e-mails again and rather than just replying directly I'll actually try to post...

I saw this blog post from Rob Wier the other day, and I thought it would be worth drilling into a bit more. While Rob tends to have a flare for the dramatics he does point out a couple of good bugs in the formulas piece of the Open XML spec. Rob's actually been spending a ton of time lately pouring through...

Over 5 months later, I've finally had some free time to pull together part 3 of my "Intro to SpreadsheetML" posts. I'll pick up where I left off in Part 2, so if you need a little refresher, please head back to the first 2 posts: Simple SpreadsheetML file Part 1 – Create a simple table of data...

Erika is working on pulling together more coding examples for the OpenXML formats. We've seen a bunch of stuff around WordprocessingML, and now they are starting to work on some good examples with SpreadsheetML and PresentationML. So if you've ever wanted to build processes that consumed or generated...

Datawatch just announced the availability of Monarch V.9.0 which has the ability to output rich spreadsheet reports on data leveraging SpreadsheetML: http://www.datawatch.com/datawatch/news.asp?display=detail&id=128 This is pretty cool because they take advantage of the 300 pages of spreadsheet...

I missed this last week: http://blogs.sun.com/GullFOSS/entry/office_open_xml_import_filter It looks like some folks in Sun are working on support for Ecma 376's SpreadsheetML format within Open Office: The development of a new spreadsheet import filter has been started in the Calc project. This...

Happy New Year everyone. I hope everyone was able to enjoy the holiday season. I took a couple weeks off in case you were wondering why there weren't any new blog posts. While I took some time off, I did still get a chance to play around with the file formats (I think I have a serious problem with...

This is a continuation on the " Simple SpreadsheetML file Part 1 " post I made a couple weeks ago. In that post we created a SpreadsheetML file that consisted of a simple table with 3 columns and 3 rows of data (plus a header row). The table looked like this: Sub Total...

I posted a bunch of "Intro to SpreadsheetML" posts about a year or so ago, but those were all based on the Office XP spreadsheetML format. I think an updated series based on the Open XML standard is long overdue. I'll start off just building a simple table, and in future posts show more about formatting...

I've blogged in the past about some of the things we did with the SpreadsheetML format to help improve the performance of opening and saving those files. While a file format most likely won't affect the performance of an application once the file is loaded, it can significantly impact the performance...

Recently a couple people have questioned the decision to leave the legacy Excel date behavior in the Open XML formats. This was primarily triggered by a post from IBM's Rob Wier . While those folks have referred to it as an Excel bug, it's actually something that was purposely designed into Excel since...

I wanted to follow up on the thread I started a couple weeks ago discussing the design goals behind spreadsheetML. There's a whole host of things we've done to make sure that the move to XML formats is a huge benefit to developers, without it actually having a significant negative impact on our end users...

It's been awhile since I've talked in detail about the SpreadsheetML schema and I apologize. I had a number of posts back in the summer which talked through Office XP's SpreadsheetML format that we built about 6 years ago, but obviously a lot has changed since then. The new SpreadsheetML that is part...