[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: Stephen D Green <stephengreenubl@gmail.com>
• To: Roger L Costello <costello@mitre.org>
• Date: Thu, 4 Aug 2022 20:16:38 +0100

A patented one? https://patents.google.com/patent/CN101968783B/en
----
Stephen D Green

On Thu, 4 Aug 2022 at 15:59, Roger L Costello <costello@mitre.org> wrote:
>
> 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
>

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