Microformats and Open XML

Business Tax Forms » Microformats and Open XML

Business Tax Forms » Microformats and Open XML — Sun, 04 Mar 2007 16:20:11 GMT

PingBack from http://businesstaxform.com/microformats-and-open-xml/

re: Microformats and Open XML

Wouter — Mon, 05 Mar 2007 14:44:19 GMT

Dude, you're stealing my demos! :)

re: Microformats and Open XML

dmahugh — Mon, 05 Mar 2007 18:45:30 GMT

Hey, I thought you were busy this week. Ciao!

How microformats relate to custom XML

Brian Jones: Open XML Formats — Tue, 06 Mar 2007 00:57:37 GMT

I've blogged a few times about the support for custom defined schema in the OpenXML formats. ( http://blogs.msdn.com/brian_jones/archive/tags/Custom+Schema+Solutions/default.aspx

re: Microformats and Open XML

Shurik — Tue, 06 Mar 2007 09:49:52 GMT

Is it possible to add and reference custom XML parts in ECEL documents? I was able to add a reference to an external XML document, but can I do the same with a XML document built into the XLSX?

re: Microformats and Open XML

dmahugh — Tue, 06 Mar 2007 17:41:12 GMT

You can embed an XML document in an XLSX using the same mechanism you use for embedding it in a DOCX (as a custom XML part), but there is no support in spreadsheets for the 2-way data binding that can be used with content controls. One thing that compensates for this a bit is that the simplicty of the sheetdata content makes it easier to read and write data in the worksheet itself (as opposed to within a WordprocessingML document, which has more complex markup to navigate).

re: Microformats and Open XML

Shurik — Tue, 06 Mar 2007 21:53:04 GMT

Doug, you say "there is no support for 2-way data binding"? Does this mean that there is support for one-way databinding? :)

I am generating XLSX using XSLT, and for me it would be much easier to produce a bound custom XML part then XLSX markup.

Actually I can produce custom XML parts, but I cant bind them.

re: Microformats and Open XML

doncampbell — Wed, 07 Mar 2007 02:54:35 GMT

Hey nice write-up Doug. I think I finally understand Microformats conceptually now. I always wondered how it could be flexible enough to handle different formats in the XML. Thanks!

XBRL and Open XML

Doug Mahugh — Fri, 09 Mar 2007 22:27:28 GMT

As a brief follow-up to my post on microformats and Open XML , I'd like to show a slightly different

re: Microformats and Open XML

dmahugh — Mon, 12 Mar 2007 06:35:20 GMT

Shurik,

You can do 1-way binding of XML nodes in an *external* XML part to a spreadsheet. Is this what you want to do?

If you'd like to send me a sample XML part, I'll bind it to a spreadsheet and send you a sample. Very busy week this week, but feel free to send something if you'd like and I'll get to it in a few days. It's dmahugh at the usual place.

- Doug

re: Microformats and Open XML

Shurik — Thu, 15 Mar 2007 10:18:21 GMT

Doug,

I generate EXCEL files on a web server, and then users download autogenerated EXCELs by clicking on a link. So I need everything to be in a single file and external XML parts will not work for me :(

But anyway thank you for the clarification.

re: Microformats and Open XML

Jon Udell — Fri, 16 Mar 2007 05:43:03 GMT

Sounds good. I tried the paste operation and wound up with a bunch of angle brackets though. What's the procedure to get the data cleanly into the docx?

re: Microformats and Open XML

dmahugh — Fri, 16 Mar 2007 17:42:48 GMT

Hi Jon,

It's not clear to me what you did -- did you paste some XML into the custom XML part? If you paste directly into the document, then of course the tags and angle brackets are just text in the document and will appear as such.

In general, the answer to your question is that you just put XML in the custom XML part, which is a discrete file in the ZIP package that constitutes the docx. Then the XPath binding populates the content controls from the appropriate nodes in the custom XML part.

Feel free to send me a sample document if you'd like and I'll take a look.