blocks|key|1164498|text|尝试：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1164499|++const+sheet+=+SpreadsheetApp.getActiveSpreadsheet()
++++++++++++++++++++++++++++++.getSheetByName(`foo`)
++
++sheet.getRange(21,+1,+sheet.getLastRow()-20,+sheet.getLastColumn())
+++++++.clearContent()|code-block|syntax|javascript|1164500|范围被定义为A20以外的所有行。|1164501|功能：|1164502|function+myFunction(allRowsAfter)+{

++const+sheet+=+SpreadsheetApp.getActiveSpreadsheet()
++++++++++++++++++++++++++++++.getSheetByName(`foo`)
++
++sheet.getRange(allRowsAfter%2B1,+1,+sheet.getLastRow()-allRowsAfter,+sheet.getLastColumn())
+++++++.clearContent()

}

myFunction(20);+//+Delete+all+rows+after+20|1164503|见：|offset|length|style|BOLD|1164504|getRange(行、列、numRows、numColumns)|unordered-list-item|1164505|entityMap|0|LINK|mutability|MUTABLE|url|https://developers.google.com/apps-script/reference/spreadsheet/sheet#getrangerow,-column,-numrows,-numcolumns^0|0|0|0|0|0|0|2|0|0|W|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|14|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|15|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|16|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|17|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|18|8|@$O|19|P|1A|Q|R]]|9|@]|A|$]]|$1|S|3|T|5|U|7|1B|8|@]|9|@$O|1C|P|1D|1|1E]]|A|$]]|$1|V|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|W|$X|$5|Y|Z|10|A|$11|12]]]]

<h2>Try:</h2>
<pre><code>  const sheet = SpreadsheetApp.getActiveSpreadsheet()
                              .getSheetByName(`foo`)
  
  sheet.getRange(21, 1, sheet.getLastRow()-20, sheet.getLastColumn())
       .clearContent()
</code></pre>
<p>The range is defined as all rows beyond the equivalent of A20.</p>
<h2>Function:</h2>
<pre><code>function myFunction(allRowsAfter) {

  const sheet = SpreadsheetApp.getActiveSpreadsheet()
                              .getSheetByName(`foo`)
  
  sheet.getRange(allRowsAfter+1, 1, sheet.getLastRow()-allRowsAfter, sheet.getLastColumn())
       .clearContent()

}

myFunction(20); // Delete all rows after 20
</code></pre>
<p><strong>See:</strong></p>
<ul>
<li><a href="https://developers.google.com/apps-script/reference/spreadsheet/sheet#getrangerow,-column,-numrows,-numcolumns" rel="nofollow noreferrer">getRange(row, column, numRows, numColumns)</a></li>
</ul>


blocks|key|73636|text|您需要使用getLastColumn()和getLastRow()方法。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|73637|根据行x，要删除的行数可以由lastRowIndex+-+x+%2B+1计算。在列方面，您只需使用1作为范围的起始值，使用lastColumnIndex删除要删除的列数即可删除所有列。|73638|Logger.log("Starting+script...")

const+ss+=+SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
const+lastRow+=+ss.getLastRow();
const+lastCol+=+ss.getLastColumn();

const+x+=+20;
if(lastRow+-+x+%2B+1+>+0)+{
++ss.getRange(20,+1,+lastRow+-+x+%2B+1,+lastCol).clearContent();
++Logger.log(`Deleting+all+content+in+Range+(${[x,+1,+lastRow+-+x+%2B+1,+lastCol]})`);
}

Logger.log("Done.")|code-block|syntax|javascript|73639|但是，有一件事您需要说明，以防您多次运行，或者x比您的工作表中的最后一行要大。您需要检查范围是否影响至少一行，否则将得到错误的The+number+of+rows+in+the+range+must+be+at+least+1.，因此在删除之前检查lastRow+-+x+%2B+1+>+0。|73640|entityMap|0|LINK|mutability|MUTABLE|url|https://developers.google.com/apps-script/reference/spreadsheet/sheet#getlastcolumn|1|https://developers.google.com/apps-script/reference/spreadsheet/sheet#getlastrow^0|5|F|L|C|5|F|0|L|C|1|0|3|1|E|K|1B|1|1N|F|0|0|N|1|1R|1F|3G|J|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]|$9|11|A|12|B|C]]|D|@$9|13|A|14|1|15]|$9|16|A|17|1|18]]|E|$]]|$1|F|3|G|5|6|7|19|8|@$9|1A|A|1B|B|C]|$9|1C|A|1D|B|C]|$9|1E|A|1F|B|C]|$9|1G|A|1H|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|1I|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|1J|8|@$9|1K|A|1L|B|C]|$9|1M|A|1N|B|C]|$9|1O|A|1P|B|C]]|D|@]|E|$]]|$1|O|3|-4|5|6|7|1Q|8|@]|D|@]|E|$]]]|P|$Q|$5|R|S|T|E|$U|V]]|W|$5|R|S|T|E|$U|X]]]]

<p>You need to use <a href="https://developers.google.com/apps-script/reference/spreadsheet/sheet#getlastcolumn" rel="nofollow noreferrer"><code>getLastColumn()</code></a> and <a href="https://developers.google.com/apps-script/reference/spreadsheet/sheet#getlastrow" rel="nofollow noreferrer"><code>getLastRow()</code></a> methods.</p>
<p>The number of rows to be deleted depending on a row <code>x</code> can be calculated by <code>lastRowIndex - x + 1</code>. In terms of columns you can just delete all columns using <code>1</code> as a start value for the range and <code>lastColumnIndex</code> for the number of columns to remove.</p>
<pre class="lang-js prettyprint-override"><code>Logger.log(&quot;Starting script...&quot;)

const ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
const lastRow = ss.getLastRow();
const lastCol = ss.getLastColumn();

const x = 20;
if(lastRow - x + 1 &gt; 0) {
  ss.getRange(20, 1, lastRow - x + 1, lastCol).clearContent();
  Logger.log(`Deleting all content in Range (${[x, 1, lastRow - x + 1, lastCol]})`);
}

Logger.log(&quot;Done.&quot;)
</code></pre>
<p>However there is one thing you need to account for in case you run this multiple times or <code>x</code> is bigger than the last row with content in you Sheet. You need to check whether the range affects at least one row otherwise you will get an error <code>The number of rows in the range must be at least 1.</code>, so check for <code>lastRow - x + 1 &gt; 0</code> before deletion.</p>


blocks|key|1164540|text|排完后把所有的东西都清理干净|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1164541|function+clearAfterRow(r)+{//clear+everything+after+row+r+
++const+ss+=+SpreadsheetApp.getActive();
++const+sh+=+ss.getSheetByName("foo");
++const+sr+=+r+%2B+1;
++sh.getRange(sr,+1,+sh.getLastRow()+-+sr+%2B+1,+sh.getLastColumn()).clearContent();
}|code-block|syntax|javascript|1164542|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>Clear everything after row</h3>
<pre><code>function clearAfterRow(r) {//clear everything after row r 
  const ss = SpreadsheetApp.getActive();
  const sh = ss.getSheetByName(&quot;foo&quot;);
  const sr = r + 1;
  sh.getRange(sr, 1, sh.getLastRow() - sr + 1, sh.getLastColumn()).clearContent();
}
</code></pre>


<p>I would like to delete all data after row [x]. For example if the x = 355, I want all data to be deleted after 355th row.</p>
<p>I am able to delete all content in a simple sheet in google spreadsheet with:</p>
<pre><code>var sheet = ss.getSheetByName('foo');
sheet.clearContents();
</code></pre>
<p>I've tried to do it with getRange method:</p>
<pre><code>var range = SpreadsheetApp
               .getActive()
               .getSheetByName(&quot;foo&quot;)
               .getRange(&quot;A20:E71&quot;);
range.clearContent();
</code></pre>
<p>but this is simply deleting inside data from A20:E71. What I want is to delete all data after A20th row.</p>


How to clear/delete data after a given row index in Google Spreadsheets

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我想删除x行之后的所有数据。例如，如果x= 355，我希望在第355行之后删除所有数据。我能够删除google电子表格中一个简单的表格中的所有内容：var sheet = ss.getSheetByName('foo');sheet.clearContents();我尝试用getRange方法来实现它：var rang...

问如何清除/删除Google电子表格中给定行索引后的数据
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何清除/删除Google电子表格中给定行索引后的数据EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何清除/删除Google电子表格中给定行索引后的数据
EN