public ActionResult ToCheckExcel() { string orderNum = WebUtil.GetFormValue<string>("OrderNum", string.Empty); List<CheckDataEntity> listResult = new CheckDataProvider().GetCheckOrder(orderNum); if (!listResult.IsNullOrEmpty()) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("库位名称")); dt.Columns.Add(new DataColumn("库位编号")); dt.Columns.Add(new DataColumn("产品编码")); dt.Columns.Add(new DataColumn("产品条码")); dt.Columns.Add(new DataColumn("产品名称")); dt.Columns.Add(new DataColumn("批次")); dt.Columns.Add(new DataColumn("盘点数")); foreach (CheckDataEntity t in listResult) { DataRow row = dt.NewRow(); row[0] = t.LocalName; row[1] = t.LocalNum; row[2] = t.ProductNum; row[3] = t.BarCode; row[4] = t.ProductName; row[5] = t.BatchNum; row[6] = ""; dt.Rows.Add(row); } string filePath = Server.MapPath("~/UploadFiles/"); if (!System.IO.Directory.Exists(filePath)) { System.IO.Directory.CreateDirectory(filePath); } string filename = string.Format("盘点管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss")); NPOIExcel excel = new NPOIExcel("盘点管理", "盘点单", System.IO.Path.Combine(filePath, filename)); excel.ToExcel(dt); this.ReturnJson.AddProperty("Path", ("/UploadFiles/" + filename).Escape()); } else { this.ReturnJson.AddProperty("d", "无数据导出!"); } return Content(this.ReturnJson.ToString()); }