Nueva pregunta

Pregunta:

Fecha: 17-07-2018 18:11:19 (En Español)

algunos campos de phpexcel me imprime FALSO[Resuelta]

Buenas estoy creando un reporte en phpexcel de mi base de datos y algunos datos me imprime FALSO , para ver si me pueden ayudar xfa.

Los campos que imprime FALSO son: nacionalidad, provincia, distrito y corregimiento.




<?php
	//Incluimos librería y archivo de conexión
	require 'Classes/PHPExcel.php';
	require 'conexion.php';
	
	
	//Consulta
	$sql = "SELECT pe.id_persona, pe.nombres, pe.apellido, pe.cedula, pe.fecha_nac, pe.sexo, pe.nacionalidad, pe.estado_civil, pe.provincia, pe.distrito, pe.corregimiento, pe.correo, pe.telefono, pe.celular,
								    ti.year_ing_u, ti.facultad_egre, ti.sede, ti.year_ing_c, ti.carrera_egre, ti.indice, ti.turno, ti.modalidad, ti.trab_final, ti.fec_rev_credito, ti.otro_titulo, ti.universidad, ti.titulo_obt, ti.year_titulo, ti.bachiller, ti.centro_educ, ti.ingles, ti.compu, ti.cant_pc, ti.internet,
	                                so.durante_estud, so.usted_trabajo, so.trabajas, so.ocupacion, so.empresa_lab, so.actividad_emp, so.condicion, so.salario_mens, so.relacion_carre, so.tiempo_trab, so.financiado, so.intitu_financ, so.mensualidad, so.jefe_hogar, so.hijos, so.post_grado, so.especialidad
									FROM persona pe
								    INNER JOIN titulacion ti
								     ON ti.id_titulo= pe.id_persona
								    INNER JOIN socioecon so
								     ON so.id_socioecon= ti.id_titulo ";
	$resultado = $mysqli->query($sql);
	$fila = 7; //Establecemos en que fila inciara a imprimir los datos
	
	$gdImage = imagecreatefrompng('imagen/logo3.png');//Logotipo
	
	//Objeto de PHPExcel
	$objPHPExcel  = new PHPExcel();
	
	//Propiedades de Documento
	$objPHPExcel->getProperties()->setCreator("Francis Fernandez")->setDescription("Reporte de egresados");
	
	//Establecemos la pestaña activa y nombre a la pestaña
	$objPHPExcel->setActiveSheetIndex(0);
	$objPHPExcel->getActiveSheet()->setTitle("Egresados registro");
	
	$objDrawing = new PHPExcel_Worksheet_MemoryDrawing();
	$objDrawing->setName('Logotipo');
	$objDrawing->setDescription('Logotipo');
	$objDrawing->setImageResource($gdImage);
	$objDrawing->setRenderingFunction(PHPExcel_Worksheet_MemoryDrawing::RENDERING_PNG);
	$objDrawing->setMimeType(PHPExcel_Worksheet_MemoryDrawing::MIMETYPE_DEFAULT);
	$objDrawing->setHeight(100);
	$objDrawing->setCoordinates('B1');
	$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());
	
	$estiloTituloReporte = array(
    'font' => array(
	'name'      => 'Arial',
	'bold'      => true,
	'italic'    => false,
	'strike'    => false,
	'size' =>13
    ),
    'fill' => array(
	'type'  => PHPExcel_Style_Fill::FILL_SOLID
	),
    'borders' => array(
	'allborders' => array(
	'style' => PHPExcel_Style_Border::BORDER_NONE
	)
    ),
    'alignment' => array(
	'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
	'vertical' => PHPExcel_Style_Alignment::VERTICAL_CENTER
    )
	);
	
	$estiloTituloColumnas = array(
    'font' => array(
	
	
	
	'name'  => 'Arial',
	'bold'  => true,
	'size' =>10,
	'color' => array(
	'rgb' => 'FFFFFF'
	)
    ),
    'fill' => array(
	'type' => PHPExcel_Style_Fill::FILL_SOLID,
	'color' => array('rgb' => '538DD5')
    ),
    'borders' => array(
	'allborders' => array(
	'style' => PHPExcel_Style_Border::BORDER_THIN
	)
    ),
    'alignment' =>  array(
	'horizontal'=> PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
	'vertical'  => PHPExcel_Style_Alignment::VERTICAL_CENTER
    )
	);
	
	$estiloInformacion = new PHPExcel_Style();
	$estiloInformacion->applyFromArray( array(
    'font' => array(
	'name'  => 'Arial',
	'color' => array(
	'rgb' => '000000'
	)
    ),
    'fill' => array(
	'type'  => PHPExcel_Style_Fill::FILL_SOLID
	),
    'borders' => array(
	'allborders' => array(
	'style' => PHPExcel_Style_Border::BORDER_THIN
	)
    ),
	'alignment' =>  array(
	'horizontal'=> PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
	'vertical'  => PHPExcel_Style_Alignment::VERTICAL_CENTER
    )
	));
	
	$objPHPExcel->getActiveSheet()->getStyle('A1:E4')->applyFromArray($estiloTituloReporte);
	$objPHPExcel->getActiveSheet()->getStyle('A6:AY6')->applyFromArray($estiloTituloColumnas);
	
	$objPHPExcel->getActiveSheet()->setCellValue('B3', 'REPORTE DE EGRESADOS');
	$objPHPExcel->getActiveSheet()->mergeCells('B3:D3');
	
	$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(10);
	$objPHPExcel->getActiveSheet()->setCellValue('A6', 'ID');
	$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(30);
	$objPHPExcel->getActiveSheet()->setCellValue('B6', 'NOMBRE');
	$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(35);
	$objPHPExcel->getActiveSheet()->setCellValue('C6', 'APELLIDO');
	$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(15);
	$objPHPExcel->getActiveSheet()->setCellValue('D6', 'CEDULA');
	$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(25);
	$objPHPExcel->getActiveSheet()->setCellValue('E6', 'FECHA DE NAC.');
	$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(13);
	$objPHPExcel->getActiveSheet()->setCellValue('F6', 'SEXO');
	$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(25);
	$objPHPExcel->getActiveSheet()->setCellValue('G6', 'NACIONALIDAD');
	$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(18);
	$objPHPExcel->getActiveSheet()->setCellValue('H6', 'ESTADO CIVIL');
	$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(25);
	$objPHPExcel->getActiveSheet()->setCellValue('I6', 'PROVINCIA');
	$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(25);
	$objPHPExcel->getActiveSheet()->setCellValue('J6', 'DISTRITO');
	$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(25);
	$objPHPExcel->getActiveSheet()->setCellValue('K6', 'CORREGIMIENTO');
	$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(35);
	$objPHPExcel->getActiveSheet()->setCellValue('L6', 'E-MAIL');
	$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(20);
	$objPHPExcel->getActiveSheet()->setCellValue('M6', 'TELEFONO');
	$objPHPExcel->getActiveSheet()->getColumnDimension('N')->setWidth(20);
	$objPHPExcel->getActiveSheet()->setCellValue('N6', 'CELULAR');
	$objPHPExcel->getActiveSheet()->getColumnDimension('O')->setWidth(20);
	$objPHPExcel->getActiveSheet()->setCellValue('O6', 'AÑO ING. UNIV.');
	$objPHPExcel->getActiveSheet()->getColumnDimension('P')->setWidth(40);
	$objPHPExcel->getActiveSheet()->setCellValue('P6', 'FACULTAD');
	$objPHPExcel->getActiveSheet()->getColumnDimension('Q')->setWidth(30);
	$objPHPExcel->getActiveSheet()->setCellValue('Q6', 'SEDE');
	$objPHPExcel->getActiveSheet()->getColumnDimension('R')->setWidth(20);
	$objPHPExcel->getActiveSheet()->setCellValue('R6', 'AÑO ING.CARRE');
	$objPHPExcel->getActiveSheet()->getColumnDimension('S')->setWidth(50);
	$objPHPExcel->getActiveSheet()->setCellValue('S6', 'CARRERA');
	$objPHPExcel->getActiveSheet()->getColumnDimension('T')->setWidth(10);
	$objPHPExcel->getActiveSheet()->setCellValue('T6', 'INDICE');
	$objPHPExcel->getActiveSheet()->getColumnDimension('U')->setWidth(20);
	$objPHPExcel->getActiveSheet()->setCellValue('U6', 'TURNO');
	$objPHPExcel->getActiveSheet()->getColumnDimension('V')->setWidth(20);
	$objPHPExcel->getActiveSheet()->setCellValue('V6', 'MODALIDAD');
	$objPHPExcel->getActiveSheet()->getColumnDimension('W')->setWidth(30);
	$objPHPExcel->getActiveSheet()->setCellValue('W6', 'TRABAJO FINAL');
	$objPHPExcel->getActiveSheet()->getColumnDimension('X')->setWidth(20);
	$objPHPExcel->getActiveSheet()->setCellValue('X6', 'FECHA DE CRED.');
	$objPHPExcel->getActiveSheet()->getColumnDimension('Y')->setWidth(18);
	$objPHPExcel->getActiveSheet()->setCellValue('Y6', 'OTRO TITULO');
	$objPHPExcel->getActiveSheet()->getColumnDimension('Z')->setWidth(30);
	$objPHPExcel->getActiveSheet()->setCellValue('Z6', 'UNIVERSIDAD');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AA')->setWidth(26);
	$objPHPExcel->getActiveSheet()->setCellValue('AA6', 'TITULO OBTENIDO');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AB')->setWidth(15);
	$objPHPExcel->getActiveSheet()->setCellValue('AB6', 'AÑO TITULO');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AC')->setWidth(25);
	$objPHPExcel->getActiveSheet()->setCellValue('AC6', 'BACHILLER');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AD')->setWidth(20);
	$objPHPExcel->getActiveSheet()->setCellValue('AD6', 'CENTRO EDUCATIVO');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AE')->setWidth(13);
	$objPHPExcel->getActiveSheet()->setCellValue('AE6', 'INGLES');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AF')->setWidth(18);
	$objPHPExcel->getActiveSheet()->setCellValue('AF6', 'COMPUTADORA');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AG')->setWidth(13);
	$objPHPExcel->getActiveSheet()->setCellValue('AG6', 'N° COMPU.');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AH')->setWidth(13);
	$objPHPExcel->getActiveSheet()->setCellValue('AH6', 'INTERNET');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AI')->setWidth(25);
	$objPHPExcel->getActiveSheet()->setCellValue('AI6', 'DURANTE SUS EST.');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AJ')->setWidth(25);
	$objPHPExcel->getActiveSheet()->setCellValue('AJ6', 'USTED TRABAJO');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AK')->setWidth(15);
	$objPHPExcel->getActiveSheet()->setCellValue('AK6', 'TRABAJAS');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AL')->setWidth(40);
	$objPHPExcel->getActiveSheet()->setCellValue('AL6', 'OCUPACIÓN');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AM')->setWidth(30);
	$objPHPExcel->getActiveSheet()->setCellValue('AM6', 'EMPRESA LABORA');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AN')->setWidth(40);
	$objPHPExcel->getActiveSheet()->setCellValue('AN6', 'ACT. DE LA EMPRESA');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AO')->setWidth(20);
	$objPHPExcel->getActiveSheet()->setCellValue('AO6', 'CONDICIÓN');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AP')->setWidth(23);
	$objPHPExcel->getActiveSheet()->setCellValue('AP6', 'SALARIO MENSUAL');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AQ')->setWidth(20);
	$objPHPExcel->getActiveSheet()->setCellValue('AQ6', 'RELACIÓN CARRERA');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AR')->setWidth(23);
	$objPHPExcel->getActiveSheet()->setCellValue('AR6', 'TIEMPO TRABAJO');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AS')->setWidth(28);
	$objPHPExcel->getActiveSheet()->setCellValue('AS6', 'FINANCIAMIENTO');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AT')->setWidth(25);
	$objPHPExcel->getActiveSheet()->setCellValue('AT6', 'INSTITUTO FINANCIA');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AU')->setWidth(15);
	$objPHPExcel->getActiveSheet()->setCellValue('AU6', 'MENSUALIDAD');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AV')->setWidth(15);
	$objPHPExcel->getActiveSheet()->setCellValue('AV6', 'JEFE DE HOGAR');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AW')->setWidth(12);
	$objPHPExcel->getActiveSheet()->setCellValue('AW6', 'HIJOS');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AX')->setWidth(26);
	$objPHPExcel->getActiveSheet()->setCellValue('AX6', 'INTERES POST_GRADO');
	$objPHPExcel->getActiveSheet()->getColumnDimension('AY')->setWidth(33);
	$objPHPExcel->getActiveSheet()->setCellValue('AY6', 'QUE ESPECIALIDAD');
	
	//Recorremos los resultados de la consulta y los imprimimos
	while($rows = $resultado->fetch_assoc()){
		
		$objPHPExcel->getActiveSheet()->setCellValue('A'.$fila, $rows['id_persona']);
		$objPHPExcel->getActiveSheet()->setCellValue('B'.$fila, $rows['nombres']);
		$objPHPExcel->getActiveSheet()->setCellValue('C'.$fila, $rows['apellido']);
		$objPHPExcel->getActiveSheet()->setCellValue('D'.$fila, $rows['cedula']);
		$objPHPExcel->getActiveSheet()->setCellValue('E'.$fila, $rows['fecha_nac']);
		$objPHPExcel->getActiveSheet()->setCellValue('F'.$fila, $rows['sexo']);
		$objPHPExcel->getActiveSheet()->setCellValue('G'.$fila, $rows['nacionalidad']);
		$objPHPExcel->getActiveSheet()->setCellValue('H'.$fila, $rows['estado_civil']);
		$objPHPExcel->getActiveSheet()->setCellValue('I'.$fila, $rows['provincia']);
		$objPHPExcel->getActiveSheet()->setCellValue('J'.$fila, $rows['distrito']);
		$objPHPExcel->getActiveSheet()->setCellValue('K'.$fila, $rows['corregimiento']);
		$objPHPExcel->getActiveSheet()->setCellValue('L'.$fila, $rows['correo']);
		$objPHPExcel->getActiveSheet()->setCellValue('M'.$fila, $rows['telefono']);
		$objPHPExcel->getActiveSheet()->setCellValue('N'.$fila, $rows['celular']);
		$objPHPExcel->getActiveSheet()->setCellValue('O'.$fila, $rows['year_ing_u']);
		$objPHPExcel->getActiveSheet()->setCellValue('P'.$fila, $rows['facultad_egre']);
		$objPHPExcel->getActiveSheet()->setCellValue('Q'.$fila, $rows['sede']);
		$objPHPExcel->getActiveSheet()->setCellValue('R'.$fila, $rows['year_ing_c']);
		$objPHPExcel->getActiveSheet()->setCellValue('S'.$fila, $rows['carrera_egre']);
		$objPHPExcel->getActiveSheet()->setCellValue('T'.$fila, $rows['indice']);
		$objPHPExcel->getActiveSheet()->setCellValue('U'.$fila, $rows['turno']);
		$objPHPExcel->getActiveSheet()->setCellValue('V'.$fila, $rows['modalidad']);
		$objPHPExcel->getActiveSheet()->setCellValue('W'.$fila, $rows['trab_final']);
		$objPHPExcel->getActiveSheet()->setCellValue('X'.$fila, $rows['fec_rev_credito']);
		$objPHPExcel->getActiveSheet()->setCellValue('Y'.$fila, $rows['otro_titulo']);
		$objPHPExcel->getActiveSheet()->setCellValue('Z'.$fila, $rows['universidad']);
		$objPHPExcel->getActiveSheet()->setCellValue('AA'.$fila, $rows['titulo_obt']);
		$objPHPExcel->getActiveSheet()->setCellValue('AB'.$fila, $rows['year_titulo']);
		$objPHPExcel->getActiveSheet()->setCellValue('AC'.$fila, $rows['bachiller']);
		$objPHPExcel->getActiveSheet()->setCellValue('AD'.$fila, $rows['centro_educ']);
		$objPHPExcel->getActiveSheet()->setCellValue('AE'.$fila, $rows['ingles']);
		$objPHPExcel->getActiveSheet()->setCellValue('AF'.$fila, $rows['compu']);
		$objPHPExcel->getActiveSheet()->setCellValue('AG'.$fila, $rows['cant_pc']);
		$objPHPExcel->getActiveSheet()->setCellValue('AH'.$fila, $rows['internet']);
		$objPHPExcel->getActiveSheet()->setCellValue('AI'.$fila, $rows['durante_estud']);
		$objPHPExcel->getActiveSheet()->setCellValue('AJ'.$fila, $rows['usted_trabajo']);
		$objPHPExcel->getActiveSheet()->setCellValue('AK'.$fila, $rows['trabajas']);
		$objPHPExcel->getActiveSheet()->setCellValue('AL'.$fila, $rows['ocupacion']);
		$objPHPExcel->getActiveSheet()->setCellValue('AM'.$fila, $rows['empresa_lab']);
		$objPHPExcel->getActiveSheet()->setCellValue('AN'.$fila, $rows['actividad_emp']);
		$objPHPExcel->getActiveSheet()->setCellValue('AO'.$fila, $rows['condicion']);
		$objPHPExcel->getActiveSheet()->setCellValue('AP'.$fila, $rows['salario_mens']);
		$objPHPExcel->getActiveSheet()->setCellValue('AQ'.$fila, $rows['relacion_carre']);
		$objPHPExcel->getActiveSheet()->setCellValue('AR'.$fila, $rows['tiempo_trab']);
		$objPHPExcel->getActiveSheet()->setCellValue('AS'.$fila, $rows['financiado']);
		$objPHPExcel->getActiveSheet()->setCellValue('AT'.$fila, $rows['intitu_financ']);
		$objPHPExcel->getActiveSheet()->setCellValue('AU'.$fila, $rows['mensualidad']);
		$objPHPExcel->getActiveSheet()->setCellValue('AV'.$fila, $rows['jefe_hogar']);
		$objPHPExcel->getActiveSheet()->setCellValue('AW'.$fila, $rows['hijos']);
		$objPHPExcel->getActiveSheet()->setCellValue('AX'.$fila, $rows['post_grado']);
		$objPHPExcel->getActiveSheet()->setCellValue('AY'.$fila, $rows['especialidad']);
		
		$fila++; //Sumamos 1 para pasar a la siguiente fila
	}
	
	$fila = $fila-1;
	
	$objPHPExcel->getActiveSheet()->setSharedStyle($estiloInformacion, "A7:AY".$fila);
	
	$filaGrafica = $fila+2;
	
	// definir origen de los valores
	$values = new PHPExcel_Chart_DataSeriesValues('Number', 'Productos!$D$7:$D$'.$fila);
	
	// definir origen de los rotulos
	$categories = new PHPExcel_Chart_DataSeriesValues('String', 'Productos!$B$7:$B$'.$fila);
	
	// definir  gráfico
	$series = new PHPExcel_Chart_DataSeries(
	PHPExcel_Chart_DataSeries::TYPE_BARCHART, // tipo de gráfico
	PHPExcel_Chart_DataSeries::GROUPING_CLUSTERED,
	array(0),
	array(),
	array($categories), // rótulos das columnas
	array($values) // valores
	);
	$series->setPlotDirection(PHPExcel_Chart_DataSeries::DIRECTION_COL);
	
	// inicializar gráfico
	$layout = new PHPExcel_Chart_Layout();
	$plotarea = new PHPExcel_Chart_PlotArea($layout, array($series));
	
	// inicializar o gráfico
	$chart = new PHPExcel_Chart('exemplo', null, null, $plotarea);
	
	// definir título do gráfico
	$title = new PHPExcel_Chart_Title(null, $layout);
	$title->setCaption('Gráfico PHPExcel Chart Class');
	
	// definir posiciondo gráfico y título
	$chart->setTopLeftPosition('B'.$filaGrafica);
	$filaFinal = $filaGrafica + 10;
	$chart->setBottomRightPosition('E'.$filaFinal);
	$chart->setTitle($title);
	
	// adicionar o gráfico à folha
	$objPHPExcel->getActiveSheet()->addChart($chart);
	
	$writer = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
	
	// incluir gráfico
	$writer->setIncludeCharts(TRUE);
	
	header("Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
	header('Content-Disposition: attachment;filename="Regsitro de egresados.xls"');
	header('Cache-Control: max-age=0');
	
	$writer->save('php://output');
?>

Etiquetas: PHP Votos: 0 - Respuestas: 2 - Vistas: 8 Compartir en: Google Facebook Twitter LinkedIn Link
 

Respuestas:

Para participar activamente de la comunidad primero debes autenticarte, ingresa al sistema.Iniciar Sesión
 
frjcbbae garagebible.com