file:///e:/未命名 对就给单元格添加公式,代码如下: for (int m = 13; m < 28; m++)
{
string FormlaString = "IF(ISERROR(VLOOKUP(RC38,词典!R3C1:R300C16," + n.ToString() + ",0)),\"\",VLOOKUP(RC38,词典!R3C1:R300C16," + n.ToString() + ",0))";
this.fpSpread1.Sheets["洞身衬砌表"].Cells[row, m].Formula = FormlaString;
},本意是想VLOOKUP公式错误时,单元格不显示内容,但实际是显示的“0" |