XML.orgXML.org
FOCUS AREAS |XML-DEV |XML.org DAILY NEWSLINK |REGISTRY |RESOURCES |ABOUT
OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index]
Re: [xml-dev] Is there a tool that converts a plain vanilla XMLdocument into an Excel document?

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
>


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index]


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 1993-2007 XML.org. This site is hosted by OASIS