ISO/IEC publishes the Office Open XML specification

There was some great news yesterday for those of you waiting to see what the final version of the Open XML specification would look like after the BRM resolutions were applied. ISO/IEC 29500 is now published in its final form: http://www.iso.org/iso/pressrelease.htm?refid=Ref1181 As I mentioned in an earlier post, I’m no longer quite as directly involved…

4

Creating a Presentation Report Based on Data

In my last two posts, I showed you how to create a spreadsheet based on data and how to read data from spreadsheet. Today, I am going to move away from SpreadsheetML to talk about PresentationML. Specifically, I am going to show you how to create a rich presentation report based on data from a…

4

Writing semantically aware LINQ queries against Excel tables

I hope you all have been enjoying Zeyad’s articles showing some of the powerful solutions you can build leveraging the Open XML API. Thanks for pulling these all together Zeyad, and I look forward to seeing some of the other solutions we’ve talked about. Today, there is a new post from Eric White that you…

1

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

Document Assembly Solution for SpreadsheetML

In my last post I gave a high level overview of the architecture of the SDK. Now that we’ve gone over the basics, we’re ready to talk about some real world solutions and end-to-end scenarios. Based on feedback I heard from you guys, I will start with scenarios and solutions around SpreadsheetML. Let me know…

14