WebAPI/Controllers/POOrderBillExcelController.cs
@@ -14,7 +14,7 @@ public class POOrderBillExcelController : ApiController { private JsonResult objJsonResult = new JsonResult(); SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM(); SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); #region 采购订单 查询 [Route("POOrderBillExcel/POOrderBillExcelList")] @@ -102,7 +102,15 @@ { row[j] = ExcelDs.Tables[0].Rows[i][j].ToString(); } tb2.Rows.Add(row); //如果表格第i行的第一列为空,则判断为这一行的数据为空,跳出循环并且不把数据写入 tb2 if (ExcelDs.Tables[0].Rows[i][0].ToString() == "") { continue; } else { tb2.Rows.Add(row); } }