admin 管理员组

文章数量: 1086019

I want to increment the value in the A1 cell.

function increment(){
   var ss = SpreadsheetApp.getActiveSpreadsheet();
   var sheet = ss.getSheets()[0];

   var cell = sheet.getRange("A1");
   cellValue = cell.getValue("A1");
   cell.SetValue(cellValue + 1);
}

How can I do that?

I want to increment the value in the A1 cell.

function increment(){
   var ss = SpreadsheetApp.getActiveSpreadsheet();
   var sheet = ss.getSheets()[0];

   var cell = sheet.getRange("A1");
   cellValue = cell.getValue("A1");
   cell.SetValue(cellValue + 1);
}

How can I do that?

  • javascript
  • google-apps-script
Share Improve this question edited Dec 8, 2014 at 13:54 Stéphane Bruckert 23k14 gold badges99 silver badges135 bronze badges asked Dec 8, 2014 at 13:18 Maher M.Maher M. 3492 silver badges18 bronze badges
Add a ment  | 

1 Answer 1

Reset to default 8

You are calling getValue() with an argument. This function does not take any arguments, as can be seen in the documentation:

https://developers.google./apps-script/reference/spreadsheet/range#getValue()

  function increment(){
   var ss = SpreadsheetApp.getActiveSpreadsheet();
   var sheet = ss.getSheets()[0];

   var range = sheet.getRange("A1");
   //Returns the value of the top-left cell in the sheet
   var value = range.getValue();
   range.setValue(value + 1);
}

本文标签： javascriptIncrement cell value in spreadsheet Google AppscriptStack Overflow

版权声明：本文标题：javascript - Increment cell value in spreadsheet Google Appscript - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.roclinux.cn/p/1743985001a2513699.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。