$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']);