PHP - Se puede crear un Excel con encabezado y totales en PHP?

funcion para los Headers

   funcion para los Detalles

      funcion para los totales por factura

         funcion para el total general de todo (que es una suma de los valores que están en los headers)

funcion para los Headers

   funcion para los Detalles

      funcion para los totales por factura

         funcion para el total general de todo (que es una suma de los valores que están en los headers)

$data = array (

  array(

    'product_code' => 'S284056',

    'product_name' => 'Ferrary F1234',

    'customer_code' => 'CUST1234',

    'customer_name' => 'Gino Ginetti',

    'amount' => 250000),

  array('product_code' => 'S284056',

    'product_name' => 'Ferrary F1234',

    'customer_code' => 'CUST1100',

    'customer_name' => 'Gongolo Nannolo',

    'amount' => 270000 ),

  array('product_code' => 'S284056',

    'product_name' => 'Ferrary F12345',

    'customer_code' => 'CUST1100',

    'customer_name' => 'Gongolo Nannolo',

    'amount' => 280000 ),

  array('product_code' => 'S292383',

    'product_name' => 'Lardonghini Mucila',

    'customer_code' => 'CUST0120',

    'customer_name' => 'Pasquale Pasqualini',

    'amount' => 352000 ),

  array('product_code' => 'S292383',

    'product_name' => 'Lardonghini Mucila',

    'customer_code' => 'CUST1234',

    'customer_name' => 'Gino Ginetti',

    'amount' => 352000 ),

  array('product_code' => 'S898964',

    'product_name' => 'Porsck Paprika',

    'customer_code' => 'CUST0120',

    'customer_name' => 'Pasquale Pasqualini',

    'amount' => 352000 ),

  array('product_code' => 'S898964',

    'product_name' => 'Porsck Paprika',

    'customer_code' => 'CUST0054',

    'customer_name' => 'Pino Pinerati',

    'amount' => 175000 )

);

$lastProductCode = null;

$breakProduct = true;

$productTotal = null;

$row = 4;

foreach($data as $key => $temp) {

    $breakProduct = $temp['product_code'] != $lastProductCode;

    /*if ($breakProduct) {

        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, $row, $lastProductCode);

    }*/

    if ($breakProduct) {

        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, $row, $productTotal);

        $objPHPExcel->setActiveSheetIndex(0)

                ->setCellValue('A'.$row+=1,$temp['product_code']);

        $objPHPExcel->getActiveSheet()->getStyle('A'.$row)->applyFromArray($styleArray);

        $objPHPExcel->getActiveSheet()->mergeCells('A'.$row.':'.'E'.$row);

        //$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $row+=1, 'hola');

        //$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $row, 'hola');

        $objPHPExcel->setActiveSheetIndex(0)

            ->setCellValue('A'.$row+=1, 'Codigo del Producto')

            ->setCellValue('B'.$row, 'Nombre del Producto')

            ->setCellValue('C'.$row, 'Identificacion del Cliente')

            ->setCellValue('D'.$row, 'Nombre del Cliente')

            ->setCellValue('E'.$row, 'Valor');

        $row++;

    }

    $col = 0;

    foreach(array_keys($temp) as $value) {

        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $temp[$value]);

        $col++;

    }

    $row++;

    $lastProductCode = $temp['product_code'];

}