limpa_mapao_medio.js

function remove_colunas(spreadsheet) {
    spreadsheet.getRange('BN:BN').activate();
    spreadsheet.getActiveSheet().deleteColumns(spreadsheet.getActiveRange().getColumn(), spreadsheet.getActiveRange().getNumColumns());

    spreadsheet.getRange('BI:BI').activate();
    spreadsheet.getActiveSheet().deleteColumns(spreadsheet.getActiveRange().getColumn(), spreadsheet.getActiveRange().getNumColumns());

    spreadsheet.getRange('BD:BD').activate();
    spreadsheet.getActiveSheet().deleteColumns(spreadsheet.getActiveRange().getColumn(), spreadsheet.getActiveRange().getNumColumns());

    spreadsheet.getRange('AY:AY').activate();
    spreadsheet.getActiveSheet().deleteColumns(spreadsheet.getActiveRange().getColumn(), spreadsheet.getActiveRange().getNumColumns());

    spreadsheet.getRange('AT:AT').activate();
    spreadsheet.getActiveSheet().deleteColumns(spreadsheet.getActiveRange().getColumn(), spreadsheet.getActiveRange().getNumColumns());

    spreadsheet.getRange('AO:AO').activate();
    spreadsheet.getActiveSheet().deleteColumns(spreadsheet.getActiveRange().getColumn(), spreadsheet.getActiveRange().getNumColumns());

    spreadsheet.getRange('AJ:AJ').activate();
    spreadsheet.getActiveSheet().deleteColumns(spreadsheet.getActiveRange().getColumn(), spreadsheet.getActiveRange().getNumColumns());

    spreadsheet.getRange('AE:AE').activate();
    spreadsheet.getActiveSheet().deleteColumns(spreadsheet.getActiveRange().getColumn(), spreadsheet.getActiveRange().getNumColumns());

    spreadsheet.getRange('Z:Z').activate();
    spreadsheet.getActiveSheet().deleteColumns(spreadsheet.getActiveRange().getColumn(), spreadsheet.getActiveRange().getNumColumns());

    spreadsheet.getRange('U:U').activate();
    spreadsheet.getActiveSheet().deleteColumns(spreadsheet.getActiveRange().getColumn(), spreadsheet.getActiveRange().getNumColumns());

    spreadsheet.getRange('P:P').activate();
    spreadsheet.getActiveSheet().deleteColumns(spreadsheet.getActiveRange().getColumn(), spreadsheet.getActiveRange().getNumColumns());

    spreadsheet.getRange('K:K').activate();
    spreadsheet.getActiveSheet().deleteColumns(spreadsheet.getActiveRange().getColumn(), spreadsheet.getActiveRange().getNumColumns());

    spreadsheet.getRange('F:F').activate();
    spreadsheet.getActiveSheet().deleteColumns(spreadsheet.getActiveRange().getColumn(), spreadsheet.getActiveRange().getNumColumns());

    spreadsheet.getRange('A:A').activate();
    spreadsheet.getActiveSheet().deleteColumns(spreadsheet.getActiveRange().getColumn(), spreadsheet.getActiveRange().getNumColumns());
}

function remove_linhas(spreadsheet) {
    spreadsheet.getRange('15:15').activate();
    spreadsheet.getActiveSheet().deleteRows(spreadsheet.getActiveRange().getRow(), spreadsheet.getActiveRange().getNumRows());

    spreadsheet.getRange('11:11').activate();
    spreadsheet.getActiveSheet().deleteRows(spreadsheet.getActiveRange().getRow(), spreadsheet.getActiveRange().getNumRows());

    spreadsheet.getRange('10:10').activate();
    spreadsheet.getActiveSheet().deleteRows(spreadsheet.getActiveRange().getRow(), spreadsheet.getActiveRange().getNumRows());

    spreadsheet.getRange('5:5').activate();
    spreadsheet.getActiveSheet().deleteRows(spreadsheet.getActiveRange().getRow(), spreadsheet.getActiveRange().getNumRows());

    spreadsheet.getRange('4:4').activate();
    spreadsheet.getActiveSheet().deleteRows(spreadsheet.getActiveRange().getRow(), spreadsheet.getActiveRange().getNumRows());

    spreadsheet.getRange('2:2').activate();
    spreadsheet.getActiveSheet().deleteRows(spreadsheet.getActiveRange().getRow(), spreadsheet.getActiveRange().getNumRows());

    spreadsheet.getRange('1:1').activate();
    spreadsheet.getActiveSheet().deleteRows(spreadsheet.getActiveRange().getRow(), spreadsheet.getActiveRange().getNumRows());
}

function todos_font_10(sheet, spreadsheet) {
    var sheet = spreadsheet.getActiveSheet();

    sheet.getRange(1, 1, sheet.getMaxRows(), sheet.getMaxColumns()).activate();
    spreadsheet.getActiveRangeList().setFontSize(10);
}

function tamanho_celula(spreadsheet) {
    spreadsheet.getRange('D:D').activate();
    spreadsheet.getActiveSheet().setColumnWidth(4, 29);

    spreadsheet.getRange('E:E').activate();
    spreadsheet.getActiveSheet().setColumnWidth(5, 29);

    spreadsheet.getRange('F:F').activate();
    spreadsheet.getActiveSheet().setColumnWidth(6, 29);

    spreadsheet.getRange('G:G').activate();
    spreadsheet.getActiveSheet().setColumnWidth(7, 29);

    spreadsheet.getRange('H:H').activate();
    spreadsheet.getActiveSheet().setColumnWidth(8, 29);

    spreadsheet.getRange('I:I').activate();
    spreadsheet.getActiveSheet().setColumnWidth(9, 29);

    spreadsheet.getRange('J:J').activate();
    spreadsheet.getActiveSheet().setColumnWidth(10, 29);

    spreadsheet.getRange('K:K').activate();
    spreadsheet.getActiveSheet().setColumnWidth(11, 29);

    spreadsheet.getRange('L:L').activate();
    spreadsheet.getActiveSheet().setColumnWidth(12, 29);

    spreadsheet.getRange('M:M').activate();
    spreadsheet.getActiveSheet().setColumnWidth(13, 29);

    spreadsheet.getRange('N:N').activate();
    spreadsheet.getActiveSheet().setColumnWidth(14, 29);

    spreadsheet.getRange('O:O').activate();
    spreadsheet.getActiveSheet().setColumnWidth(15, 29);

    spreadsheet.getRange('P:P').activate();
    spreadsheet.getActiveSheet().setColumnWidth(16, 29);

    spreadsheet.getRange('Q:Q').activate();
    spreadsheet.getActiveSheet().setColumnWidth(17, 29);

    spreadsheet.getRange('R:R').activate();
    spreadsheet.getActiveSheet().setColumnWidth(18, 29);

    spreadsheet.getRange('S:S').activate();
    spreadsheet.getActiveSheet().setColumnWidth(19, 29);

    spreadsheet.getRange('T:T').activate();
    spreadsheet.getActiveSheet().setColumnWidth(20, 29);

    spreadsheet.getRange('U:U').activate();
    spreadsheet.getActiveSheet().setColumnWidth(21, 29);

    spreadsheet.getRange('V:V').activate();
    spreadsheet.getActiveSheet().setColumnWidth(22, 29);

    spreadsheet.getRange('W:W').activate();
    spreadsheet.getActiveSheet().setColumnWidth(23, 29);

    spreadsheet.getRange('X:X').activate();
    spreadsheet.getActiveSheet().setColumnWidth(24, 29);

    spreadsheet.getRange('Y:Y').activate();
    spreadsheet.getActiveSheet().setColumnWidth(25, 29);

    spreadsheet.getRange('Z:Z').activate();
    spreadsheet.getActiveSheet().setColumnWidth(26, 29);

    spreadsheet.getRange('AA:AA').activate();
    spreadsheet.getActiveSheet().setColumnWidth(27, 29);

    spreadsheet.getRange('AB:AB').activate();
    spreadsheet.getActiveSheet().setColumnWidth(28, 29);

    spreadsheet.getRange('AC:AC').activate();
    spreadsheet.getActiveSheet().setColumnWidth(29, 29);

    spreadsheet.getRange('AD:AD').activate();
    spreadsheet.getActiveSheet().setColumnWidth(30, 29);

    spreadsheet.getRange('AE:AE').activate();
    spreadsheet.getActiveSheet().setColumnWidth(31, 29);

    spreadsheet.getRange('AF:AF').activate();
    spreadsheet.getActiveSheet().setColumnWidth(32, 29);

    spreadsheet.getRange('AG:AG').activate();
    spreadsheet.getActiveSheet().setColumnWidth(33, 29);

    spreadsheet.getRange('AH:AH').activate();
    spreadsheet.getActiveSheet().setColumnWidth(34, 29);

    spreadsheet.getRange('AI:AI').activate();
    spreadsheet.getActiveSheet().setColumnWidth(35, 29);

    spreadsheet.getRange('AJ:AJ').activate();
    spreadsheet.getActiveSheet().setColumnWidth(36, 29);

    spreadsheet.getRange('AK:AK').activate();
    spreadsheet.getActiveSheet().setColumnWidth(37, 29);

    spreadsheet.getRange('AL:AL').activate();
    spreadsheet.getActiveSheet().setColumnWidth(38, 29);

    spreadsheet.getRange('AM:AM').activate();
    spreadsheet.getActiveSheet().setColumnWidth(39, 29);

    spreadsheet.getRange('AN:AN').activate();
    spreadsheet.getActiveSheet().setColumnWidth(40, 29);

    spreadsheet.getRange('AO:AO').activate();
    spreadsheet.getActiveSheet().setColumnWidth(41, 29);

    spreadsheet.getRange('AP:AP').activate();
    spreadsheet.getActiveSheet().setColumnWidth(42, 29);

    spreadsheet.getRange('AQ:AQ').activate();
    spreadsheet.getActiveSheet().setColumnWidth(43, 29);

    spreadsheet.getRange('AR:AR').activate();
    spreadsheet.getActiveSheet().setColumnWidth(44, 29);

    spreadsheet.getRange('AS:AS').activate();
    spreadsheet.getActiveSheet().setColumnWidth(45, 29);

    spreadsheet.getRange('AT:AT').activate();
    spreadsheet.getActiveSheet().setColumnWidth(46, 29);

    spreadsheet.getRange('AU:AU').activate();
    spreadsheet.getActiveSheet().setColumnWidth(47, 29);

    spreadsheet.getRange('AV:AV').activate();
    spreadsheet.getActiveSheet().setColumnWidth(48, 29);

    spreadsheet.getRange('AW:AW').activate();
    spreadsheet.getActiveSheet().setColumnWidth(49, 29);

    spreadsheet.getRange('AX:AX').activate();
    spreadsheet.getActiveSheet().setColumnWidth(50, 29);

    spreadsheet.getRange('AY:AY').activate();
    spreadsheet.getActiveSheet().setColumnWidth(51, 29);

    spreadsheet.getRange('AZ:AZ').activate();
    spreadsheet.getActiveSheet().setColumnWidth(52, 29);

    spreadsheet.getRange('BA:BA').activate();
    spreadsheet.getActiveSheet().setColumnWidth(53, 66);

    spreadsheet.getRange('BB:BB').activate();
    spreadsheet.getActiveSheet().setColumnWidth(54, 76);

    spreadsheet.getRange('BC:BC').activate();
    spreadsheet.getActiveSheet().setColumnWidth(55, 76);

    spreadsheet.getRange('BD:BD').activate();
    spreadsheet.getActiveSheet().setColumnWidth(56, 100);
}

function limpa_cabecalho(spreadsheet) {
    spreadsheet.getRange('A1:BR1').activate().breakApart();
    spreadsheet.getRange('A1:A1').activate().mergeAcross();

    spreadsheet.getRange('A2:X2').activate().breakApart();
    spreadsheet.getRange('A2:A2').activate().mergeAcross();

    spreadsheet.getRange('A3:X3').activate().breakApart();
    spreadsheet.getRange('A3:A3').activate().mergeAcross();

    spreadsheet.getRange('A4:X4').activate().breakApart();
    spreadsheet.getRange('A4:A4').activate().mergeAcross();

    spreadsheet.getRange('A5:X5').activate().breakApart();
    spreadsheet.getRange('A5:A5').activate().mergeAcross();

    spreadsheet.getRange('K2:X2').activate();
    spreadsheet.getRange('K2:X2').deleteCells(SpreadsheetApp.Dimension.COLUMNS);

    spreadsheet.getRange('K3:X3').activate();
    spreadsheet.getRange('K3:X3').deleteCells(SpreadsheetApp.Dimension.COLUMNS);

    spreadsheet.getRange('K4:X4').activate();
    spreadsheet.getRange('K4:X4').deleteCells(SpreadsheetApp.Dimension.COLUMNS);

    spreadsheet.getRange('K5:X5').activate();
    spreadsheet.getRange('K5:X5').deleteCells(SpreadsheetApp.Dimension.COLUMNS);
}

function ajusta_nomes_alunos(spreadsheet) {
    spreadsheet.getRange('A:A').activate();
    spreadsheet.getActiveSheet().autoResizeColumns(1, 1);

    spreadsheet.getRange('A:A').activate();
    spreadsheet.getActiveSheet().setColumnWidth(1, 400);
}

function ajusta_nomes_direcao(spreadsheet) {
    spreadsheet.getRange('AM4:AS4').activate().mergeAcross();

    spreadsheet.getRange('AM4:AS4').activate();
    spreadsheet.getCurrentCell().setValue('AGABI DE LURDES MORAIS');

    spreadsheet.getRange('AM5:AS5').activate().mergeAcross();

    spreadsheet.getRange('AM5:AS5').activate();
    spreadsheet.getCurrentCell().setValue('DIRETORA');
}

function ajusta_nomes_goe(spreadsheet) {
    spreadsheet.getRange('AT4:AZ4').activate().mergeAcross();

    spreadsheet.getRange('AT4:AZ4').activate();
    spreadsheet.getCurrentCell().setValue('SILVIA ELAINE T. A. DA SILVA');

    spreadsheet.getRange('AT5:AZ5').activate().mergeAcross();

    spreadsheet.getRange('AT5:AZ5').activate();
    spreadsheet.getCurrentCell().setValue('G.O.E');
}

function start() {
    var spreadsheet = SpreadsheetApp.getActive();
    var sheet = spreadsheet.getActiveSheet();

    remove_colunas(spreadsheet);

    remove_linhas(spreadsheet);

    todos_font_10(sheet, spreadsheet);

    tamanho_celula(spreadsheet);

    limpa_cabecalho(spreadsheet);

    ajusta_nomes_alunos(spreadsheet);

    ajusta_nomes_direcao(spreadsheet);

    ajusta_nomes_goe(spreadsheet);
}