using Spire.Xls;

public class Product
{
    public int ID { get; set; }
    public string Name { get; set; }
    public decimal Price { get; set; }
    public DateTime ManufactureDate { get; set; }
    public bool IsAvailable { get; set; }
}

using Spire.Xls;
using System;
using System.Collections.Generic;

public class ExcelExporter
{
    public static void ExportProductsToExcel(List<Product> products, string filePath)
    {
        Workbook workbook = new Workbook();
        Worksheet sheet = workbook.Worksheets[0];
        sheet.Name = "產(chǎn)品列表";

        int row = 1;

        // 寫入表頭
        sheet.Range[row, 1].Value2 = "ID";
        sheet.Range[row, 2].Value2 = "Name";
        sheet.Range[row, 3].Value2 = "Price";
        sheet.Range[row, 4].Value2 = "ManufactureDate";
        sheet.Range[row, 5].Value2 = "IsAvailable";

        row++;

        // 寫入數(shù)據(jù)
        foreach (var product in products)
        {
            sheet.Range[row, 1].Value2 = product.ID;
            sheet.Range[row, 2].Value2 = product.Name;
            sheet.Range[row, 3].Value2 = (double)product.Price;
            sheet.Range[row, 4].Value2 = product.ManufactureDate;
            sheet.Range[row, 5].Value2 = product.IsAvailable;
            row++;
        }

        // 自動(dòng)調(diào)整列寬
        sheet.AllocatedRange.AutoFitColumns();

        // 設(shè)置標(biāo)題樣式
        var headerRange = sheet.Range[1, 1, 1, 5];
        headerRange.Style.Font.IsBold = true;
        headerRange.Style.HorizontalAlignment = HorizontalAlignType.Center;

        workbook.SaveToFile(filePath, ExcelVersion.Version2016);
        workbook.Dispose();
    }

    public static void Main(string[] args)
    {
        List<Product> productList = new List<Product>
        {
            new Product { ID = 1, Name = "筆記本電腦", Price = 8999.00M, ManufactureDate = new DateTime(2023, 1, 15), IsAvailable = true },
            new Product { ID = 2, Name = "無線鼠標(biāo)", Price = 129.50M, ManufactureDate = new DateTime(2023, 3, 10), IsAvailable = true },
            new Product { ID = 3, Name = "機(jī)械鍵盤", Price = 599.00M, ManufactureDate = new DateTime(2022, 11, 20), IsAvailable = false },
            new Product { ID = 4, Name = "顯示器", Price = 1999.99M, ManufactureDate = new DateTime(2023, 2, 5), IsAvailable = true },
            new Product { ID = 5, Name = "SSD硬盤", Price = 650.00M, ManufactureDate = new DateTime(2023, 4, 1), IsAvailable = true }
        };

        string outputPath = "ProductsExport.xlsx";
        ExportProductsToExcel(productList, outputPath);
    }
}

sheet.Range[row, 4].Style.NumberFormat = "yyyy-mm-dd";

sheet.Range[row, 3].Style.NumberFormat = "￥#,##0.00";