<?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);