} } $j += $row['items']; } $objPHPExcel->getActiveSheet()->getStyle(c2(1, $j, 1, 2))->applyFromArray($border_style); $objPHPExcel->setActiveSheetIndex(0)->getStyle(c2(1, $j, 1, 2))->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('FFFFBF00'); } $i = 3; if ($ou['body'] != null) { foreach ($ou['body'] as $row) { $j = 1; foreach ($row as $name => $value) { if (strpos($name, '_correo') !== false && $value == '') { $value = '*****@*****.**'; } $objPHPExcel->setActiveSheetIndex(0)->setCellValue(getNameFromNumber($j) . '' . $i, $venta->getDeclarativo_value($value, $ou['info'][$name])); $j++; } $objPHPExcel->getActiveSheet()->getStyle(c2(1, $j, $i, $i))->applyFromArray($border_style); $i++; } } // -------------------------------------------------------- TEST // Utilidades::printr($in); // Utilidades::printr($_SESSION); // Utilidades::printr($campos); // Utilidades::printr($ou); // -------------------------------------------------------- OUT $objPHPExcel->getActiveSheet()->setTitle('Data'); $objPHPExcel->setActiveSheetIndex(0); header('Content-Type: application/vnd.ms-excel');