asp.net带格式导出excel

asp.net带格式导出excel

开发工具：Visual Studio 2015、SQL Server 2014 Management Studio
关键技术：C# MVC
作者：刘东标
撰写时间：2019年3月27日
效果图片:

//创建Excel文件的对象
NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
//添加一个sheet
NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet(“Sheet1”);
//获取list数据
//List<TB_STUDENTINFOModel> listRainInfo = m_BLL.GetSchoolListAATQ(schoolname);

        HSSFCellStyle style = (HSSFCellStyle)book.CreateCellStyle();

        //垂直居中
        style.VerticalAlignment = NPOI.SS.UserModel.VerticalAlignment.Center;
        //水平居中
        style.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center;
        //设置\n自动换行
        style.WrapText = true;
        //给单元格设置样式
        HSSFFont hf = (HSSFFont)book.CreateFont();
        //hf.Boldweight = 900;//设置字体加粗
        //hf.FontHeight = 260;//字体的高度
        hf.FontName = "仿宋_GB2312";
        //hf.Color = HSSFColor.Blue.Index;//设置字体颜色
        style.SetFont(hf);

        NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0);
        for (int j = 0; j < 19; j++)
        {
            sheet1.SetDefaultColumnStyle(j, style);
        }
                   sheet1.SetColumnWidth(0, 20 * 200);
        sheet1.SetColumnWidth(1, 20 * 256);
        sheet1.SetColumnWidth(2, 20 * 230);
        sheet1.SetColumnWidth(3, 20 * 80);
        sheet1.SetColumnWidth(4, 20 * 120);
        sheet1.SetColumnWidth(5, 20 * 256);
        sheet1.SetColumnWidth(6, 20 * 256);
        sheet1.SetColumnWidth(7, 20 * 100);
        sheet1.SetColumnWidth(8, 20 * 100);
        sheet1.SetColumnWidth(9, 20 * 100);
        sheet1.SetColumnWidth(10, 20 * 100);
        sheet1.SetColumnWidth(11, 20 * 100);
        sheet1.SetColumnWidth(12, 20 * 100);
        sheet1.SetColumnWidth(13, 20 * 100);
        sheet1.SetColumnWidth(14, 20 * 100);
        sheet1.SetColumnWidth(15, 20 * 100);
        sheet1.SetColumnWidth(16, 20 * 100);
        sheet1.SetColumnWidth(17, 20 * 150);
        sheet1.SetColumnWidth(18, 20 * 200);