public ActionResult ExceptionDataExportToExcel() { OperationResult result = new OperationResult(OperationResultType.Error); var scanValidKey = "ScanValid"; var scanInvalidKey = "ScanInvalid"; List <Product_Model> validModels = SessionAccess.Get(scanValidKey) as List <Product_Model>; List <Product_Model> inValidModels = SessionAccess.Get(scanInvalidKey) as List <Product_Model>; List <List <string> > validDa = new List <List <string> >(); List <List <string> > inValidDa = new List <List <string> >(); if (validModels != null && validModels.Any()) { foreach (var valda in validModels) { validDa.Add(new List <string>() { valda.Id.ToString(), valda.ProductBarcode }); } } if (inValidModels != null && inValidModels.Any()) { foreach (var valda in inValidModels) { inValidDa.Add(new List <string>() { valda.Id.ToString(), valda.ProductBarcode, valda.Notes }); } } List <List <List <string> > > li = new List <List <List <string> > >(); li.Add(validDa); li.Add(inValidDa); YxkSabri.ExcelUtility excel = new ExcelUtility(); var name = DateTime.Now.ToString("yyyyMMddHHff") + ".xls"; string basedir = Server.MapPath(@"\Content\UploadFiles\Excels\ExportDa\"); if (Directory.Exists(basedir)) { Directory.Delete(basedir, true); } Directory.CreateDirectory(basedir); string path = basedir + name; var rsul = excel.ExportMulitExcelSheet(li, path, new string[] { "有效", "无效" }); if (rsul) { result = new OperationResult(OperationResultType.Success); } return(File(path, "application/ms-excel", "导出数据.xls")); //// string path = "D:/test/销售月报表.xlsx"; // FileStream fs = new FileStream(path, FileMode.Open); // byte[] buffer = new byte[fs.Length]; // fs.Read(buffer, 0, buffer.Length); // fs.Close(); //System.IO.File.Delete(path); // Response.ContentType = "application/ms-excel"; // Response.Charset = "GB2312"; // Response.ContentEncoding = System.Text.Encoding.UTF8; // Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode("销售月报表.xlsx")); // Response.OutputStream.Write(buffer, 0, buffer.Length); // Response.Flush(); // Response.End(); // return Json(result); }