CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets
Pho
Pho

Reputation: 3

Using googlescript deleteRow

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);
  }
}

Upvotes: 0

Views: 59

Answers (1)

TheWizEd
TheWizEd

Reputation: 8616

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

Upvotes: 2

Related Questions