- From: William David Velasquez <wd@c...>
- To: Roger L Costello <costello@m...>
- Date: Thu, 04 Aug 2022 10:09:39 -0500
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: xml-dev-unsubscribe@l...
subscribe: xml-dev-subscribe@l...
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
[Date Prev]
| [Thread Prev]
| [Thread Next]
| [Date Next]
--
[Date Index]
| [Thread Index]
|
Cart
