...
当公式求值时,会查找名称的引用并重新求值。使用 addCustomName 方法来创建一个自定义名称。
示例代码
以下代码创建了一个自定义名称。
Code Block | ||||
---|---|---|---|---|
|
...
Copy Code
activeSheet.setValue(0, 0, 1); activeSheet.setValue(0, 1, 2); activeSheet.setValue(0, 2, 3); activeSheet.addCustomName("customName1","=12", 0, 0); activeSheet.addCustomName("customName2","Average(20,45)", 0, 0); activeSheet.addCustomName("customName3", "=$B$1:$C$1", 0, 0); activeSheet.setFormula(1, 0, "customName1"); activeSheet.setFormula(1, 1, "customName2"); activeSheet.setFormula(1, 2, "sum(customName3)"); |
...