Public classNpoimemorystream:memorystream { PublicNpoimemorystream () {AllowClose=true; } Public BOOLAllowClose {Get;Set; } Public Override voidClose () {if(AllowClose)Base. Close (); } }
PublicActionResult Export () {intOrderId =Base. Id; Orders Order=OrdersModel.GetInstance.GetById (orderId); varWorkbook =NewXssfworkbook (Server.MapPath ("~/template/order.xlsx")); varSheet = workbook. Getsheetat (0); IRow Row= Sheet. CreateRow (4); Row. Createcell (0). Setcellvalue ("Item No."); Row. Createcell (1). Setcellvalue ("name"); Row. Createcell (2). Setcellvalue ("Color"); stringFName =string. Format ("{0}.xlsx", order. OrderNo); //ways to export Excel files varms =NewNpoimemorystream (); Ms. AllowClose=false; Workbook. Write (MS); Ms. Flush (); Ms. Seek (0, Seekorigin.begin); Ms. AllowClose=true; returnFile (MS,"Application/vnd.ms-excel", fname); }
ASP. NET MVC Npoi export Excel