使用c#将xml (混合节点和属性)转换为csv文件

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Xml.Linq;

public static class XmlToCsvConverter
{
    public static void ConvertXmlToCsv(string xmlFilePath, string csvFilePath)
    {
        XDocument xmlDoc = XDocument.Load(xmlFilePath);

        // 获取XML中的所有元素
        var elements = xmlDoc.Descendants().ToList();

        // 提取CSV表头
        var headers = elements
            .SelectMany(e => e.Attributes().Select(a => a.Name.ToString()))
            .Distinct()
            .ToList();

        // 将表头写入CSV文件
        using (StreamWriter writer = new StreamWriter(csvFilePath, false, Encoding.UTF8))
        {
            writer.WriteLine(string.Join(",", headers));
        }

        // 提取元素数据并写入CSV文件
        foreach (var element in elements)
        {
            using (StreamWriter writer = new StreamWriter(csvFilePath, true, Encoding.UTF8))
            {
                var values = headers.Select(header => GetElementValue(element, header));
                writer.WriteLine(string.Join(",", values));
            }
        }
    }

    private static string GetElementValue(XElement element, string attributeName)
    {
        XAttribute attribute = element.Attributes()
            .FirstOrDefault(a => a.Name.ToString().Equals(attributeName, StringComparison.OrdinalIgnoreCase));

        return attribute?.Value ?? string.Empty;
    }
}

string xmlFilePath = "path/to/xml/file.xml";
string csvFilePath = "path/to/csv/file.csv";

XmlToCsvConverter.ConvertXmlToCsv(xmlFilePath, csvFilePath);