什么是“服务错误:电子表格”意思? [英] What does "Service error: Spreadsheets" mean?
问题描述
我有一个可以工作的代码......有时候......随机运行时停止运行并给我这个错误。我很高兴提供代码,但我只是认为这个错误消息的含义可能有明确的定义。编辑 - 我有,实际上,添加下面的脚本。
function onOpen(){
var folder = DriveApp.getFolderById(0098230948YUIAEr80w9er);
var sheet = SpreadsheetApp.getActiveSpreadsheet()。getSheetByName(Sheet1)
sheet.clearContents();
$ b sheet.appendRow([pp,v1,v2,v3,v4,v5,v6,v7, v8,v9,v10,v11,v12]);
sheet.setFrozenRows(1);
var files = folder.getFiles();
while(files.hasNext()){
var file = files.next();
var otherSheet = SpreadsheetApp.open(file).getSheetByName(Project Overview);
var data = otherSheet.getRange(B3:I30)。getValues();
var v1 = data [1] [0];
var v2 = data [2] [0];
var v3 = data [0] [0];
var v4 = data [4] [0];
var v5 = data [5] [0];
var v6 = data [8] [0];
var v7 = data [3] [0];
var v8 = data [14] [0];
var v9 = data [1] [7];
var v10 = data [2] [7];
var v11 = data [3] [7];
var v12 = data [0] [7];
var url = file.getUrl();
var name =Site Detail;
var semi =;;
var hyp ==超链接(\;
var quot =\;
var clos =);
var pp = hyp + url + quot + semi + quot + name + quot + clos;
if(Status!='These'&& Status!='This'&& Status!='That'&& Status!='Other' )
{sheet.appendRow([pp,v1,v2,v3,v4,v5,v6,v7,v8,v9,v10,v11,v12])
sheet.sort(2);}
}} $ b $因此,将脚本改为这个工作:
var files = folder.getFiles();
while(files.hasNext()){
var file = files.next();
Utilities.sleep(200);
我不能告诉你为什么,除此之外,我怀疑它允许脚本赶上本身在移动到下一个文件之前。我希望这对某人有帮助,如果有人能向我们所有人解释为什么这会起作用,我会很感激。
I have a code that works... sometimes... randomly, it stops while running and gives me this error. I am happy to provide code, but I just thought there might be a clear definition of what this error message means. Edit- I have, in fact, added the script below.
function onOpen() {
var folder = DriveApp.getFolderById("0098230948YUIAEr80w9er");
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1")
sheet.clearContents();
sheet.appendRow(["pp","v1", "v2", "v3", "v4", "v5", "v6", "v7", "v8", "v9", "v10", "v11", "v12"]);
sheet.setFrozenRows(1);
var files = folder.getFiles();
while (files.hasNext()) {
var file = files.next();
var otherSheet= SpreadsheetApp.open(file).getSheetByName("Project Overview");
var data = otherSheet.getRange("B3:I30").getValues();
var v1 = data[1][0];
var v2 = data[2][0];
var v3 = data[0][0];
var v4 = data[4][0];
var v5 = data[5][0];
var v6 = data[8][0];
var v7 = data[3][0];
var v8 = data[14][0];
var v9 = data[1][7];
var v10 = data[2][7];
var v11 = data[3][7];
var v12 = data[0][7];
var url = file.getUrl();
var name = "Site Detail";
var semi = ";";
var hyp = "=hyperlink(\"";
var quot = "\"";
var clos = ")";
var pp = hyp + url + quot + semi + quot + name + quot + clos;
if (Status != 'Those' && Status != 'This' && Status != 'That' && Status != 'Other')
{ sheet.appendRow([pp,v1, v2, v3, v4, v5, v6, v7, v8, v9,v10,v11,v12])
sheet.sort(2);}
}}
So, changing the script to this worked:
var files = folder.getFiles();
while (files.hasNext()) {
var file = files.next();
Utilities.sleep(200);
I cannot tell you why, other than that I suspect it allows the script to "catch up" with itself before moving to the next file. I hope this is helpful to someone, and would love if someone could explain to all of us WHY this worked.
这篇关于什么是“服务错误:电子表格”意思?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!