在C# excel导出中设置列名/数据的循环

using OfficeOpenXml;
using System;
using System.Collections.Generic;
using System.IO;

namespace ExcelExportExample
{
    class Program
    {
        static void Main(string[] args)
        {
            // 创建ExcelPackage对象
            ExcelPackage excelPackage = new ExcelPackage();

            // 添加一个名为"Sheet1"的工作表
            ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Sheet1");

            // 设置列名
            List<string> columnNames = new List<string> { "列名1", "列名2", "列名3" };
            for (int i = 0; i < columnNames.Count; i++)
            {
                worksheet.Cells[1, i + 1].Value = columnNames[i];
            }

            // 设置数据
            List<List<string>> data = new List<List<string>>
            {
                new List<string> { "数据1", "数据2", "数据3" },
                new List<string> { "数据4", "数据5", "数据6" },
                new List<string> { "数据7", "数据8", "数据9" }
            };

            for (int row = 0; row < data.Count; row++)
            {
                for (int col = 0; col < data[row].Count; col++)
                {
                    worksheet.Cells[row + 2, col + 1].Value = data[row][col];
                }
            }

            // 保存Excel文件
            string filePath = "路径/文件名.xlsx";
            excelPackage.SaveAs(new FileInfo(filePath));

            Console.WriteLine("Excel导出完成。");
        }
    }
}