在ClosedXML C#中根据现有数据创建Excel数据表

using ClosedXML.Excel;

XLWorkbook workbook = new XLWorkbook();
var worksheet = workbook.Worksheets.Add("Sheet1");

// 假设现有数据存储在一个二维数组中
string[,] data = new string[,]
{
    {"Name", "Age", "City"},
    {"John", "25", "New York"},
    {"Alice", "30", "London"},
    {"Bob", "35", "Paris"}
};

// 将数据逐行添加到工作表中
for (int row = 0; row < data.GetLength(0); row++)
{
    for (int col = 0; col < data.GetLength(1); col++)
    {
        worksheet.Cell(row + 1, col + 1).Value = data[row, col];
    }
}

worksheet.Range("1:1").Style.Font.Bold = true;

workbook.SaveAs("path/to/file.xlsx");