c# .NET 使用MVC控制器导出Excel并打开

在MVC控制器中打开文件，需要用FileResult作为控制器的返回值

 /// <summary>
        /// 导出Excel
        /// </summary>
        /// <returns></returns>
        [HttpGet]
        public FileResult ExportFile(string searchValue="",string payStatus="",string status="",string searchBeginDate="",string searchEndDate="") {
            string where = " IsDel=0";
            if (!String.IsNullOrEmpty(searchValue))
            {
                where += " and (PATINDEX('%" + searchValue + "%',OrderNo) > 0 " +
                    " or userid like '%" + searchValue + "%'" +
                    " or PATINDEX('%" + searchValue + "%',NickName) > 0 " +
                    " or PATINDEX('%" + searchValue + "%',CourseName) > 0) ";              
            }
            if (!String.IsNullOrEmpty(payStatus))
                where += " and PayStatus=" + payStatus;
            if (!String.IsNullOrEmpty(status))
                where += " and Status=" + status;
            if (!string.IsNullOrEmpty(searchBeginDate))
            {
                DateTime date1 = DateTime.Parse(searchBeginDate);
                where += " and CreatedOn > '" + date1 + "'";
            }
            if (!string.IsNullOrEmpty(searchEndDate))
            {
                DateTime date2 = DateTime.Parse(searchEndDate);
                where += " and CreatedOn < '" + date2 + "'";
            }
            //全部获取
            DataTable dt = orderService.GetDataTable(where);
            if (dt.Rows.Count == 0) {
                //return Content("");
            }
         
            string folderSrc = "/Admin.Uploads/" + DateTime.Today.Date.ToString("yyyy-MM") + "/";
            if (!Directory.Exists(HttpContext.Server.MapPath(folderSrc)))
            {
                Directory.CreateDirectory(HttpContext.Server.MapPath(folderSrc));
            }
            Random rand = new Random();//随生成器
            string fileName = folderSrc + DateTime.Now.Ticks + rand.Next(1000, 9999) + ".xls";
            string repath = HttpContext.Server.MapPath(fileName);
            string[] captions = {"机构名称","订单编号","用户昵称","手机号码","班级名称","课程名称","订单金额","优惠金额","需付金额","实付金额","付款时间","下单时间" };//列名
            MemoryStream ms = ExcelHelper.RenderToExcel(captions,dt,repath);
            return File(ms, "application/ms-excel","order.xls");
        }

下面是生成EXCEL的代码，帮助类，传DataTable,列名,保存路径(会保存到服务器，不需要的话就删掉保存这一步应该也可以，没有试验)进去，返回MemoryStream，
借用的是NPOI.dll插件

 /// <summary>
    /// Excel helper
    /// </summary>
    public partial class ExcelHelper  
    {  
        public static MemoryStream RenderToExcel(string [] captions, DataTable table,string fileName)
        {
    
            MemoryStream ms = new MemoryStream();
            using (table)
            {
                IWorkbook workbook = new HSSFWorkbook();
                ISheet sheet = workbook.CreateSheet();
                {
                    IRow headerRow = sheet.CreateRow(0);
                    for (int i = 0; i < captions.Length; i++)
                    {
                        headerRow.CreateCell(i).SetCellValue(captions[i]);
                    } 
                    int rowIndex = 1;
                    foreach (DataRow row in table.Rows)
                    {
                        IRow dataRow = sheet.CreateRow(rowIndex);
                        foreach (DataColumn column in table.Columns)
                        {
                            dataRow.CreateCell(column.Ordinal).SetCellValue(row[column].ToString());
                        }
                        rowIndex++;
                    }
                    workbook.Write(ms);
                    ms.Flush();
                    ms.Position = 0;
                }
                FileStream file = new FileStream(fileName, FileMode.OpenOrCreate);
                workbook.Write(file);
                file.Close();
                return ms;
            }
        }
}

然后是前端调用控制器：js方法，按钮直接调用，参数自定义

        function exportExcel() {
            window.location.href = "/Business/Order/ExportFile?searchValue=" + searchValue +
                "&status=" + status + "&payStatus=" + payStatus + "&searchBeginDate=" + searchBeginDate + "&searchEndDate=" + searchEndDate; 
        }

ps:找了很多导出的资料，结果发现很多只能保存到服务器，不会保存到客服端，后面才发现MVC里面用法不一样，找了半天才找到方法，然后发现很多没说怎么调用，作为小菜鸟是真的不知道，因为一向都是用ajax调用控制器，处理返回结果