using System;
using System.Data;

public static DataTable GetSampleData()
{
    DataTable dt = new DataTable();
    dt.Columns.Add("編號(hào)", typeof(int));
    dt.Columns.Add("姓名", typeof(string));
    dt.Columns.Add("成績(jī)", typeof(double));

    dt.Rows.Add(1, "張三", 88.5);
    dt.Rows.Add(2, "李四", 92.0);
    dt.Rows.Add(3, "王五", 76.3);

    return dt;
}

using Spire.Xls;
using System.Data;

class Program
{
    static void Main()
    {
        // 獲取示例數(shù)據(jù)
        DataTable dataTable = GetSampleData();

        // 創(chuàng)建 Workbook
        Workbook workbook = new Workbook();
        Worksheet sheet = workbook.Worksheets[0];

        // 將 DataTable 寫入工作表（true 表示包含列名）
        sheet.InsertDataTable(dataTable, true, 1, 1);

        // 保存 Excel 文件
        workbook.SaveToFile("普通寫入.xlsx", ExcelVersion.Version2016);
    }
}

using Spire.Xls;
using System.Data;
using System.Drawing;

class Program
{
    static void Main()
    {
        DataTable dataTable = GetSampleData();

        Workbook workbook = new Workbook();
        Worksheet sheet = workbook.Worksheets[0];

        // 寫入數(shù)據(jù)
        sheet.InsertDataTable(dataTable, true, 1, 1);

        // 獲取標(biāo)題行范圍
        CellRange titleRange = sheet.Range[1, 1, 1, dataTable.Columns.Count];
        titleRange.Style.Font.IsBold = true;  // 加粗
        titleRange.Style.HorizontalAlignment = HorizontalAlignType.Center; // 居中
        titleRange.Style.Color = Color.LightGray; // 背景色

        // 給所有單元格加邊框
        CellRange allRange = sheet.Range[1, 1, dataTable.Rows.Count + 1, dataTable.Columns.Count];
        allRange.BorderInside(LineStyleType.Thin, Color.Black);
        allRange.BorderAround(LineStyleType.Thin, Color.Black);

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

        workbook.SaveToFile("格式化寫入.xlsx", ExcelVersion.Version2016);
    }
}