๐ŸŸฅapp menu

โฌ†๏ธ ้œ€่ฆ๏ผš app (app.ui)

function onOpen() {
  // โ™ฅ ่‡ช่ฃฝๅทฅๅ…ท
  app.ui.createMenu('๐Ÿงฐ ๅทฅๅ…ท็ฎฑ')
    .addItem('โœ… ๅŽŸๅง‹ๅ ฑ่กจ โž  ็”Ÿๆˆ่ณ‡ๆ–™', 'main')    
    .addItem('โ— ๅˆช้™ค็”Ÿๆˆ่ณ‡ๆ–™', 'deleteSheets')      
    .addToUi();
}

function deleteSheets(){
  app.classes.concat(['ๅ„็ญๅนณๅ‡', '็ญๆŽ’ๅ‰3', 'ๆ กๆŽ’ๅ‰30']).forEach(name => {
    app.deleteSheetByName(name);
  })
}

Last updated