在具有多个集合的c#中将XML转换为csv

using System;
using System.IO;
using System.Xml.Linq;

class Program
{
    static void Main()
    {
        // 加载XML文件
        XDocument doc = XDocument.Load("data.xml");

        // 创建CSV文件
        using (StreamWriter writer = new StreamWriter("data.csv"))
        {
            // 写入CSV标题行
            writer.WriteLine("Name, Age, City");

            // 遍历XML节点并将数据写入CSV文件
            foreach (XElement element in doc.Descendants("Person"))
            {
                string name = element.Element("Name").Value;
                int age = int.Parse(element.Element("Age").Value);
                string city = element.Element("City").Value;

                // 写入CSV数据行
                writer.WriteLine($"{name}, {age}, {city}");
            }
        }

        Console.WriteLine("XML转换为CSV成功！");
    }
}

<People>
  <Person>
    <Name>John</Name>
    <Age>30</Age>
    <City>New York</City>
  </Person>
  <Person>
    <Name>Alice</Name>
    <Age>25</Age>
    <City>London</City>
  </Person>
</People>