Using googlescript deleteRow

Question

I am trying use google script delete Row 1500 until last row

    function DeleteR() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sn = ss.getSheetByName("xxx");
  if( sn.getLastRow() > 1500 ) {
    sn.deleteRows(1500,sn.getLastRow()-1500+1);
  }
  var sn2 = ss.getSheetByName("xxx2");
  if( sn2.getLastRow() > 1500 ) {
    sn2.deleteRows(1500,sn2.getLastRow()-1500+1);
  }
  var sn3 = ss.getSheetByName("xxx3");
  if( sn3.getLastRow() > 1500 ) {
    sn3.deleteRows(1500,sn3.getLastRow()-1500+1);
  }
}

TheWizEd · Accepted Answer · 2022-04-10 21:12:18Z

2

Description

Use Sheet.deleteRows(rowPosition, howMany)

Script

function DeleteR() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sn = ss.getSheetByName("xxx");
  if( sn.getLastRow() > 1500 ) {
    sn.deleteRows(1500,sn.getLastRow()-1500+1);
  }
}

Reference

Sheet.deleteRows()

answered Apr 10, 2022 at 21:12

TheWizEd

8,6542 gold badges14 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Pho Over a year ago

Hi TheWizEd thx your answer,this is my new script but still wont work you know what's wrong

TheWizEd Over a year ago

Pho, don't post it as an answer. Edit your original post. And all I can say is are you sure there are more than 1500 rows? And does the execution log show any errors?

Pho Over a year ago

Yes i am sure more than 1500 rows,notice is showing Execution completed but i check back 3 sheet nothing has changed

TheWizEd Over a year ago

Sorry maybe it should be if( sn.getLastRow() >= 1500 ) {? How many rows are there?

Pho Over a year ago

I have found the problem because I have a lot of empty rows in my data

|

Collectives™ on Stack Overflow

Using googlescript deleteRow

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related