";print_r($dataProvider);exit;
  setlocale(LC_CTYPE, 'es');

  $phpExcelPath = Yii::getPathOfAlias('ext.Excel.PHPExcel.Classes');
  $phpExcelPath2 = Yii::getPathOfAlias('application.extensions.Excel.PHPExcel.Classes.PHPExcel');
                    
  spl_autoload_unregister(array('YiiBase','autoload'));
  include($phpExcelPath . DIRECTORY_SEPARATOR . 'PHPExcel.php');
  include($phpExcelPath2 . DIRECTORY_SEPARATOR . 'IOFactory.php');
  spl_autoload_register(array('YiiBase','autoload'));

  
  $PHPExcel = new PHPExcel();

  //Ancho de las columnas
  foreach(range('A','I') as $columnID) {

    $PHPExcel->getActiveSheet()->getColumnDimension($columnID)->setAutoSize(true);
  }

  //Primera columna
  $PHPExcel->getActiveSheet()->SetCellValue('A1', 'LISTADO DE CUENTAS DE BANCO');
  $PHPExcel->getActiveSheet()->SetCellValue('A2', 'Resultados: '.count($dataProvider));

  //Estilo del header de las columnas
  $PHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
  $PHPExcel->getActiveSheet()->getStyle('A1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);    
  $PHPExcel->getActiveSheet()->getStyle('A1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
  $PHPExcel->getActiveSheet()->getStyle('A1')->getFill()->getStartColor()->setARGB('004413');

  $PHPExcel->getActiveSheet()->getStyle('A3:I3')->getFont()->setBold(true);
  $PHPExcel->getActiveSheet()->getStyle('A3:I3')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);    
  $PHPExcel->getActiveSheet()->getStyle('A3:I3')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
  $PHPExcel->getActiveSheet()->getStyle('A3:I3')->getFill()->getStartColor()->setARGB('004413');

  //Titulo de las columnas
  $PHPExcel->getActiveSheet()->SetCellValue('A3', 'Cédula');
  $PHPExcel->getActiveSheet()->SetCellValue('B3', 'Nombres');
  $PHPExcel->getActiveSheet()->SetCellValue('C3', 'Apellidos');
  $PHPExcel->getActiveSheet()->SetCellValue('D3', 'Empresa ');
  $PHPExcel->getActiveSheet()->SetCellValue('E3', 'Unidad');
  $PHPExcel->getActiveSheet()->SetCellValue('F3', 'Banco');
  $PHPExcel->getActiveSheet()->SetCellValue('G3', 'Tipo de cuenta');
  $PHPExcel->getActiveSheet()->SetCellValue('H3', 'Cuenta principal');
  $PHPExcel->getActiveSheet()->SetCellValue('I3', 'Número de cuenta');

  foreach ($dataProvider as $key => $value) {

    $PHPExcel->getActiveSheet()->getStyle("A")->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
    $PHPExcel->getActiveSheet()->SetCellValue('A'.($key+4), $value->idAsociado->cedula);
    $PHPExcel->getActiveSheet()->SetCellValue('B'.($key+4), strtoupper($value->idAsociado->nombre));
    $PHPExcel->getActiveSheet()->SetCellValue('C'.($key+4), strtoupper($value->idAsociado->apellidos) );
    $PHPExcel->getActiveSheet()->SetCellValue('D'.($key+4), strtoupper($value->idAsociado->lugartrabajo0->descripcion) );
    $PHPExcel->getActiveSheet()->SetCellValue('E'.($key+4), strtoupper($value->idAsociado->unidad->descripcion) );

    // $PHPExcel->getActiveSheet()->getStyle("F")->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
    $PHPExcel->getActiveSheet()->SetCellValue('F'.($key+4),$value->idBanco->descripcion);
    $PHPExcel->getActiveSheet()->SetCellValue('G'.($key+4), ($value->cuenta_corriente)?"Cuenta Corriente":"Cuenta de Ahorro");
    $PHPExcel->getActiveSheet()->SetCellValue('H'.($key+4), ($value->cuenta_principal)?"Si":"No");
    // $PHPExcel->getActiveSheet()->SetCellValue('I'.($key+4), strtoupper($value->cuenta_bancaria));
    $PHPExcel->getActiveSheet()->SetCellValue('I'.($key+4), strtoupper($value->cuenta_bancaria));
    $PHPExcel->getActiveSheet()->setCellValueExplicit('I'.($key+4),$value->cuenta_bancaria,  PHPExcel_Cell_DataType::TYPE_STRING);


    // $PHPExcel->getActiveSheet()->getColumnDimensionByColumn('G'.($key+4))->setAutoSize(false);
    // $PHPExcel->getActiveSheet()->getColumnDimensionByColumn('G'.($key+4))->setWidth('90');
    
  }
    

  $objWriter = new PHPExcel_Writer_Excel2007($PHPExcel);
  $objWriter->setOffice2003Compatibility(true);
  //header('Content-Type: application/vnd.ms-excel');
  //header('Content-Disposition: attachment;filename="'.$file_name.'"');
  //header('Cache-Control: max-age=0');
  $objWriter->save('php://output');
?>