It does not show data when downloading the excel

0
<?php
/*******EDIT LINES 3-8*******/
$DB_Server = "localhost"; //MySQL Server    
$DB_Username = "pcomp"; //MySQL Username     
$DB_Password = "KneTPuxJ77f4YLNX";             //MySQL Password     
$DB_DBName = "base";         //MySQL Database Name  
$DB_TBLName = "reporte"; //MySQL Table Name   
$filename = "rrr"; 

require_once 'Classes/PHPExcel.php';
$sql = "SELECT * FROM $DB_TBLName";
$filename = "CFN"; //your file name

$result123 = mysql_query($sql);

$filename = "CFN"; //your file name
    $objPHPExcel = new PHPExcel();



    // Rename 2nd sheet
    $objPHPExcel->getActiveSheet()->setTitle('rrr');
    /*********************Add column headings START**********************/
    $objPHPExcel->setActiveSheetIndex(0);

 $objPHPExcel->getActiveSheet()->setCellValue('B8', 'id ');
  $objPHPExcel->getActiveSheet()->setCellValue('C8', 'id_aviso');
    $objPHPExcel->getActiveSheet()->setCellValue('D8', 'tipo_defecto');
    $objPHPExcel->getActiveSheet()->setCellValue('E8', 'direccion');
      $objPHPExcel->getActiveSheet()->setCellValue('F8', 'Agencia');
      $objPHPExcel->getActiveSheet()->setCellValue('G8', 'Oficina Central');
    $objPHPExcel->getActiveSheet()->setCellValue('H8', 'tipo_cable');
      $objPHPExcel->getActiveSheet()->setCellValue('I8', 'cable');
      $objPHPExcel->getActiveSheet()->setCellValue('J8', 'armario');
      $objPHPExcel->getActiveSheet()->setCellValue('K8', 'cuenta1');
      $objPHPExcel->getActiveSheet()->setCellValue('L8', 'cuenta2');
    $objPHPExcel->getActiveSheet()->setCellValue('M8', 'cuenta3');
      $objPHPExcel->getActiveSheet()->setCellValue('N8', 'cuenta4');
      $objPHPExcel->getActiveSheet()->setCellValue('O8', 'cuenta5');
      $objPHPExcel->getActiveSheet()->setCellValue('P8', 'fecha_ingreso');
      $objPHPExcel->getActiveSheet()->setCellValue('Q8', 'fecha_respuesta_aviso');
      $objPHPExcel->getActiveSheet()->setCellValue('R8', 'fecha_cfn');
      $objPHPExcel->getActiveSheet()->setCellValue('S8', 'estado');
    $objPHPExcel->getActiveSheet()->setCellValue('T8', 'usuario_ingreso_aviso');
    $objPHPExcel->getActiveSheet()->setCellValue('U8', 'usuario_revisar_aviso');
    $objPHPExcel->getActiveSheet()->setCellValue('V8', 'usuario_respuesta_aviso');
    $objPHPExcel->getActiveSheet()->setCellValue('W8', 'es_cfn'); 
    $objPHPExcel->getActiveSheet()->setCellValue('X8', 'fecha_cfn_resuelto');
    $objPHPExcel->getActiveSheet()->setCellValue('Y8', 'fecha_pruebas');
    $objPHPExcel->getActiveSheet()->setCellValue('Z8', 'fecha_cierre');
    $objPHPExcel->getActiveSheet()->setCellValue('AA8', 'eecc');
    $objPHPExcel->getActiveSheet()->setCellValue('AB8', 'capacidad');
   $objPHPExcel->getActiveSheet()->setCellValue('AC8', 'estado2');
  $objPHPExcel->getActiveSheet()->setCellValue('AD8', 'causa_falla');
  $objPHPExcel->getActiveSheet()->setCellValue('AE8', 'falla_prueba');
  $objPHPExcel->getActiveSheet()->setCellValue('AF8', 'contador_falla_prueba');
  $objPHPExcel->getActiveSheet()->setCellValue('AG8', 'es_localizado');
  $objPHPExcel->getActiveSheet()->setCellValue('AH8', 'nom_tecnico');
  $objPHPExcel->getActiveSheet()->setCellValue('AI8', 'nom_gestor');
  $objPHPExcel->getActiveSheet()->setCellValue('AJ8', 'horas_quiebre');
  $objPHPExcel->getActiveSheet()->setCellValue('AK8', 'descripcion_quiebre');
  $objPHPExcel->getActiveSheet()->setCellValue('AL8', 'tipo_quiebre');
  $objPHPExcel->getActiveSheet()->setCellValue('AM8', 'fecha_quiebre');
  $objPHPExcel->getActiveSheet()->setCellValue('AN8', 'par');
  $objPHPExcel->getActiveSheet()->setCellValue('AO8', 'servicio');
  $objPHPExcel->getActiveSheet()->setCellValue('AP8', 'n_clientes');
  $objPHPExcel->getActiveSheet()->setCellValue('AQ8', 'zona');
  $objPHPExcel->getActiveSheet()->setCellValue('AR8', 'eecc_ere');
  $objPHPExcel->getActiveSheet()->setCellValue('AS8', 'Horas');

    $row = 9; // 1-based index
    while($row_data = mysql_fetch_assoc($result123)) {
        $col = 1;
        foreach($row_data as $key=>$value) {
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $value);
            $col++;
        }
        $row++;
    }

    foreach(range('B','AR') as $columnID) {
        $objPHPExcel->getActiveSheet()->getColumnDimension($columnID)->setWidth(40);
    }

    $objPHPExcel->getActiveSheet()->getStyle('B7:AR8')->getFont()->setBold(true); //Make heading font bold


    /*********************Add color to heading START**********************/

    $objPHPExcel->getActiveSheet()
                ->getStyle('B8:AR8')
                ->getFill()
                ->setFillType(PHPExcel_Style_Fill::FILL_SOLID)
                ->getStartColor()
                ->setARGB('99ff99');
    /*********************Add color to heading END***********************/

    $objDrawing5 = new PHPExcel_Worksheet_MemoryDrawing();
    $objDrawing5->setName('Sample image');
    $objDrawing5->setDescription('Sample image');
    $objDrawing5->setImageResource($gdImage);
    $objDrawing5->setRenderingFunction(PHPExcel_Worksheet_MemoryDrawing::RENDERING_JPEG);
    $objDrawing5->setMimeType(PHPExcel_Worksheet_MemoryDrawing::MIMETYPE_DEFAULT);
    $objDrawing5->setHeight(70);
    $objDrawing5->setCoordinates('A1');
    $objDrawing5->setWorksheet($objPHPExcel->getActiveSheet());

    header('Content-Type: application/vnd.ms-excel');
    header("Content-Disposition: attachment;Filename=$filename.xls");
    header('Cache-Control: max-age=0');
    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
    $objWriter->setIncludeCharts(TRUE);
    $objWriter->save('php://output');
    exit;
?>
    
asked by jeson 04.10.2018 в 14:13
source

0 answers