Re: Is there a tool that converts a plain vanilla XML document into an Excel document?

You can use this XQuery in BaseX (maybe it works in other XQuery 
engines) to convert to CSV and open it directly in Excel and other 
Worksheets:

     let $source := doc( "path\to\your\XML\file" )
     return csv:serialize( $source/*, map { "header": true() } )




El 2022-08-04 09:59, Roger L Costello escribió:
> 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: [email protected]
> subscribe: [email protected]
> 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

_______________________________________________________________________

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: [email protected]
subscribe: [email protected]
List archive: http://lists.xml.org/archives/xml-dev/
List Guidelines: http://www.oasis-open.org/maillists/guidelines.php