通过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); }更多推荐
发布评论