[prev in list] [next in list] [prev in thread] [next in thread] 

List:       xml-dev
Subject:    Re: [xml-dev] Is there a tool that converts a plain vanilla XML document into an Excel document?
From:       Stephen D Green <stephengreenubl () gmail ! com>
Date:       2022-08-04 19:16:38
Message-ID: CAA0AChVVs5SumFfuv-7Rd01Dymc0L2115ygGBOa7zckWW72kSw () mail ! gmail ! com
[Download RAW message or body]

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
> 

_______________________________________________________________________

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


[prev in list] [next in list] [prev in thread] [next in thread]