Integrating with business data: Store custom XML in the Office XML formats

re: Integrating with business data: Store custom XML in the Office XML formats

Stuart Ballard — Sat, 05 Nov 2005 00:23:06 GMT

So what happens if you tell Word to use the ODF schema?

re: Integrating with business data: Store custom XML in the Office XML formats

orcmid — Mon, 07 Nov 2005 11:21:58 GMT

Stuart asks an interesting question. I guess the first problem is that the ODF schema is expressed in Relax-NG, not XSD, so someone would have to come up with an XSD to use.

But I think there's a bigger problem. You could certainly stuff some ODF XML parts into the Office "12" file, but if I understand Brian's description, this is not enough to have Word process them as part of the Word presentation. Notice that these additions are separated from the WordprocessingML and are not editable by the user in the way the WordprocessingML is.

And, finally, the schema doesn't say what the stuff means, only how it is arranged (as acceptable XML), so it would be mystery meat to Word. The rest is a small matter of programming [;<).

re: Integrating with business data: Store custom XML in the Office XML formats

WPoust — Mon, 07 Nov 2005 17:12:31 GMT

Sounds great! It sounds like it will eliminate the need for using custom document properties and merge fields. The farther away we get from dealing structured storage (and IDispatch interface interaction) the happier I'll be.

I'll be looking forward to a release version of Office 12 and released development libraries for zipped files.

re: Integrating with business data: Store custom XML in the Office XML formats

FARfetched — Tue, 08 Nov 2005 19:59:55 GMT

Echoing WPoust, sounds great -- and it looks like something that isn't currently in OpenOffice (although OOo does have a translation facility between ODF and some other XML formats).

My questions: 1) When can we see some examples? 2) Does this work on the MacOSX versions as well without limitations?

Where are the reference XSDs?

Ray Huger — Wed, 09 Nov 2005 19:40:45 GMT

I want to write my own app to make Office12 spreadsheets. To be sure I'm on the right track I need to validate using the reference XSDs. Where are they or when are they?

re: Integrating with business data: Store custom XML in the Office XML formats

BrianJones — Wed, 09 Nov 2005 21:40:26 GMT

FARfetched, I'll post some examples soon. We have the first Beta coming out in just a little bit, so I'll create some files with that and post them on this site.

Ray, I talked about the first draft of the Office 12 reference schemas in this post: http://blogs.msdn.com/brian_jones/archive/2005/09/14/466408.aspx

There should be an update to those schemas soon after we release Beta 1.

-Brian

Learning about Open XML on-line

OpenXML Developer — Mon, 27 Mar 2006 18:26:47 GMT

Links to blog posts that contain useful technical information for developers. Open XML is a new standard, but there's some good information already available if you know where to look.

re: Integrating with business data: Store custom XML in the Office XML formats

ScottD — Thu, 20 Jul 2006 20:07:21 GMT

[We then give you programmatic access to this data so you can read and write to the data while the user is editing the file. There is a full eventing model around this data as well so that if other processes make changes to the data you are notified.]--

This sounds like exaclty what I need, is there any place that I can get my hands on reference matierial for this functionality.