The Palos Publishing Company

Follow Us On The X Platform @PalosPublishing
Categories We Write About

Convert XML to user-friendly reports

Written by

Bernardo Palos

in

Converting XML to user-friendly reports involves parsing the XML structure, extracting relevant data, and formatting it into a readable format like HTML, PDF, Excel, or plain text. Below is a general guide and code example in Python that demonstrates how to convert XML data into a human-readable HTML report. This example can be adapted for other formats too.

Step 1: Sample XML Input

xml
<employees>
    <employee>
        <id>101</id>
        <name>John Doe</name>
        <department>Finance</department>
        <email>john.doe@example.com</email>
    </employee>
    <employee>
        <id>102</id>
        <name>Jane Smith</name>
        <department>Engineering</department>
        <email>jane.smith@example.com</email>
    </employee>
</employees>

Step 2: Python Script to Convert XML to HTML Report

python
import xml.etree.ElementTree as ET

def xml_to_html_report(xml_data):
    root = ET.fromstring(xml_data)
    html = """
    <html>
    <head><style>
    table {font-family: Arial, sans-serif; border-collapse: collapse; width: 100%;}
    td, th {border: 1px solid #dddddd; text-align: left; padding: 8px;}
    th {background-color: #f2f2f2;}
    </style></head>
    <body>
    <h2>Employee Report</h2>
    <table>
        <tr><th>ID</th><th>Name</th><th>Department</th><th>Email</th></tr>
    """

    for emp in root.findall('employee'):
        id = emp.find('id').text
        name = emp.find('name').text
        dept = emp.find('department').text
        email = emp.find('email').text
        html += f"<tr><td>{id}</td><td>{name}</td><td>{dept}</td><td>{email}</td></tr>"

    html += "</table></body></html>"
    return html

# Example Usage
xml_input = """<employees>...</employees>"""  # Insert full XML here
report_html = xml_to_html_report(xml_input)

# Save to file
with open("employee_report.html", "w") as file:
    file.write(report_html)

Step 3: Output Formats

Depending on your needs, the report can also be converted to:

  • PDF using WeasyPrint or pdfkit

  • Excel using pandas + openpyxl

  • CSV using csv module

  • Plain text using string formatting

Example: Convert to CSV

python
import csv
import xml.etree.ElementTree as ET

def xml_to_csv(xml_data, output_file):
    root = ET.fromstring(xml_data)
    with open(output_file, mode='w', newline='') as file:
        writer = csv.writer(file)
        writer.writerow(['ID', 'Name', 'Department', 'Email'])

        for emp in root.findall('employee'):
            row = [
                emp.find('id').text,
                emp.find('name').text,
                emp.find('department').text,
                emp.find('email').text
            ]
            writer.writerow(row)

Tips for User-Friendly Reports

  • Add sorting or filters if generating HTML tables.

  • Use libraries like Jinja2 for templated HTML.

  • Group data logically (e.g., by department).

  • Add visual cues like alternating row colors or section headings.

Let me know your XML structure or desired output format if you want a custom report generator.

Share this Page your favorite way: Click any app below to share.
See all the ways to share this page

Enter your email below to join The Palos Publishing Company Email List

We respect your email privacy

Check Out Our Newest Posts we wrote about

Categories We Write About