通过Google应用程序脚本从不同的工作表中拖拽数字(sum tow numbers from different sheet via google app scripts)

通过Google应用程序脚本从不同的工作表中拖拽数字(sum tow numbers from different sheet via google app scripts)

我使用这个代码

function sumValue(){ return "=Sum(Sheet1!f8,Sheet5!C1)"; } function sumValue(){ return "=Sum(Sheet1!f8,Sheet5!C1)"; }添加到sheet1和sheet5的编号。 但我想保留这个总和结果到同一个单元格（Sheet5！C1）这个代码如何编辑。

i use this code

function sumValue(){ return "=Sum(Sheet1!f8,Sheet5!C1)"; } to add to number from sheet1 and sheet5. but i want to remain that sum result to the same cell(Sheet5!C1) how can this code be edited.

最满意答案

如果您已经在脚本编辑器中，我们可以使用更多的应用程序脚本功能，因为在您的情况下，公式会使事情变得更加复杂：

function sumValue() { var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); var valueofSheetOne = spreadsheet.getRange("Sheet1!F8").getValue(); var valueofSheetFive = spreadsheet.getRange("Sheet5!C1").getValue(); spreadsheet.getRange("Sheet5!C1").setValue(valueofSheetOne + valueofSheetFive); }

If you are already in the script editor, we could just use more features of app script, because in your case, formula makes thing more complicated:

function sumValue() { var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); var valueofSheetOne = spreadsheet.getRange("Sheet1!F8").getValue(); var valueofSheetFive = spreadsheet.getRange("Sheet5!C1").getValue(); spreadsheet.getRange("Sheet5!C1").setValue(valueofSheetOne + valueofSheetFive); }