๐Ÿ’พapp.deleteSheetByName()

GAS โŸฉ app โŸฉ methods โŸฉ .deleteSheetByName()

โฌ†๏ธ ๅ…งๅซๆ–ผ๏ผš app

  // ๐Ÿ”ธ app.deleteSheetByName()
  deleteSheetByName(name) {

    const ss = app.spreadsheet;
    let sheet = ss.getSheetByName(name);

    if(sheet === null){ 
      Logger.log(`โš ๏ธ app.deleteSheetByName๏ผšๆฒ’ๆœ‰ใ€Œ${name}ใ€้ ้ขใ€‚`);
      return;
    }

    return ss.deleteSheet(sheet); 
  },

Last updated

Was this helpful?