Because when exporting an excel file in php some of the rows of data leaves run by the example what should come out in A1 leaves in cell A2

0
$result123 = mysql_query($sql123);


    $filename = 'CFN por resolver'; //your file name
    $objPHPExcel = new PHPExcel();
    $gdImage = imagecreatefromjpeg('imagenes/logo.jpg');


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

$objPHPExcel->getActiveSheet()->setCellValue('B8', 'titulo');
    $objPHPExcel->getActiveSheet()->setCellValue('C8', 'titulo');
    $objPHPExcel->getActiveSheet()->setCellValue('D8', 'titulo');
      $objPHPExcel->getActiveSheet()->setCellValue('E8', 'titulo');
      $objPHPExcel->getActiveSheet()->setCellValue('F8', 'titulo');
    $objPHPExcel->getActiveSheet()->setCellValue('G8', 'titulo');
      $objPHPExcel->getActiveSheet()->setCellValue('H8', 'titulo');
      $objPHPExcel->getActiveSheet()->setCellValue('I8', 'titulo');
      $objPHPExcel->getActiveSheet()->setCellValue('J8', 'titulo');
      $objPHPExcel->getActiveSheet()->setCellValue('K8', 'titulo');
    $objPHPExcel->getActiveSheet()->setCellValue('L8', 'titulo');
      $objPHPExcel->getActiveSheet()->setCellValue('M8', 'titulo');
      $objPHPExcel->getActiveSheet()->setCellValue('N8', 'titulo');
      $objPHPExcel->getActiveSheet()->setCellValue('O8', 'titulo');
      $objPHPExcel->getActiveSheet()->setCellValue('P8', 'titulo');
      $objPHPExcel->getActiveSheet()->setCellValue('Q8', 'titulo');
      $objPHPExcel->getActiveSheet()->setCellValue('R8', 'titulo');
    $objPHPExcel->getActiveSheet()->setCellValue('S8', 'titulo');
    $objPHPExcel->getActiveSheet()->setCellValue('T8', 'titulo');
    $objPHPExcel->getActiveSheet()->setCellValue('U8', 'titulo');
    $objPHPExcel->getActiveSheet()->setCellValue('V8', 'titulo'); 
    $objPHPExcel->getActiveSheet()->setCellValue('W8', 'titulo');
    $objPHPExcel->getActiveSheet()->setCellValue('X8', 'titulo');
    $objPHPExcel->getActiveSheet()->setCellValue('Y8', 'titulo');
    $objPHPExcel->getActiveSheet()->setCellValue('Z8', 'titulo');
    $objPHPExcel->getActiveSheet()->setCellValue('AA8', 'titulo');
   $objPHPExcel->getActiveSheet()->setCellValue('AB8', 'titulo');
  $objPHPExcel->getActiveSheet()->setCellValue('AC8', 'titulo');
  $objPHPExcel->getActiveSheet()->setCellValue('AD8', 'titulo');
  $objPHPExcel->getActiveSheet()->setCellValue('AE8', 'titulo');
  $objPHPExcel->getActiveSheet()->setCellValue('AF8', 'titulo');
  $objPHPExcel->getActiveSheet()->setCellValue('AG8', 'titulo');
  $objPHPExcel->getActiveSheet()->setCellValue('AH8', 'titulo');
  $objPHPExcel->getActiveSheet()->setCellValue('AI8', 'titulo');
  $objPHPExcel->getActiveSheet()->setCellValue('AJ8', 'titulo');
  $objPHPExcel->getActiveSheet()->setCellValue('AK8', 'titulo');
  $objPHPExcel->getActiveSheet()->setCellValue('AL8', 'titulo');

    $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','V') as $columnID) {
        $objPHPExcel->getActiveSheet()->getColumnDimension($columnID)->setWidth(40);
    }

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


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

    $objPHPExcel->getActiveSheet()
                ->getStyle('B8:AL8')
                ->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 01.10.2018 в 22:02
source

0 answers