Skip to content

Instantly share code, notes, and snippets.

@ShilGen

ShilGen/createSheetsFromTemplate.js

Created October 24, 2025 16:41
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ShilGen/eecda25f2befbb02a911db52a79115b1 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ShilGen/eecda25f2befbb02a911db52a79115b1 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. ShilGen created this gist Oct 24, 2025.
    43 changes: 43 additions & 0 deletions createSheetsFromTemplate.js
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,43 @@
    function createSheetsFromTemplate() {
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var templateSheet = ss.getSheetByName('Шаблон');
    var dataSheet = ss.getSheetByName('Sheet3');

    if (!templateSheet) {
    Logger.log('Лист "Шаблон" не найден!');
    return;
    }

    if (!dataSheet) {
    Logger.log('Лист "Sheet3" не найден!');
    return;
    }

    // Получаем названия из диапазона A1:A75
    var names = dataSheet.getRange('A1:A75').getValues();

    // Создаем листы
    for (var i = 0; i < names.length; i++) {
    var sheetName = names[i][0];

    // Пропускаем пустые ячейки
    if (sheetName === '' || sheetName === null) {
    continue;
    }

    // Проверяем, существует ли уже лист с таким именем
    var existingSheet = ss.getSheetByName(sheetName);
    if (existingSheet) {
    Logger.log('Лист "' + sheetName + '" уже существует, пропускаем.');
    continue;
    }

    // Копируем шаблон
    var newSheet = templateSheet.copyTo(ss);
    newSheet.setName(sheetName);

    Logger.log('Создан лист: ' + sheetName);
    }

    Logger.log('Готово! Листы созданы.');
    }