Clear (not delete) all NamedRanges in google spreadsheet -


i have tons of namedranges in spreadsheets. areas enter data. how function clear values in namedranges @ once? (all found far this, clears 1 specific range)

  function clearrange1() {    //replace 'sheet1' actual sheet name   var sheet = spreadsheetapp.getactive().getsheetbyname('sheet1');   sheet.getrange('b7:g7').clearcontent();   } 

i believe this. didn't see way progamatically names of of ranges in spreadsheet. if there function that, great know it.

function clearallnamedranges() {    var ss = spreadsheetapp.getactive();    var namedranges = [ "sheet1!a3:b5",                       "rangename1",                       "myfunsheet!c5:h26" ];    namedranges.foreach(function(rangename) {      ss.getrangebyname(rangename).clearcontent();    }); } 

Comments

Popular posts from this blog

php - Calling a template part from a post -

Firefox SVG shape not printing when it has stroke -

How to mention the localhost in android -