[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: Is there a tool that converts a plain vanilla XMLdocument

• From: William David Velasquez <wd@creativosdigitales.co>
• To: Roger L Costello <costello@mitre.org>
• Date: Thu, 04 Aug 2022 10:09:39 -0500

Hi Folks,

I have a plain, vanilla XML document with a root element that contains
a bunch of <row> elements and each <row> element contains fields,
e.g.,

<document>
    <row>
        <field1>ABC</field1>
        <field2>DEF</field2>
        <field3>GHI</field3>
    </row>
    ...
</document>

To display that XML document in Excel requires a bunch of steps:

1. Click on the Developer tab
2. Click on the Source icon
3. Click on the XML Maps button
4. Click on the Add button
5. Navigate to the folder containing the XML document
6. Click on the XML document
7. Click on the OK button
8. Drag "row" over to the Excel cell
9. Click on the Developer tab again
10. Click on Import
11. Select the XML document again

Phew! That's a lot of work to get Excel to display the XML document.

Is there a tool that takes a plain, vanilla XML document and converts
it into an Excel document?

/Roger

_______________________________________________________________________

XML-DEV is a publicly archived, unmoderated list hosted by OASIS
to support XML implementation and development. To minimize
spam in the archives, you must subscribe before posting.

[Un]Subscribe/change address: http://www.oasis-open.org/mlmanage/
Or unsubscribe: xml-dev-unsubscribe@lists.xml.org
subscribe: xml-dev-subscribe@lists.xml.org
List archive: http://lists.xml.org/archives/xml-dev/
List Guidelines: http://www.oasis-open.org/maillists/guidelines.php

--
William David Velasquez
Creativo de Software
Creativos Digitales S.A.S.
Tel 311 7098421 - 604 3221730

• References:
  • Is there a tool that converts a plain vanilla XML document into anExcel document?
    • From: Roger L Costello <costello@mitre.org>