MVC 导出Execl 的总结几种方式 （三）

  第三种方式呢，就是借用第三方插件 NPOI 来实现Execl 导出

 

 第一步：在NuGut包中下载NPOI 组件

 第二步：编辑控制器代码  

 public FileResult ExcelNewKeyPromotion()
        {
            string title = "Market Sensing-Key Promotion";

            var model = GetList();

            NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
            NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1");


            IFont font = book.CreateFont();
            font.FontHeightInPoints = 11;
            font.Boldweight = (short)NPOI.SS.UserModel.FontBoldWeight.Bold;//加粗

            IFont font1 = book.CreateFont();
            font1.FontHeightInPoints = 10;
            font1.Boldweight = (short)NPOI.SS.UserModel.FontBoldWeight.Bold;//加粗

            NPOI.SS.UserModel.IRow row0 = sheet1.CreateRow(0);
            SetCellRangeAddress(sheet1, 0, 0, 0, 16); //设置夸单元格
            ICellStyle cellstyle = book.CreateCellStyle();//设置垂直居中格式
            cellstyle.Alignment = HorizontalAlignment.Center; //设置水平居中
            cellstyle.VerticalAlignment = VerticalAlignment.Center;//垂直居中           
            cellstyle.SetFont(font); //设置字体
            ICell cell = row0.CreateCell(0);
            cell.CellStyle = cellstyle;
            cell.SetCellValue(title);


            NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(1);

            ICellStyle Rowstyle = book.CreateCellStyle();//设置垂直居中格式
            Rowstyle.VerticalAlignment = VerticalAlignment.Center;//垂直居中
            Rowstyle.Alignment = HorizontalAlignment.Center; //设置水平居中
            Rowstyle.FillPattern = FillPattern.SolidForeground;
            Rowstyle.FillForegroundColor = NPOI.HSSF.Util.HSSFColor.Grey25Percent.Index; //设置背景色
            Rowstyle.SetFont(font1);
            var lstTitle = new List<string> { "Year", "Week", "Date"};
            for (int i = 0; i < lstTitle.Count(); i++)
            {
                ICell cellRow1 = row1.CreateCell(i);
                cellRow1.CellStyle = Rowstyle;
                cellRow1.SetCellValue(lstTitle[i]);
            }


            // row1.CreateCell(12).SetCellValue("Photo");
            ICell cellRow2 = row1.CreateCell(12);
            cellRow2.CellStyle = Rowstyle;
            cellRow2.SetCellValue("Photo");
            Rowstyle.SetFont(font1);
            SetCellRangeAddress(sheet1, 1, 1, 12, 16); //设置夸单元格
           
            int rowIndex = 2;
            for (int i = 0; i < model.Count; i++)
            {
                NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(i + 2);

                rowtemp.Height = 500; //设置行高              

                rowtemp.CreateCell(0).SetCellValue(model[i].Id.ToString());
                rowtemp.CreateCell(1).SetCellValue(model[i].Name.ToString());
                rowtemp.CreateCell(2).SetCellValue(model[i].CreateTime.ToString("yyyy-MM-dd hh:mm:ss"));
                
               
                rowIndex++;
            }


            System.IO.MemoryStream ms = new System.IO.MemoryStream();
            book.Write(ms);
            ms.Seek(0, SeekOrigin.Begin);
            
            string fileName = "Market Sensing / KeyPromotion.xls";
            return File(ms, "application/vnd.ms-excel", fileName);

        }

第三步：前端页面

 

 function ExcelNewKeyPromotion() {

        window.open("/Home/ExcelNewKeyPromotion")
    }