Call up several books and clean their contents

Viero
New Member

Hello,
I am making a code to create a function that at the moment of pressing a button, exports the information of several books to a PDF and once finished, it deletes the data of some specific cells, however to make the call of those books I need to call it via URL, but it wonโ€™t let me call them, just doing them 1 by 1 and thatโ€™s very tedious โ€ฆ I donโ€™t know if Iโ€™ll have to call them via URL
I leave the code that I am using where the โ€œopenBy URL ()โ€ is where I must place the addresses of several books โ€ฆ
function clear_sheeds(){

var Activ = SpreadsheetApp.openByUrl(โ€œCaptura4 - Google Sheetsโ€);

var uf = Activ.getLastRow();

var cel = Activ.getRange(โ€œC11:Cโ€).clearContent();

var cel2 = Activ.getRange(โ€œF11:Fโ€).clearContent();

}

0 2 106
2 REPLIES 2
Top Labels in this Space