blocks|key|1909024|text|如果您有电子表格的url，此函数将返回所述电子表格的所有工作表的最大行数。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1909025|function+myFunction()+{
++var+spreadsheet+=+SpreadsheetApp.openByUrl("URL+GOES+HERE");
++var+sheets+=+spreadsheet.getSheets();

++let+currentMaximum+=+0;
++for+(var+i+=+0;+i+<+sheets.length;+i%2B%2B){
++++var+numberOfRows+=+sheets[i].getMaxRows();
++++
++++if+(numberOfRows+>+currentMaximum){
++++++currentMaximum+=+numberOfRows;
++++}
++}

++return+currentMaximum;
}|code-block|syntax|javascript|1909026|它使用getSheets()函数获取包含电子表格所有工作表的数组，然后遍历所有这些工作表，使用getMaxRows()函数获取每个电子表格中的行数，并在找到新的最大行数时更新currentMaximum变量。|offset|length|style|CODE|1909027|entityMap|0|LINK|mutability|MUTABLE|url|https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet#getsheets|1|https://developers.google.com/apps-script/reference/spreadsheet/sheet#getmaxrows^0|0|0|2F|E|3|B|0|1B|C|1|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@$I|Z|J|10|K|L]]|9|@$I|11|J|12|1|13]|$I|14|J|15|1|16]]|A|$]]|$1|M|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]|U|$5|P|Q|R|A|$S|V]]]]

<p>If you have the url of a spreadsheet, this function will return the maximum number of rows of all sheets of the said spreadsheet.</p>
<pre class="lang-js prettyprint-override"><code>function myFunction() {
  var spreadsheet = SpreadsheetApp.openByUrl(&quot;URL GOES HERE&quot;);
  var sheets = spreadsheet.getSheets();

  let currentMaximum = 0;
  for (var i = 0; i &lt; sheets.length; i++){
    var numberOfRows = sheets[i].getMaxRows();
    
    if (numberOfRows &gt; currentMaximum){
      currentMaximum = numberOfRows;
    }
  }

  return currentMaximum;
}

</code></pre>
<p>It makes use of the <a href="https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet#getsheets" rel="nofollow noreferrer">getSheets()</a> function to fetch an array containing all the sheets of the spreadsheet, it then loops through all those sheets, uses the <a href="https://developers.google.com/apps-script/reference/spreadsheet/sheet#getmaxrows" rel="nofollow noreferrer">getMaxRows()</a> function to get the number of rows in each spreadsheet and finally updates the <code>currentMaximum</code> variable if a new maximum of rows is found.</p>


blocks|key|1043550|text|一张单张：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1043551|function+myFunction()+{
++
++return+SpreadsheetApp.openByUrl(`SPREADSHEET_URL`)
+++++++++++++++++++++++.getSheets()
+++++++++++++++++++++++.map(i+=>+[i.getSheetName(),+i.getLastRow()])
+++++++++++++++++++++++//+To+view+results:
+++++++++++++++++++++++//.forEach(i+=>+Logger.log(i))

}|code-block|syntax|javascript|1043552|输出：|1043553|[
++[Sheet1,+10],
++[Sheet2,+15],
++[Sheet3,+20]
]|1043554|多张纸：|1043555|function+myFunction()+{
++
++const+spreadsheetUrlList+=+[
++++`...`,
++++`...`,
++++`...`
++]

++return+spreadsheetUrlList.map(i+=>+{
++++const+spreadsheet+=+SpreadsheetApp.openByUrl(i)
++++return+{
++++++SpreadsheetName:+spreadsheet.getName(),
++++++Sheets:+[
++++++++...spreadsheet.getSheets()
++++++++++++++++++++++.map(i+=>+[i.getSheetName(),+i.getLastRow()])
++++++]
++++}
++})
++//+To+view+results:
++//.forEach(i+=>+i.Sheets.forEach(item+=>+Logger.log(`(${i.SpreadsheetName})+"${item[0]}":+${item[1]}`)))

}|1043556|1043557|[
++{
++++SpreadsheetName:+`MySpreadsheet`,
++++Sheets:+[
++++++['Sheet1',+50],
++++++['Sheet2',+40]
++++]
++},
++{
++++SpreadsheetName:+`MySpreadsheet2`,
++++Sheets:+[
++++++['Sheet1',+30],
++++++['Sheet2',+70]
++++]
++},
...
]|1043558|如果您有任何问题或想要不同的输出格式，请告诉我！|1043559|entityMap^0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|W|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|X|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|Y|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|Z|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|10|8|@]|9|@]|A|$E|F]]|$1|O|3|H|5|6|7|11|8|@]|9|@]|A|$]]|$1|P|3|Q|5|D|7|12|8|@]|9|@]|A|$E|F]]|$1|R|3|S|5|6|7|13|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|U|$]]

<h2>For a Single Sheet:</h2>
<pre><code>function myFunction() {
  
  return SpreadsheetApp.openByUrl(`SPREADSHEET_URL`)
                       .getSheets()
                       .map(i =&gt; [i.getSheetName(), i.getLastRow()])
                       // To view results:
                       //.forEach(i =&gt; Logger.log(i))

}
</code></pre>
<p>Output:</p>
<pre><code>[
  [Sheet1, 10],
  [Sheet2, 15],
  [Sheet3, 20]
]
</code></pre>
<h2>For Multiple Sheets:</h2>
<pre><code>function myFunction() {
  
  const spreadsheetUrlList = [
    `...`,
    `...`,
    `...`
  ]

  return spreadsheetUrlList.map(i =&gt; {
    const spreadsheet = SpreadsheetApp.openByUrl(i)
    return {
      SpreadsheetName: spreadsheet.getName(),
      Sheets: [
        ...spreadsheet.getSheets()
                      .map(i =&gt; [i.getSheetName(), i.getLastRow()])
      ]
    }
  })
  // To view results:
  //.forEach(i =&gt; i.Sheets.forEach(item =&gt; Logger.log(`(${i.SpreadsheetName}) &quot;${item[0]}&quot;: ${item[1]}`)))

}
</code></pre>
<p>Output:</p>
<pre><code>[
  {
    SpreadsheetName: `MySpreadsheet`,
    Sheets: [
      ['Sheet1', 50],
      ['Sheet2', 40]
    ]
  },
  {
    SpreadsheetName: `MySpreadsheet2`,
    Sheets: [
      ['Sheet1', 30],
      ['Sheet2', 70]
    ]
  },
...
]
</code></pre>
<p>Let me know if you have any questions or would like different output formats!</p>


blocks|key|1897900|text|电子表格的最大行数|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1897901|function+maxrows(id=SpreadsheetApp.getActive().getId())+{
++Logger.log(SpreadsheetApp.openById(id).getSheets().map(sh+=>+sh.getMaxRows()).sort((a,b)+=>+b+-+a)[0]);
}

Execution+log
12:03:34+PM+Notice++Execution+started
12:03:34+PM+Info++++4994.0
12:03:35+PM+Notice++Execution+completed|code-block|syntax|javascript|1897902|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

<h3>Max rows for spreadsheet</h3>
<pre><code>function maxrows(id=SpreadsheetApp.getActive().getId()) {
  Logger.log(SpreadsheetApp.openById(id).getSheets().map(sh =&gt; sh.getMaxRows()).sort((a,b) =&gt; b - a)[0]);
}

Execution log
12:03:34 PM Notice  Execution started
12:03:34 PM Info    4994.0
12:03:35 PM Notice  Execution completed
</code></pre>


<p>I am trying to count the maximum number of rows in other google sheets. Actually, Each spreadsheet has a number of tabs and I want the maximum row number of all tabs under each spreadsheet.</p>
<p>I find that <code>IMPORTRANGE</code> function can get the data from other spreadsheet with URL, however, this function can only read the data with sheet name. To get the sheet name list, I think the function below might be useful:</p>
<pre><code>function sheetnames() { 
var out = new Array()
var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
return out
}
</code></pre>
<p>But this function only works in the sheet it is in and to write this function in every single sheet is obviously impossible, so here is my question:</p>
<p><strong>Is it possible to  improve the <code>sheetnames()</code>function to get the sheet names from other sheets? (with URL? I'm not sure) Or How can I realize it with other methods?</strong></p>
<p>Thanks a lot for your patience!</p>


Count the maximum number of rows in another google sheets

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我正试图在其他谷歌页面中计算最大行数。实际上，每个电子表格都有许多选项卡，我希望每个电子表格下的所有选项卡的最大行数。我发现IMPORTRANGE函数可以使用URL从其他电子表格中获取数据，但是该函数只能读取带有工作表名称的数据。要获得工作表名称列表，我认为下面的函数可能是有用的：function sheetnames...

问计算另一个google工作表中的最大行数
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问计算另一个google工作表中的最大行数EN