如何在谷歌表格中打开多个标签页

Question

>我正在尝试一次打开多个选项卡，但只有第一个和最后一个会打开，而不是中间的选项卡，我哪里出错了？

function openNewSheet(){
opensheet1();
opensheet2();
opensheet3();
opensheet4();
opensheet5();
opensheet6();  
}  
function opensheet1(){
var url = "https://docs.google.com/spreadsheets/d/11qWurk-ZbT0dfC1nnQ_xoxdfiFmf2YcXtyhnPlCqK0Q";
var html = "<script>window.open('" + url + "');google.script.host.close();</script>";
var userInterface = HtmlService.createHtmlOutput(html);
SpreadsheetApp.getUi().showModalDialog(userInterface, "Open Sheet"); }
function opensheet2(){
var url2 = "https://docs.google.com/spreadsheets/d/1GyRO_m0vFcWL8wMOvR3m_skrYofnwLAJwsZAAjJvDak";
var html2 = "<script>window.open('" + url2 + "');google.script.host.close();</script>";
var userInterface2 = HtmlService.createHtmlOutput(html2);
SpreadsheetApp.getUi().showModalDialog(userInterface2, "Open Sheet2"); }
function opensheet3(){   
var url3 = "https://docs.google.com/spreadsheets/d/1cKyVHmB3Eb5ycDGdqzro8qwfiSqTCZHafoVBSdJ4v7I";
var html3 = "<script>window.open('" + url3 + "');google.script.host.close();</script>";
var userInterface3 = HtmlService.createHtmlOutput(html3);
SpreadsheetApp.getUi().showModalDialog(userInterface3, "Open Sheet3"); }
function opensheet4(){
var url4 = "https://docs.google.com/spreadsheets/d/1OSSbx9UojeK9jtPmnOlm_exzcEakC7fYGU0XQBG-AQw";
var html4 = "<script>window.open('" + url4 + "');google.script.host.close();</script>";
var userInterface4 = HtmlService.createHtmlOutput(html4);
SpreadsheetApp.getUi().showModalDialog(userInterface4, "Open Sheet4"); }
function opensheet5(){ 
var url5 = "https://docs.google.com/spreadsheets/d/1U6xNOkRoGk6lhTuFekGr7rFEKrBPjB76wWqs1spDmPs";
var html5 = "<script>window.open('" + url5 + "');google.script.host.close();</script>";
var userInterface5 = HtmlService.createHtmlOutput(html5);
SpreadsheetApp.getUi().showModalDialog(userInterface5, "Open Sheet5"); }
function opensheet6(){
var url6 = "https://docs.google.com/spreadsheets/d/16YjBCa0gAuZZ6VhcRyivQP2u5WiEgMrd-gXLSNKV9zI";
var html6 = "<script>window.open('" + url6 + "');google.script.host.close();</script>";
var userInterface6 = HtmlService.createHtmlOutput(html6);
SpreadsheetApp.getUi().showModalDialog(userInterface6, "Open Sheet6"); }

如何确保中间四个选项卡以及第一个和最后一个选项卡打开？

Answer 1

出现此问题的原因是 Google Apps 脚本不会等待showModalDialog完成，并且 Google Apps 脚本对话框加载html代码的速度很慢。

在代码打开具有足够大的milliseconds值以允许模式对话框执行html代码的模式对话框后，可以使用Utilities.sleep(milliseconds)。

另一种方法是使用单个模式对话框打开所有电子表格。请参阅在新标签页(而非新窗口中打开 URL(