<?php
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
$model = new Especialidad();
$labels = $model->attributeNames();
$data = $model->findAll();
//var_dump($labels);
//var_dump($data);
$excel = Yii::app()->excel;
//Crea una instancia
$excel->getActiveSheet()->getStyle('A1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('FFFF0000');
$excel->getActiveSheet()->getStyle('A2:E2')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('0000FF00');
$excel->getActivesheet()->getStyle('A2:E2')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THICK);
$excel->getActiveSheet()->mergeCells('A1:E1');
$excel->getActiveSheet()->setCellValue('A1', 'INFORME MENSUAL');
$excel->getActiveSheet()->setCellValue('A2', $labels[0]);
$excel->getActiveSheet()->setCellValue('B2', $labels[1]);
$excel->getActiveSheet()->setCellValue('C2', 'Categoria');
$excel->getActiveSheet()->setCellValue('D2', $labels[2]);
$excel->getActiveSheet()->setCellValue('E2', $labels[5]);
$i = 3;
foreach ($data as $record) {
$excel->getActiveSheet()->setCellValue('A' . $i, $record->idEspecialidad);
$excel->getActiveSheet()->setCellValue('B' . $i, $record->nombre);
$excel->getActiveSheet()->setCellValue('C' . $i, $record["categoria"]["nombre"]);
$excel->getActiveSheet()->setCellValue('D' . $i, $record->estatus);
$excel->getActiveSheet()->setCellValue('E' . $i, $record->fecha_creacion);
