c# mvc使用 npoi下载 excel 
 1 IWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
 2 //添加一个sheet
 3 ISheet sheet1 = book.CreateSheet("Sheet1");
 4 
 5 
 6 //给sheet1添加第一行的头部标题
 7 NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0);
 8 row1.CreateCell(0).SetCellValue("编号");
 9 row1.CreateCell(1).SetCellValue("姓名");
10 
11 MemoryStream ms = new MemoryStream();
12 book.Write(ms);
13 ms.Seek(0, SeekOrigin.Begin);
14 return File(ms, "application/vnd.ms-execel", "1.xls");

 

 posted on 2016-11-28 16:48  Just_Do  阅读(1883)  评论(0)  编辑  收藏  举报