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:
> subscribe:
> 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
