Generar ficheros Excel

https://phpexcel.codeplex.com/

EJ General:

$objPHPExcel = new PHPExcel();
 $cacheMethod = PHPExcel_CachedObjectStorageFactory:: cache_to_phpTemp;
 $cacheSettings = array(' memoryCacheSize ' => '128M');
PHPExcel_Settings::setCacheStorageMethod($cacheMethod, $cacheSettings);

 $objPHPExcel->setActiveSheetIndex(0);
  $i = 1;
   
    $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
    $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);
    $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
    $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true);
...
$objPHPExcel->getActiveSheet()->getStyle("A2")->getFont()->setBold(true);
 $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(18);

----------------------
  foreach ($arr as $clave => $valor) {
         $objPHPExcel->getActiveSheet()->setCellValue("A".$i, $clave.":");
         $objPHPExcel->getActiveSheet()->setCellValue("B".$i, $valor);
        $objPHPExcel->setActiveSheetIndex(0);
        cellColor('A'.$i, $arrColores[$contColor]);
        cellColor('B'.$i, $arrColores[$contColor]);
        $objPHPExcel->getActiveSheet()->getStyle('A'.$i)->getFont()->setColor( $phpColor );
        $objPHPExcel->getActiveSheet()->getStyle('B'.$i)->getFont()->setColor( $phpColor );
        $i++;
        $contColor++;
        if ($contColor==5)
            $contColor = 0;
     }
............................................
 $objPHPExcel->getActiveSheet()->setCellValue("A".$i, "Fecha alta");
    $objPHPExcel->setActiveSheetIndex(0);
    $objPHPExcel->getActiveSheet()->setCellValue("B".$i, "Id Comercial");
    $objPHPExcel->setActiveSheetIndex(0);
    $objPHPExcel->getActiveSheet()->setCellValue("C".$i, "Tratamiento");
    $objPHPExcel->setActiveSheetIndex(0);
-----------------------------------------
 $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
 if(file_exists("excelPrueba.xlsx")){
        unlink("excelPrueba.xlsx");
 }
 $objWriter->save("excelPrueba.xlsx");
 header("location: excelPrueba.xlsx");