Exemplo n.º 1
0
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AK' . (string) $i, 'T-3');
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AL' . (string) $i, 'T-4');
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AM' . (string) $i, 'T-5');
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AN' . (string) $i, 'T-6');
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AO' . (string) $i, 'T-7');
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AP' . (string) $i, 'T-8');
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AQ' . (string) $i, 'T-9');
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AR' . (string) $i, 'T-10');
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AS' . (string) $i, 'VIAJE');
 $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AT' . (string) $i, 'CAPT');
 $i++;
 $estacion = "";
 $capturista = "";
 $nones = array('fill' => array('type' => PHPExcel_Style_Fill::FILL_SOLID, 'color' => array('rgb' => 'ECECEC')));
 $prog = 1;
 foreach ($client->excelEstacion($consulta, $skip, $limit) as $fila) {
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $prog);
     // progresivo
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B' . (string) $i, (string) $fila['estacion']);
     //estacion
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('C' . (string) $i, (string) $fila['km']);
     //km
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('D' . (string) $i, (string) $fila['sentido']);
     //sentido
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('E' . (string) $i, (string) $fila['anyo']);
     // anio
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('F' . (string) $i, (string) $fila['mes']);
     // mes
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('G' . (string) $i, (string) $fila['dia']);
     // dia
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('H' . (string) $i, (string) $fila['hora']);