c#导出excel文件，以及出现解决方法

最新推荐文章于 2024-10-31 12:26:04 发布

qq_45659882

最新推荐文章于 2024-10-31 12:26:04 发布

阅读量1.2k

点赞数

分类专栏： C# 文章标签： c# 开发语言后端

本文链接：https://blog.csdn.net/qq_45659882/article/details/122188348

版权

C# 专栏收录该内容

16 篇文章 0 订阅

订阅专栏

using OfficeOpenXml;
using System.IO;

static void Main(string[] args)
{
    int[] testData = { 1, 2, 3 };

    ExcelWorksheet workSheet;

    using (var p = new ExcelPackage())
    {
        workSheet = p.Workbook.Worksheets.Add("测试数据");

        workSheet.Cells[1, 1].Value = "数据1";
        workSheet.Cells[1, 2].Value = "数据2";
        workSheet.Cells[1, 3].Value = "数据3";

        workSheet.Cells[2, 1].Value = testData[0];
        workSheet.Cells[2, 2].Value = testData[1];
        workSheet.Cells[2, 3].Value = testData[2];

        p.SaveAs(new FileInfo("test.xlsx"));
    }
}

若报错：Please set the ExcelPackage.LicenseContext property.

在代码中添加：ExcelPackage.LicenseContext = LicenseContext.NonCommercial;

int[] testData = { 1, 2, 3 };

ExcelWorksheet workSheet;
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
using (var p = new ExcelPackage())
{
workSheet = p.Workbook.Worksheets.Add("测试数据");

workSheet.Cells[1, 1].Value = "数据1";
workSheet.Cells[1, 2].Value = "数据2";
workSheet.Cells[1, 3].Value = "数据3";

workSheet.Cells[2, 1].Value = testData[0];
workSheet.Cells[2, 2].Value = testData[1];
workSheet.Cells[2, 3].Value = testData[2];

p.SaveAs(new FileInfo("test.xlsx"));
}
return true;