EPPlus将字典<int,int[]>写入单元格

我使用控制台应用程序和最新的EPPlus版本。首先,您需要创建一个文件示例。C磁盘中的xlsx。希望能帮上忙,我的朋友!

public static void WriteExcel()
        {
            Dictionary<int, int> dictionary =
            new Dictionary<int, int>();

            for (int i = 1; i <= 100; i++)
            {
                dictionary.Add(i, i);
            }   

            var filePath = @"C:/Sample.xlsx";             
            var file = new FileInfo(filePath);

            using (var package = new ExcelPackage(file))
            {
                ExcelWorksheet worksheet = package.Workbook.Worksheets["Sheet1"];
                int k = 0;
                foreach (var item in dictionary.Take(50))
                {
                    int cell = k + 2;
                    worksheet.Cells["A" + cell].Value = item.Value;
                    k++;
                }
                package.Save();
            }
        }