public ActionResult Index()

        {

            List<string> headList = new List<string>();

            headList.Add("语文");

            headList.Add("数学");

            headList.Add("英语");

            headList.Add("政治");

            List<string> nameList = new List<string>();

            nameList.Add("张三");

            nameList.Add("李四");

            nameList.Add("王五");

            nameList.Add("赵六");

            nameList.Add("胜七");

            nameList.Add("朱重八");

            nameList.Add("九喇嘛");

            MemoryStream memoryStream = new MemoryStream();

            HSSFWorkbook workbook = new HSSFWorkbook();

            HSSFSheet sheet = workbook.CreateSheet();

            //创建单元格设置对象

            HSSFCellStyle cellStyle = workbook.CreateCellStyle();

            //设置水平、垂直居中

            cellStyle.Alignment = HSSFCellStyle.ALIGN_CENTER;

            cellStyle.VerticalAlignment = HSSFCellStyle.VERTICAL_CENTER;

            //单元格填充颜色

            cellStyle.FillForegroundColor = HSSFColor.PALE_BLUE.index;

            cellStyle.FillPattern = HSSFCellStyle.SOLID_FOREGROUND;

            //设置边框

            cellStyle.BorderBottom = HSSFCellStyle.BORDER_THIN;

            cellStyle.BorderLeft = HSSFCellStyle.BORDER_THIN;

            cellStyle.BorderRight = HSSFCellStyle.BORDER_THIN;

            cellStyle.BorderTop = HSSFCellStyle.BORDER_THIN;

            //创建设置字体对象

            HSSFFont font = workbook.CreateFont();

            font.FontHeightInPoints = ;//设置字体大小

            font.Boldweight = short.MaxValue; //加粗

            font.FontName = "宋体";

            cellStyle.SetFont(font);

            //创建Excel行和单元格

            for (int i = ; i < nameList.Count + ; i++)

            {

                HSSFRow newRow = sheet.CreateRow(i);

                for (int j = ; j <headList.Count+; j++)

                {

                    newRow.CreateCell(j);

                }

            }

            //设置Excel表头

            sheet.AddMergedRegion(new CellRangeAddress(, , , )); //起始行  结束行 起始列 结束列

            sheet.GetRow().GetCell().CellStyle = cellStyle;

            sheet.GetRow().GetCell().CellStyle = cellStyle;

            sheet.GetRow().GetCell().SetCellValue("姓名");//姓名

            sheet.AddMergedRegion(new CellRangeAddress(, , , )); //起始行  结束行 起始列 结束列

            sheet.GetRow().GetCell().CellStyle = cellStyle;

            sheet.GetRow().GetCell().CellStyle = cellStyle;

            sheet.GetRow().GetCell().SetCellValue("课程");//课程

            for (int i = ; i < headList.Count; i++)

            {

                sheet.GetRow().GetCell(i + ).CellStyle = cellStyle;

                sheet.GetRow().GetCell(i + ).SetCellValue(headList[i]);//具体课程

            }

            //导入数据

            for (int i = ; i < nameList.Count; i++)

            {

                sheet.GetRow(i + ).GetCell().SetCellValue(nameList[i]);

                for (int j = ; j < ; j++)

                {

                     sheet.GetRow(i + ).GetCell(j+).SetCellValue(i*j);

                }

            }

            workbook.Write(memoryStream);

            memoryStream.Seek(,SeekOrigin.Begin);

            Response.Clear();

            Response.AddHeader("content-disposition", "attachment;filename=" + Server.UrlEncode("test.xls"));

            Response.ContentType = "application/octet-stream";

            Response.Charset = "gb2312";

            Response.ContentEncoding = Encoding.UTF8;

            Response.BinaryWrite(memoryStream.GetBuffer());

            Response.Flush();

            Response.End();

            return new EmptyResult();

        }