/// <summary>

        /// 在已有的Excel模板进行操作

        /// </summary>

        /// <returns></returns>

public ActionResult DownTemplate()

        {

            var list = departmentService.GetList();//数据源

            string filepath = "/Content/Templates/XX.xlsx";

            filepath = Server.MapPath(filepath);

            Workbook workbook = null;

            FileStream file = new FileStream(filepath, FileMode.Open, FileAccess.Read);

            using (file)

            {

                workbook = new Workbook(file);

            }

            var deparmenttSheet = workbook.Worksheets[];

            deparmenttSheet.Cells["A1"].PutValue(new HSSFRichTextString("序号"));

            deparmenttSheet.Cells["B1"].PutValue(new HSSFRichTextString("部门编码"));

            deparmenttSheet.Cells["C1"].PutValue(new HSSFRichTextString("部门名称"));

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

            {

                var item = i + ;

                deparmenttSheet.Cells["A"+item].PutValue(i+);

                deparmenttSheet.Cells["B"+item].PutValue(list[i].DepartmentCode);

                deparmenttSheet.Cells["C"+item].PutValue(list[i].DepartmentName);

            }

            //写入到表格

            workbook.Save(filepath);

            // 防IE文件名乱码

            var fileName = HttpUtility.UrlEncode("某某信息.xlsx", System.Text.Encoding.UTF8);

            HttpContext.Response.AddHeader("Content-Disposition", "attachment;filename=" + fileName);

            return File("/Content/Templates/XX.xlsx", fileName);

        }

<a href="/XX/DownTemplate" >下载某某信息模版</a>