.net mvc epplus简单的导出excel
时间: 2023-05-15 15:05:44 浏览: 72
可以使用以下代码来实现:
using OfficeOpenXml;
using System.IO;
public void ExportToExcel()
{
var data = GetData(); // 获取数据
using (var package = new ExcelPackage())
{
var worksheet = package.Workbook.Worksheets.Add("Sheet1");
// 添加表头
worksheet.Cells[1, 1].Value = "姓名";
worksheet.Cells[1, 2].Value = "年龄";
worksheet.Cells[1, 3].Value = "性别";
// 添加数据
for (int i = 0; i < data.Count; i++)
{
worksheet.Cells[i + 2, 1].Value = data[i].Name;
worksheet.Cells[i + 2, 2].Value = data[i].Age;
worksheet.Cells[i + 2, 3].Value = data[i].Gender;
}
// 保存文件
var stream = new MemoryStream();
package.SaveAs(stream);
var content = stream.ToArray();
// 返回文件流
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment; filename=Export.xlsx");
Response.BinaryWrite(content);
Response.End();
}
}
其中,GetData() 方法用于获取数据,可以根据实际情况进行修改。