FunçãoNA.php

$NA_Jaguaris= array('B7:B37','B43:B73','B79:B109');
$NA_Cachoeiras= array('E7:E37','E43:E73','E79:E109');
$NA_Atibainhas= array('H7:H37','H43:H73','H79:H109');
$NA_PaivaCastros= array('K7:K37','K43:K73','K79:K109');
$NA_AguasClarass= array('N7:N37','N43:N73','N79:N109');

function NA($NA_Represas, $Local, $spreadsheet){
    foreach ($NA_Represas as $NA_Represa){
        $rol= $spreadsheet->getActiveSheet()->rangeToArray($NA_Represa);
        //$Rol[].= array($rol);
    }
    $spreadsheet->getActiveSheet()->fromArray($rol, null, $Local);
}

NA($Datas, 'W7', $spreadsheet);
NA($NA_Jaguaris, 'X7', $spreadsheet);
NA($NA_Cachoeiras, 'Z7', $spreadsheet);
NA($NA_Atibainhas, 'AB7', $spreadsheet);
NA($NA_PaivaCastros, 'AD7', $spreadsheet);
NA($NA_AguasClarass, 'AF7', $spreadsheet);