带有字符串值的Google脚本.setFormula错误 [英] Google script .setFormula error with string value
问题描述
我对此并不陌生,因此请原谅这个简单的问题.我正在尝试将以下公式插入到Google表格L2_R1最终产品的单元格E18中:
I'm new to this so please forgive the simple question. I'm trying to insert the following formula into cell E18 of google sheet L2_R1 Final Product:
=if(D17="Poor",0,if(D17="Acceptable",1,if(D17="Excellent",2,)))
我已经通过以下方式解决了这个问题:
I've gone about it the following way:
var sheet4= SpreadsheetApp.getActiveSpreadsheet().getSheetByName("L2_R1 Final Product");
var r2_fpr1_1 = sheet4.getRange("E18");
r2_fpr1_1.setFormula("=if(D18="Poor",0,if(D18="Acceptable",1,if(D18="Excellent",2,)))");
这会在参数列表(第108行,文件"Code.gs")之后产生错误:SyntaxError:missing)尽管我认为我实际上并没有错过)
This produces the error: SyntaxError: missing ) after argument list (line 108, file "Code.gs") Although I don't think I'm actually missing a )
浏览其他帖子后,我尝试了以下操作:
After going through other posts I've tried the following:
var r2_fpr1_1 = sheet4.getRange("E18");
r2_fpr1_1.setFormula("=if(D18=\""+Poor+"\",0,if(D18=\""+Acceptable+"\",1,if(D18=\""+Excellent+"\",2,)))");
和
var r2_fpr1_1 = sheet4.getRange("E18")
r2_fpr1_2.setFormula(`=if(D18="${Poor}",0,if(D18="${Acceptable}",1,if(D18="${Excellent}",2,)))`);
这两个都给我一个错误:ReferenceError:未定义差(第108行,文件代码")
Both of those give me the error: ReferenceError: Poor is not defined (line 108, file "Code")
那我想念什么?
推荐答案
您还可以使用 setValue()代替:
var r2_fpr1_1 = sheet4.getRange('E18');
r2_fpr1_1 .setValue(`=if(D17="Poor",0,if(D17="Acceptable",1,if(D17="Excellent",2,)))`)
但 setFormula()的效果也很好:
var r2_fpr1_1 = sheet4.getRange('E18');
r2_fpr1_1.setFormula(`=if(D17="Poor",0,if(D17="Acceptable",1,if(D17="Excellent",2,)))`)
参考文献:
这篇关于带有字符串值的Google脚本.setFormula错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!