如何使Google表格每60秒刷新一次？ [英] How do I make Google Sheets refresh every 60 seconds?

问题描述

我的Google表格中有一个ImportJSON脚本，该脚本是从此处检索到的。现在我有了代码：

I have an ImportJSON script in my Google Sheets retrieved from here. Now I have code:

=ImportJSON("http://date.jsontest.com/","/time", "")

现在可以简单地获取时间。我的问题是它不会自动刷新。

which simply retrieves the time right now. My issue is that it does not refresh automatically.

如何使其每60秒刷新一次？

How do I make it refresh every 60 seconds?

推荐答案

我在Google Apps脚本中使用刷新脚本。

I use a refresh script with the google apps script.

首先，您需要生成一个随机数，以诱骗它以为它是一个新链接。

First you need to generate a random number to trick it into thinking its a new link.

  var min = Math.ceil(0);
  var max = Math.floor(99);
  var randomNum = Math.floor(Math.random() * (max - min + 1)) + min

之后，您需要写一些您想要的时间

After that you need to write to the cell you want to have the time

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sh = ss.getSheetByName("Sheet1");

sh.getRange("A1").setFormula('=ImportJSON("http://date.jsontest.com/","/time", "","' + randomNum +'")';

然后，您可以将脚本设置为随时运行。

Then you can set up the script to run whenever you want.

这篇关于如何使Google表格每60秒刷新一次？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！