如何使用 Utilities.sleep() 函数

本文介绍了如何使用 Utilities.sleep() 函数的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

Utilities.sleep() 函数的确切用途是什么?我们应该在函数调用或 API 调用之间使用它吗?

What is the exact use of Utilities.sleep() function? Should we use it between function calls or API calls?

我在函数调用之间使用了 Utilities.sleep(1000)，对吗?它会减慢执行时间吗?

I use the Utilities.sleep(1000) in-between function calls, is it right? Will it slow down the execution time?

推荐答案

Utilities.sleep(milliseconds) 在程序执行中创建一个暂停"，这意味着它在您要求的毫秒数内不执行任何操作.它肯定会减慢你的整个过程，你不应该在函数调用之间使用它.不过也有一些例外，至少我知道的是:在 SpreadsheetApp 中，当您想要删除多个工作表时，您可以在每次删除之间添加数百毫秒以允许正常的脚本执行(但这是一种解决方法)此特定方法的一个已知问题).在电子表格中创建许多工作表时，我也必须使用它，以避免浏览器在执行后需要刷新".

Utilities.sleep(milliseconds) creates a 'pause' in program execution, meaning it does nothing during the number of milliseconds you ask.It surely slows down your whole process and you shouldn't use it between function calls.There are a few exceptions though, at least that one that I know : in SpreadsheetApp when you want to remove a number of sheets you can add a few hundreds of millisecs between each deletion to allow for normal script execution (but this is a workaround for a known issue with this specific method). I did have to use it also when creating many sheets in a spreadsheet to avoid the Browser needing to be 'refreshed' after execution.

这是一个例子:

function delsheets(){
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var numbofsheet=ss.getNumSheets();// check how many sheets in the spreadsheet
  for (pa=numbofsheet-1;pa>0;--pa){ 
    ss.setActiveSheet(ss.getSheets()[pa]);
    var newSheet = ss.deleteActiveSheet(); // delete sheets begining with the last one
    Utilities.sleep(200);// pause in the loop for 200 milliseconds
  }
  ss.setActiveSheet(ss.getSheets()[0]);// return to first sheet as active sheet (useful in 'list' function)
}

这篇关于如何使用 Utilities.sleep() 函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！

utilities