Revision history [back]

There are different ways to transform an XML hierarchical arrangement to CSV using Groovy. One of them is by using the XmlSlurper and the CSVWriter classes. Here is an example code:

import groovy.xml.*

def xml = '''
<books>
  <book>
    <title>Java in Action</title>
    <author>John Doe</author>
    <publisher>Publisher A</publisher>
    <year>2010</year>
    <price>20.00</price>
  </book>
  <book>
    <title>Python for Beginners</title>
    <author>Jane Smith</author>
    <publisher>Publisher B</publisher>
    <year>2015</year>
    <price>15.00</price>
  </book>
</books>
'''

def books = new XmlSlurper().parseText(xml)

def writer = new CSVWriter(new FileWriter('books.csv'))

writer.writeNext(['Title', 'Author', 'Publisher', 'Year', 'Price'])

books.book.each { book ->
    def title = book.title.text()
    def author = book.author.text()
    def publisher = book.publisher.text()
    def year = book.year.text()
    def price = book.price.text()
    writer.writeNext([title, author, publisher, year, price])
}

writer.close()

In this example, the input is an XML string that represents a collection of books. The XmlSlurper class parses the XML and creates a nested data structure that is easy to navigate with dot notation. The CSVWriter class is used to create a CSV file and write the header and rows of data. The data is extracted from the XML hierarchy, transformed into an array, and written to the CSV file using the writeNext method. Finally, the CSV file is closed.

Note that the example assumes that the XML input is well-formed and has a predictable structure. If the XML input has variations, conditional logic may be required to handle them correctly. Additionally, if the XML input is large, it may be preferable to use streaming or incremental processing to avoid excessive memory consumption.