limpa_mapao_fundamental.js

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

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

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

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

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

    spreadsheet.getRange('Q:Q').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('Y:Y').activate();
    spreadsheet.getActiveSheet().deleteColumns(spreadsheet.getActiveRange().getColumn(), spreadsheet.getActiveRange().getNumColumns());

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

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

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

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

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

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

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

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

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

    spreadsheet.getRange('2:2').activate();
    spreadsheet.getActiveSheet().deleteRows(spreadsheet.getActiveRange().getRow(), spreadsheet.getActiveRange().getNumRows());
  
    sheet.getRange(1, 1, sheet.getMaxRows(), sheet.getMaxColumns()).activate();
    spreadsheet.getActiveRangeList().setFontSize(10);
  
    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, 32);

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

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

    spreadsheet.getRange('A1:BR1').activate().breakApart();
    spreadsheet.getRange('A1:E1').activate().mergeAcross();
  
    spreadsheet.getRange('A2:X2').activate().breakApart();
    spreadsheet.getRange('A2:J2').activate().mergeAcross();

    spreadsheet.getRange('A3:X3').activate().breakApart();
    spreadsheet.getRange('A3:J3').activate().mergeAcross();
  
    spreadsheet.getRange('A4:X4').activate().breakApart();
    spreadsheet.getRange('A4:J4').activate().mergeAcross();

    spreadsheet.getRange('A5:X5').activate().breakApart();
    spreadsheet.getRange('A5:J5').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);

    spreadsheet.getRange('K2:AO2').activate().breakApart();
    spreadsheet.getRange('K2:Z2').activate().mergeAcross();
  
    spreadsheet.getRange('K3:AO3').activate().breakApart();
    spreadsheet.getRange('K3:Z3').activate().mergeAcross();
  
    spreadsheet.getRange('K4:AO4').activate().breakApart();
    spreadsheet.getRange('K4:Z4').activate().mergeAcross();

    spreadsheet.getRange('AA2:AP4').activate();
    spreadsheet.getRange('AA2:AP4').deleteCells(SpreadsheetApp.Dimension.COLUMNS);

    spreadsheet.getRange('A:A').activate();
    spreadsheet.getActiveSheet().autoResizeColumns(1, 1);
  
    spreadsheet.getRange('B:C').activate();
    spreadsheet.getActiveSheet().deleteColumns(spreadsheet.getActiveRange().getColumn(), spreadsheet.getActiveRange().getNumColumns());
  
    spreadsheet.getRange('I5:AM5').activate().breakApart();
    spreadsheet.getRange('Y5:AE5').activate().mergeAcross();
    spreadsheet.getRange('AF5:AL5').activate().mergeAcross();
  
    spreadsheet.getRange('Y5:AE5').activate();
    spreadsheet.getCurrentCell().setValue('DIRETORA');
    spreadsheet.getRange('AF5:AL5').activate();
    spreadsheet.getCurrentCell().setValue('G.O.E');
    spreadsheet.getRange('Y5:AL5').activate();
    spreadsheet.setCurrentCell(spreadsheet.getRange('AF5'));
    spreadsheet.getActiveRangeList().setHorizontalAlignment('center');
  
    spreadsheet.getRange('AF4:AL4').activate();
    spreadsheet.getCurrentCell().setValue('SILVIA ELAINE T. A. DA SILVA');
  
    spreadsheet.getRange('AM:BQ').activate();
    spreadsheet.getActiveSheet().deleteColumns(spreadsheet.getActiveRange().getColumn(), spreadsheet.getActiveRange().getNumColumns());
};