C#中用NPOI的excel导出

//机构表导出
private static List<User2> amininf = new BLL.Bll().GetUser2s(); //定义数据源导出对象

#region 导出数据
public FileResult setfill()
{
if (Admininfo != null)
{
if (Admininfo.Count > 0)
{
//创建EXCEL文件的对象
NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();

//添加一个sheet工作表
NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("sheet1");

//获取list数据
List<User2> list = new Bll().GetUser2s();

//给sheet1添加第一行的头部标题
NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0); //0表示当前的索引

//创建标题的内容
row1.CreateCell(0).SetCellValue("序号");
row1.CreateCell(1).SetCellValue("ID");
row1.CreateCell(2).SetCellValue("姓名");
row1.CreateCell(3).SetCellValue("法人");
row1.CreateCell(4).SetCellValue("资金");

//将数据逐步写入各个列中
for (int i = 0; i < list.Count; i++)
{
NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(i + 1);
rowtemp.CreateCell(0).SetCellValue(list[i].xh.ToString());
rowtemp.CreateCell(1).SetCellValue(list[i].Id.ToString());
rowtemp.CreateCell(2).SetCellValue(list[i].Name.ToString());
rowtemp.CreateCell(3).SetCellValue(list[i].Daibiao.ToString());
rowtemp.CreateCell(4).SetCellValue(list[i].Zhijin.ToString());

}

//写入到客户端
System.IO.MemoryStream ms = new MemoryStream();

//输入到工作簿中
book.Write(ms);

//开始写入数据流
ms.Seek(0, SeekOrigin.Begin);

return File(ms, "application/vnd.ms-excel", "机构信息表.xlsx");
}
else
{
System.IO.MemoryStream ms = new System.IO.MemoryStream();
return File(ms, "application/Response.write", "无数据导出");
}
}
else
{
MemoryStream ms = new MemoryStream();
return File(ms, "application/Response.write", "无数据导出");
}
}

--------------------------------------视图代码

<a href="/Home/setfill" style="color:#1abd9b">Excel导出</a>

---------------------------------------控制器引用（不只导出的）
using Model;
using BLL;
using System.IO;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Data;
using Webdiyer.WebControls.Mvc;
using NPOI;
using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;

转载于:https://www.cnblogs.com/Dingcps/p/9353522.html