function processAddressRange() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); // ã¿ãåããä½æãã¼ã¿ãã§ãããç¢ºèª if (sheet.getName() !== "ä½æãã¼ã¿") { SpreadsheetApp.getUi().alert('ç¾å¨ã®ã·ã¼ãåã¯ãä½æãã¼ã¿ãã§ã¯ããã¾ããã'); return; } // Aåã®2è¡ç®ä»¥éã§ããã¼ã¿ãå ¥åããã¦ããã»ã«ã®ã¿å¯¾è±¡ var lastRow = sheet.getLastRow(); // æçµè¡ãåå¾ var range = sheet.getRange(2, 1, lastRow - 1, 1); // A2ããAåã®æçµè¡ã¾ã§ã®ç¯å²ãåå¾ var values = range.getValues(
{{#tags}}- {{label}}
{{/tags}}