浣犲彲浠ヤ娇鐢‥xcelDataReader鍜孋losedXML搴撴潵灏咰#鐨凞ataset瀵煎嚭涓篍xcel鏂囦欢銆備互涓嬫槸涓€涓ず渚嬩唬鐮侊細

using System;
using System.Data;
using System.IO;
using ExcelDataReader;
using ClosedXML.Excel;

public static void ExportDatasetToExcel(DataSet dataset, string filePath)
{
    var workbook = new XLWorkbook();
    
    foreach (DataTable dt in dataset.Tables)
    {
        var worksheet = workbook.Worksheets.Add(dt.TableName);

        // 鍐欏叆鍒楀悕
        for (int i = 0; i < dt.Columns.Count; i++)
        {
            worksheet.Cell(1, i + 1).Value = dt.Columns[i].ColumnName;
        }

        // 鍐欏叆鏁版嵁
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            for (int j = 0; j < dt.Columns.Count; j++)
            {
                worksheet.Cell(i + 2, j + 1).Value = dt.Rows[i][j];
            }
        }
    }

    workbook.SaveAs(filePath);
}

鍦ㄨ繖涓ず渚嬩腑锛屾垜浠鍏堝垱寤轰竴涓猉LWorkbook瀵硅薄锛岀劧鍚庨亶鍘咲ataset涓殑姣忎釜DataTable銆傚浜庢瘡涓狣ataTable锛屾垜浠垱寤轰竴涓伐浣滆〃锛屽苟灏嗗垪鍚嶅拰鏁版嵁鍐欏叆宸ヤ綔琛ㄣ€傛渶鍚庯紝鎴戜滑浣跨敤workbook.SaveAs(filePath)灏咵xcel鏂囦欢淇濆瓨鍦ㄦ寚瀹氱殑璺緞涓嬨€?/p>

瑕佷娇鐢‥xcelDataReader鍜孋losedXML搴擄紝浣犻渶瑕佸湪Visual Studio涓畨瑁呰繖涓や釜搴撱€傚彲浠ラ€氳繃NuGet鍖呯鐞嗗櫒鏉ュ畨瑁呰繖涓や釜搴撱€?/p>