Re: XML to Excel

Hi Habib,

Using Excel 2003.
Also have Excel 2007 on a test machine. Behavior is same.

Try asking this in the Excel.programming and maybe an XML or
XSLT newsgroup. (BTW, what threw me was the reference to
"Cartesian" - if I'm following what's happening correctly,
it's not "Cartesian".)

You should be able to do something with an XSLT, but I'm not
conversant enough to be able to tell you how to do it in a
few words :-) Roughly, though, you'd have to restructure the
in-coming XML to a "flat table", as you describe. And then
you'd need another XSLT to change the structure back into
the nested XML schema the other end requires.

-- Cindy

.

Relevant Pages

  • Re: Using PHP to parse specific XML tag content?
    ... XML --> HTML transformation in testing environment. ... run just fine under Windows using Cygwin, and, unless I'm ... but you have to learn XSLT or use whatever defaults ...
    (comp.lang.php)
  • Subject: ANN: 4Suite XML 1.0b2
    ... 4Suite XML - XML, XPath, XSLT, related technologies and support ... 4Suite RDF - RDF processing libraries and stand-alone DBMS ...
    (comp.lang.python.announce)
  • EditiX 2.1 - XML Editor & XSLT Debugger
    ... We are glad to announce the availability of EditiX 2.1. ... cross-platform and easy to use XML Editor and XSLT Debugger designed to ... New docking windows for the XSLT Editor ...
    (comp.lang.java.softwaretools)
  • EditiX - XML/XSLT Editor 1.4.2
    ... XSLT, FO and XSD schemas. ... It includes default templates for XML, DTD, XHTML, ... Multiple file extensions is supported for a same document type ... Parts of the XSLT editor are now dockable ...
    (comp.lang.java.softwaretools)
  • Re: What is/is not considered to be good OO programming
    ... Brit programmers have common sense, ... XSLT is overblown and introduces ... Then your guys haven't learnt how to use XSL properly. ... > but XML, then use XSLT to style this output for the end user. ...
    (comp.lang.php)