Conditional on setCellValue phpExcel

Navigation
0

as I can add a conditional within -> setCellValue, for example: 

 ->setCellValue('L'. $i, if($suma==4){ $suma=5});

    $objPHPExcel->setActiveSheetIndex(0)

      ->setCellValue('A'. $i, $row['idemp'])
      ->setCellValue('B'. $i, $row['Nombre'])
      ->setCellValue('C'. $i, $row['fecha'])
    ->setCellValue('D'. $i, $row['horas'])
    ->setCellValue('E'. $i, $row['area'])
    ->setCellValue('F'. $i, $detalles['depto'])
      ->setCellValue('G'. $i, $row['turno'])
      ->setCellValue('H'. $i, $datos['fechaEntrada'])
    ->setCellValue('I'. $i, $datos['fechaSalida'])
      ->setCellValue('J'. $i, $datos['sumaHoras'])
      ->setCellValue('K'. $i, $row['horasDia'])
      ->setCellValue('L'. $i, $suma=abs($datos['sumaHoras']-$row['horasDia']))
      ->setCellValue('M'. $i, $suma);
    
asked by Noel L 21.09.2018 в 00:47
source

1 answer

0

could be like this 

->setCellValue('L'.$i,(($suma==4)?5:$suma));

if $ sum = 4 then print 5 otherwise print the value of $ sum

    
answered by 21.09.2018 / 00:50
source
Pass string field to modal form bootstrap error in arduino with wifi module