Inserire una riga al cambio zona

[boots]

Devi mettere $zonaOld in getByZonaCollezione

[boots]

in alternativa puoi modificare la condizione if nel tuo primissimo codice:

$row = 1;
$lenght = count($queryClienti);
foreach ($queryClienti as $cl) {
       $clienteCodice = $cl['cliente'];
       $zona = $cl['zona'];
       $xls->setActiveSheetIndex(0)
        ...
       if(($row == $lenght) || // ultimo elemento
          (isset($queryClienti[$row +1]) && $queryClienti[$row +1]['zona'] != $zona)){
          // aggiungi riga 
       }
       $row++;
} 

[badaze]

Prova cosi.

    // $zonaOld = 'ND';
    $zonaOld = '';
    foreach ($queryClienti as $cl) {
        $clienteCodice = $cl['cliente'];
        $zona = $cl['zona'];

        $xls->setActiveSheetIndex(0)
                ->setCellValue('A' . $row, $zona)
                ->setCellValue('B' . $row, $clienteCodice)
                ->setCellValue('C' . $row, $cl['ragsoc'])
                ->setCellValue('D' . $row, $tmp1Netto)
                ->setCellValue('E' . $row, $tmp1Lordo)
                ->setCellValue('F' . $row, $tmp1Qta)
                ->setCellValue('G' . $row, $tmp2Netto)
                ->setCellValue('H' . $row, $tmp2Lordo)
                ->setCellValue('I' . $row, $tmp2Qta)
                ->setCellValue('J' . $row, $tmp3Netto)
                ->setCellValue('K' . $row, $tmp3Lordo)
                ->setCellValue('L' . $row, $tmp3Qta)
                ->setCellValue('M' . $row, $tmpProp)
                ->setCellValue('N' . $row, $tmpAgente)
                ->setCellValue('O' . $row, $tmpNote);
        $row++;
        
        // CAMBIO ZONA, PROVO AD INSERIRE RIGA
        if ($zonaOld != $zona) {
            $zonaOld = $zona;
            $xls->setActiveSheetIndex(0)
                    ->setCellValue('A' . $row, $zona)
                    ->setCellValue('B' . $row, 'CLIENTI NUOVI')
                    ->setCellValue('C' . $row, '')
                    ->setCellValue('D' . $row, '')
                    ->setCellValue('E' . $row, '')
                    ->setCellValue('F' . $row, '')
                    ->setCellValue('G' . $row, '')
                    ->setCellValue('H' . $row, '')
                    ->setCellValue('I' . $row, '')
                    ->setCellValue('J' . $row, '')
                    ->setCellValue('K' . $row, '')
                    ->setCellValue('L' . $row, $queryBudgetNuovi[0]['bdgn_num_clienti'])
                    ->setCellValue('M' . $row, $queryBudgetNuovi[0]['bdgn_proposta'])
                    ->setCellValue('N' . $row, $queryBudgetNuovi[0]['bdgn_agente'])
                    ->setCellValue('O' . $row, $queryBudgetNuovi[0]['bdgn_note']);
            $row++;
        }

    }

    // se vuoi inserire una riga dopo l'ultimo "record"
            $xls->setActiveSheetIndex(0)
                     ->setCellValue('A' . $row, $zona)
                     ->setCellValue('B' . $row, 'CLIENTI NUOVI')
                     ->setCellValue('C' . $row, '')
                     ->setCellValue('D' . $row, '')
                     ->setCellValue('E' . $row, '')
                     ->setCellValue('F' . $row, '')
                     ->setCellValue('G' . $row, '')
                     ->setCellValue('H' . $row, '')
                     ->setCellValue('I' . $row, '')
                     ->setCellValue('J' . $row, '')
                     ->setCellValue('K' . $row, '')
                     ->setCellValue('L' . $row, $queryBudgetNuovi[0]['bdgn_num_clienti'])
                     ->setCellValue('M' . $row, $queryBudgetNuovi[0]['bdgn_proposta'])
                     ->setCellValue('N' . $row, $queryBudgetNuovi[0]['bdgn_agente'])
                     ->setCellValue('O' . $row, $queryBudgetNuovi[0]['bdgn_note']);