模板下载的实现

public ActionResult OutItemTemplate()
        {
            var resultMsg = "";
            try
            {
                DataTable dtData = new DataTable("table");
                dtData.Columns.Add("列名", Type.GetType("System.String"));
                dtData.Columns.Add("列名", Type.GetType("System.String"));
                dtData.Columns.Add("列名", Type.GetType("System.String"));
                dtData.Columns.Add("列名", Type.GetType("System.String"));
                dtData.Columns.Add("列名", Type.GetType("System.String"));
                dtData.Columns.Add("列名", Type.GetType("System.String"));
                dtData.Columns.Add("列名", Type.GetType("System.Decimal"));
                dtData.Columns.Add("列名", Type.GetType("System.Decimal"));
                DataRow dr = dtData.NewRow();
                dtData.Rows.Add(dr);
                //创建Excel文件的对象  
                NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
                //添加一个sheet  
                NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1");
                //给sheet1添加第一行的头部标题  
                NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0);
                //row1.RowStyle.FillBackgroundColor = "";  
                for (int i = 0; i < dtData.Columns.Count; i++)
                {
                    row1.CreateCell(i).SetCellValue(dtData.Columns[i].ColumnName);
                }
                //将数据逐步写入sheet1各个行  
                for (int i = 0; i < dtData.Rows.Count; i++)
                {
                    NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(i + 1);
                    for (int j = 0; j < dtData.Columns.Count; j++)
                    {
                        rowtemp.CreateCell(j).SetCellValue(dtData.Rows[i][j].ToString().Trim());
                    }
                }
                // 写入到客户端   
                System.IO.MemoryStream ms = new System.IO.MemoryStream();
                book.Write(ms);
                ms.Seek(0, SeekOrigin.Begin);
                return File(ms, "application/vnd.ms-excel", "询价物料导入模板.xls");
            }
            catch (Exception ex)
            {
                resultMsg = ex.Message;
            }
            finally
            {
                ViewBag.ResultMsg = resultMsg;
            }
            return View();
        }