Tema: PHP y Excel en descarga
Ver Mensaje Individual
  #1 (permalink)  
Antiguo 22/07/2014, 11:32
jmfmagnum
 
Fecha de Ingreso: julio-2014
Mensajes: 116
Antigüedad: 9 años, 9 meses
Puntos: 1
PHP y Excel en descarga
Buenas tardes, disculpe las molestia tengo una consulta

Código PHP: 
Ver original
  1. <?php
  2. header("Content-type: application/vnd.ms-excel"); 
  3. header("Content-Disposition: attachment; filename=NotificacionCasosSospechososXHosp.xls"); 
  4. header("Pragma: no-cache"); 
  5. ?>
  6.  
  7. <?php require_once('pruebasesion.php'); ?>
  8. <?php require_once('../../../Connections/brotediarreas.php'); ?>
  9. <?php
  10. $colname_Recordset1 = "1";
  11. if (isset($HTTP_SESSION_VARS['usuario'])) {
  12.   $colname_Recordset1 = (get_magic_quotes_gpc()) ? $HTTP_SESSION_VARS['usuario'] : addslashes($HTTP_SESSION_VARS['usuario']);
  13. }
  14. mysql_select_db($database_brotediarreas, $brotediarreas);
  15. $query_Recordset1 = sprintf("SELECT * FROM usuarios WHERE nomusuario = '%s'", $colname_Recordset1);
  16. $Recordset1 = mysql_query($query_Recordset1, $brotediarreas) or die(mysql_error());
  17. $row_Recordset1 = mysql_fetch_assoc($Recordset1);
  18. $totalRows_Recordset1 = mysql_num_rows($Recordset1);
  19.  
  20. $colname_Recordset2 = "1";
  21. if (isset($HTTP_SESSION_VARS['usuario'])) {
  22.   $colname_Recordset2 = (get_magic_quotes_gpc()) ? $HTTP_SESSION_VARS['usuario'] : addslashes($HTTP_SESSION_VARS['usuario']);
  23. }
  24. mysql_select_db($database_brotediarreas, $brotediarreas);
  25. $query_Recordset2 = sprintf("SELECT * FROM hospnot WHERE usuario = '%s'", $colname_Recordset2);
  26. $Recordset2 = mysql_query($query_Recordset2, $brotediarreas) or die(mysql_error());
  27. $row_Recordset2 = mysql_fetch_assoc($Recordset2);
  28. $totalRows_Recordset2 = mysql_num_rows($Recordset2);
  29. ?>
  30.  
  31. <!-- Visalización Base de Datos Notificación de Rotavirus Hospital--> 
  32. <html> 
  33. <head> 
  34.    <title>Base de Datos Notificaci&oacute;n de casos Sospechosos Rotavirus</title> 
  35. </head> 
  36. <body>
  37. <!--<table width="397" border="1" align="left" cellpadding="0" cellspacing="5" bordercolor="#FFFFFF">
  38.   <tr align="center" bordercolor="#CCCCCC"> 
  39.     <td width="39"> <div align="center"><img src="../../../fotos/iconos/cuad.gif" width="28" height="10"></div></td>
  40.     <td width="152"> <div align="center"><a href="acceso3.php" target="_self" onMouseOver="window.status='Haga Click aqui!';return true" onMouseOut="window.status='';return true"><font color="#CC9900" size="3" face="Arial Narrow">Volver 
  41.         al Men&uacute;</font></a></div></td>
  42.     <td width="152"> <div align="center"><a href="cerrarsesion.php" target="_self" onMouseOver="window.status='Haga Click aqui!';return true" onMouseOut="window.status='';return true"><font color="#CC9900" size="3" face="Arial Narrow">Salir</font></a></div></td>
  43.   </tr>
  44. </table> -->
  45. <br>
  46. <br>
  47. <H1><font color="#333399" size="3" face="Arial Narrow"> Base de datos Notificaci&oacute;n 
  48.   de Casos Sospechosos de Rotavirus del <?php echo $row_Recordset1['establecimiento']; ?>.</font></H1>
  49. <font face="Arial Narrow"> </font> 
  50. <TABLE width="914" BORDER=1 CELLPADDING=1 CELLSPACING=1>
  51.   <TR bgcolor="#DFDFDF"> 
  52.     <TD width="64"><font color="#333399" size="2" face="Arial Narrow">&nbsp;N&ordm; 
  53.       MINSAL </font></TD>
  54.     <TD width="75"><font color="#333399" size="2" face="Arial Narrow">&nbsp;Fecha 
  55.       Digitaci&oacute;n&nbsp;</font></TD>
  56.     <TD width="53"><font color="#333399" size="2" face="Arial Narrow">Nombres&nbsp;</font></TD>
  57.     <TD width="61"><font color="#333399" size="2" face="Arial Narrow">&nbsp;Apellidos&nbsp;</font></TD>
  58.     <TD width="72"><font color="#333399" size="2" face="Arial Narrow">Fecha Nacimiento</font></TD>
  59.     <TD width="27"><font color="#333399" size="2" face="Arial Narrow">Edad</font></TD>
  60.     <TD width="27"><font color="#333399" size="2" face="Arial Narrow">Sexo</font></TD>
  61.     <TD width="22"><font color="#333399" size="2" face="Arial Narrow">Rut </font></TD>
  62.     <TD width="13"><font color="#333399" size="2" face="Arial Narrow">dv</font></TD>
  63.     <TD width="50"><font color="#333399" size="2" face="Arial Narrow">Direcci&oacute;n</font></TD>
  64.     <TD width="69"><font color="#333399" size="2" face="Arial Narrow">Cod. Comuna</font></TD>
  65.     <TD width="63"><font color="#333399" size="2" face="Arial Narrow">Consultorio</font></TD>
  66.     <TD width="44"><font color="#333399" size="2" face="Arial Narrow">Hospital</font></TD>
  67.     <TD width="51"><font color="#333399" size="2" face="Arial Narrow"> Fecha Ingreso 
  68.       Hospital</font></TD>
  69.     <TD width="83"><font color="#333399" size="2" face="Arial Narrow">N&ordm; 
  70.       Ficha</font></TD>
  71.     <TD width="1"><font color="#333399" size="2" face="Arial Narrow">Fecha Inicio 
  72.       Diarrea</font></TD>
  73.     <TD width="1"><font color="#333399" size="2" face="Arial Narrow">Presencia 
  74.       de Sangre</font></TD>
  75.     <TD width="1"><font color="#333399" size="2" face="Arial Narrow">Fecha Toma 
  76.       Muestra </font></TD>
  77.     <TD width="1"><font color="#333399" size="2" face="Arial Narrow">T&eacute;cnica 
  78.       Diag. Lab.</font></TD>
  79.     <TD width="1"><font color="#333399" size="2" face="Arial Narrow">Result. Lab.</font></TD>
  80.     <TD width="1"><font color="#333399" size="2" face="Arial Narrow">Unidad / 
  81.       Laboratorio</font></TD>
  82.     <TD width="1"><font color="#333399" size="2" face="Arial Narrow">Responsable</font></TD>
  83.     <TD width="1"><font color="#333399" size="2" face="Arial Narrow">Fecha Envio 
  84.       Muestra </font></TD>
  85.     <TD width="1"><font color="#333399" size="2" face="Arial Narrow">N&ordm; Registro 
  86.       ISP </font></TD>
  87.     <TD width="3"><font color="#333399" size="2" face="Arial Narrow">Resultado 
  88.       ISP</font></TD>
  89.     <TD width="3"><font color="#333399" size="2" face="Arial Narrow">Caso Cerrado</font></TD>
  90.   </TR>
  91.   <?php do { ?>
  92.   <TR> 
  93.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['ncor']; ?></font></TD>
  94.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['fechadig']; ?></font></TD>
  95.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['nompac']; ?></font></TD>
  96.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['apellpac']; ?></font></TD>
  97.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['fnac']; ?></font></TD>
  98.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['edad']; ?></font></TD>
  99.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['sexo']; ?></font></TD>
  100.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['rut']; ?></font></TD>
  101.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['dv']; ?></font></TD>
  102.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['direc']; ?></font></TD>
  103.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['comuna']; ?></font></TD>
  104.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['consultorio']; ?></font></TD>
  105.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['nomhosp']; ?></font></TD>
  106.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['finghosp']; ?></font></TD>
  107.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['nficha']; ?></font></TD>
  108.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['finidiarr']; ?></font></TD>
  109.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['psangre']; ?></font></TD>
  110.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['ftomamuestra']; ?></font></TD>
  111.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['tecdiaglab']; ?></font></TD>
  112.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['resultado']; ?></font></TD>
  113.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['unilab']; ?></font></TD>
  114.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['respnom']; ?></font></TD>
  115.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['respfenvmues']; ?></font></TD>
  116.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['regisp']; ?></font></TD>
  117.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['ispresultado']; ?></font></TD>
  118.     <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['cerrado']; ?></font></TD>
  119.   </TR>
  120.   <?php } while ($row_Recordset2 = mysql_fetch_assoc($Recordset2)); ?>
  121. </table> 
  122. </body> 
  123. </html>
  124. <?php
  125. mysql_free_result($Recordset1);
  126.  
  127. mysql_free_result($Recordset2);
  128. ?>


asi logro descargar todos los datos que se muestra en un archivo excel, pero el archivo sale con los cuadros grandes y algunos super estrechados, hay una manera de que el archivo salga con los cuadros en un tamaño mediano?, y si ya conozco phpexcel, pero no pude usarlo , era demasiado complicado aplicarlo a este codigo