Asp.net MVC NPOI导出Excel

 public class NpoiMemoryStream : MemoryStream ???{ ???????public NpoiMemoryStream() ???????{ ???????????AllowClose = true; ???????} ???????public bool AllowClose { get; set; } ???????public override void Close() ???????{ ???????????if (AllowClose) ???????????????base.Close(); ???????} ???}

 ?public ActionResult Export() ???????{ ???????????int orderId = base.Id; ???????????Orders order = OrdersModel.GetInstance.GetById(orderId); ???????????var workbook = new XSSFWorkbook(Server.MapPath("~/Template/order.xlsx")); ???????????var sheet = workbook.GetSheetAt(0); ???????????IRow row = sheet.CreateRow(4); ???????????row.CreateCell(0).SetCellValue("货号"); ???????????row.CreateCell(1).SetCellValue("品名"); ???????????row.CreateCell(2).SetCellValue("颜色"); ???????????string fname = string.Format("{0}.xlsx", order.OrderNo); ???????????//导出Excel文件的方法 ?????????????var ms = new NpoiMemoryStream(); ???????????ms.AllowClose = false; ???????????workbook.Write(ms); ???????????ms.Flush(); ???????????ms.Seek(0, SeekOrigin.Begin); ???????????ms.AllowClose = true; ???????????return File(ms, "application/vnd.ms-excel", fname); ???????}