<Products>
  <Product id="P001">
    <Name>Laptop</Name>
    <Category>Electronics</Category>
    <Price>1200.00</Price>
    <Stock>50</Stock>
  </Product>
  <Product id="P002">
    <Name>Mouse</Name>
    <Category>Electronics</Category>
    <Price>25.00</Price>
    <Stock>200</Stock>
  </Product>
</Products>

Install-Package Spire.XLS

using System;
using System.Xml.Linq;
using Spire.Xls; // 引入Spire.Xls命名空間

public class XmlToExcelConverter
{
    public static void ConvertXmlToExcel(string xmlFilePath, string excelFilePath)
    {
        // 假設XML文件內(nèi)容如上所示
        string xmlContent = @"
<Products>
  <Product id='P001'>
    <Name>Laptop</Name>
    <Category>Electronics</Category>
    <Price>1200.00</Price>
    <Stock>50</Stock>
  </Product>
  <Product id='P002'>
    <Name>Mouse</Name>
    <Category>Electronics</Category>
    <Price>25.00</Price>
    <Stock>200</Stock>
  </Product>
</Products>";

        XDocument doc;
        try
        {
            // 從字符串加載XML，也可以使用 XDocument.Load(xmlFilePath) 從文件加載
            doc = XDocument.Parse(xmlContent); 
            Console.WriteLine("XML數(shù)據(jù)加載成功。");
        }
        catch (Exception ex)
        {
            Console.WriteLine($"加載XML數(shù)據(jù)時發(fā)生錯誤: {ex.Message}");
            return;
        }

        // ... 后續(xù)寫入Excel的代碼
    }
}

// ... 承接上一步的 ConvertXmlToExcel 方法

        // 創(chuàng)建一個新的工作簿
        Workbook workbook = new Workbook();
        Worksheet sheet = workbook.Worksheets[0]; // 獲取第一個工作表

        // 設置列標題
        sheet.Range["A1"].Text = "產(chǎn)品ID";
        sheet.Range["B1"].Text = "產(chǎn)品名稱";
        sheet.Range["C1"].Text = "類別";
        sheet.Range["D1"].Text = "價格";
        sheet.Range["E1"].Text = "庫存";

        // 遍歷XML數(shù)據(jù)并寫入Excel
        int row = 2; // 從第二行開始寫入數(shù)據(jù)，第一行是標題
        foreach (XElement product in doc.Descendants("Product"))
        {
            // 從XML節(jié)點提取數(shù)據(jù)
            string productId = product.Attribute("id")?.Value;
            string productName = product.Element("Name")?.Value;
            string category = product.Element("Category")?.Value;
            string price = product.Element("Price")?.Value;
            string stock = product.Element("Stock")?.Value;

            // 將數(shù)據(jù)寫入Excel單元格
            sheet.Range[$"A{row}"].Text = productId;
            sheet.Range[$"B{row}"].Text = productName;
            sheet.Range[$"C{row}"].Text = category;
            
            // 嘗試將價格和庫存轉(zhuǎn)換為數(shù)字類型，以便Excel正確處理
            if (decimal.TryParse(price, out decimal dPrice))
            {
                sheet.Range[$"D{row}"].NumberValue = (double)dPrice;
            }
            else
            {
                sheet.Range[$"D{row}"].Text = price;
            }

            if (int.TryParse(stock, out int iStock))
            {
                sheet.Range[$"E{row}"].NumberValue = iStock;
            }
            else
            {
                sheet.Range[$"E{row}"].Text = stock;
            }
            
            row++;
        }

        // 自動調(diào)整列寬，使內(nèi)容可見
        sheet.AllocatedRange.AutoFitColumns();

        // ... 后續(xù)保存Excel的代碼

// ... 承接上一步的代碼

        try
        {
            workbook.SaveToFile(excelFilePath, ExcelVersion.Version2016); // 保存為Excel 2016格式
            Console.WriteLine($"Excel文件已成功保存到: {excelFilePath}");
        }
        catch (Exception ex)
        {
            Console.WriteLine($"保存Excel文件時發(fā)生錯誤: {ex.Message}");
        }
        finally
        {
            workbook.Dispose(); // 釋放資源
        }
    }

    public static void Main(string[] args)
    {
        string xmlFile = "products.xml"; // 實際應用中可以是文件路徑
        string excelFile = "ProductsReport.xlsx";
        ConvertXmlToExcel(xmlFile, excelFile);
    }
}

// ... 在設置列標題之后，寫入數(shù)據(jù)之前

        // 設置標題行的樣式
        sheet.Range["A1:E1"].Style.Font.IsBold = true; // 加粗
        sheet.Range["A1:E1"].Style.KnownColor = ExcelKnownColor.LightGreen; // 設置背景色
        sheet.Range["A1:E1"].Style.HorizontalAlignment = HorizontalAlignType.Center; // 居中對齊

// ...