[SOLUCIONADO] PHP y Excel en descarga

jmfmagnum · #1 (**permalink**) 22/07/2014, 11:32

Buenas tardes, disculpe las molestia tengo una consulta

Código PHP:

Ver original<?php
header("Content-type: application/vnd.ms-excel"); 
header("Content-Disposition: attachment; filename=NotificacionCasosSospechososXHosp.xls"); 
header("Pragma: no-cache"); 
?>
 
<?php require_once('pruebasesion.php'); ?>
<?php require_once('../../../Connections/brotediarreas.php'); ?>
<?php
$colname_Recordset1 = "1";
if (isset($HTTP_SESSION_VARS['usuario'])) {
  $colname_Recordset1 = (get_magic_quotes_gpc()) ? $HTTP_SESSION_VARS['usuario'] : addslashes($HTTP_SESSION_VARS['usuario']);
}
mysql_select_db($database_brotediarreas, $brotediarreas);
$query_Recordset1 = sprintf("SELECT * FROM usuarios WHERE nomusuario = '%s'", $colname_Recordset1);
$Recordset1 = mysql_query($query_Recordset1, $brotediarreas) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
 
$colname_Recordset2 = "1";
if (isset($HTTP_SESSION_VARS['usuario'])) {
  $colname_Recordset2 = (get_magic_quotes_gpc()) ? $HTTP_SESSION_VARS['usuario'] : addslashes($HTTP_SESSION_VARS['usuario']);
}
mysql_select_db($database_brotediarreas, $brotediarreas);
$query_Recordset2 = sprintf("SELECT * FROM hospnot WHERE usuario = '%s'", $colname_Recordset2);
$Recordset2 = mysql_query($query_Recordset2, $brotediarreas) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
?>
 
<!-- Visalización Base de Datos Notificación de Rotavirus Hospital--> 
<html> 
<head> 
   <title>Base de Datos Notificaci&oacute;n de casos Sospechosos Rotavirus</title> 
</head> 
<body>
<!--<table width="397" border="1" align="left" cellpadding="0" cellspacing="5" bordercolor="#FFFFFF">
  <tr align="center" bordercolor="#CCCCCC"> 
    <td width="39"> <div align="center"><img src="../../../fotos/iconos/cuad.gif" width="28" height="10"></div></td>
    <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 
        al Men&uacute;</font></a></div></td>
    <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>
  </tr>
</table> -->
<br>
<br>
<H1><font color="#333399" size="3" face="Arial Narrow"> Base de datos Notificaci&oacute;n 
  de Casos Sospechosos de Rotavirus del <?php echo $row_Recordset1['establecimiento']; ?>.</font></H1>
<font face="Arial Narrow"> </font> 
<TABLE width="914" BORDER=1 CELLPADDING=1 CELLSPACING=1>
  <TR bgcolor="#DFDFDF"> 
    <TD width="64"><font color="#333399" size="2" face="Arial Narrow">&nbsp;N&ordm; 
      MINSAL </font></TD>
    <TD width="75"><font color="#333399" size="2" face="Arial Narrow">&nbsp;Fecha 
      Digitaci&oacute;n&nbsp;</font></TD>
    <TD width="53"><font color="#333399" size="2" face="Arial Narrow">Nombres&nbsp;</font></TD>
    <TD width="61"><font color="#333399" size="2" face="Arial Narrow">&nbsp;Apellidos&nbsp;</font></TD>
    <TD width="72"><font color="#333399" size="2" face="Arial Narrow">Fecha Nacimiento</font></TD>
    <TD width="27"><font color="#333399" size="2" face="Arial Narrow">Edad</font></TD>
    <TD width="27"><font color="#333399" size="2" face="Arial Narrow">Sexo</font></TD>
    <TD width="22"><font color="#333399" size="2" face="Arial Narrow">Rut </font></TD>
    <TD width="13"><font color="#333399" size="2" face="Arial Narrow">dv</font></TD>
    <TD width="50"><font color="#333399" size="2" face="Arial Narrow">Direcci&oacute;n</font></TD>
    <TD width="69"><font color="#333399" size="2" face="Arial Narrow">Cod. Comuna</font></TD>
    <TD width="63"><font color="#333399" size="2" face="Arial Narrow">Consultorio</font></TD>
    <TD width="44"><font color="#333399" size="2" face="Arial Narrow">Hospital</font></TD>
    <TD width="51"><font color="#333399" size="2" face="Arial Narrow"> Fecha Ingreso 
      Hospital</font></TD>
    <TD width="83"><font color="#333399" size="2" face="Arial Narrow">N&ordm; 
      Ficha</font></TD>
    <TD width="1"><font color="#333399" size="2" face="Arial Narrow">Fecha Inicio 
      Diarrea</font></TD>
    <TD width="1"><font color="#333399" size="2" face="Arial Narrow">Presencia 
      de Sangre</font></TD>
    <TD width="1"><font color="#333399" size="2" face="Arial Narrow">Fecha Toma 
      Muestra </font></TD>
    <TD width="1"><font color="#333399" size="2" face="Arial Narrow">T&eacute;cnica 
      Diag. Lab.</font></TD>
    <TD width="1"><font color="#333399" size="2" face="Arial Narrow">Result. Lab.</font></TD>
    <TD width="1"><font color="#333399" size="2" face="Arial Narrow">Unidad / 
      Laboratorio</font></TD>
    <TD width="1"><font color="#333399" size="2" face="Arial Narrow">Responsable</font></TD>
    <TD width="1"><font color="#333399" size="2" face="Arial Narrow">Fecha Envio 
      Muestra </font></TD>
    <TD width="1"><font color="#333399" size="2" face="Arial Narrow">N&ordm; Registro 
      ISP </font></TD>
    <TD width="3"><font color="#333399" size="2" face="Arial Narrow">Resultado 
      ISP</font></TD>
    <TD width="3"><font color="#333399" size="2" face="Arial Narrow">Caso Cerrado</font></TD>
  </TR>
  <?php do { ?>
  <TR> 
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['ncor']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['fechadig']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['nompac']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['apellpac']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['fnac']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['edad']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['sexo']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['rut']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['dv']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['direc']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['comuna']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['consultorio']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['nomhosp']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['finghosp']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['nficha']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['finidiarr']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['psangre']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['ftomamuestra']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['tecdiaglab']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['resultado']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['unilab']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['respnom']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['respfenvmues']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['regisp']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['ispresultado']; ?></font></TD>
    <TD><font color="#0000FF" size="2" face="Arial Narrow"><?php echo $row_Recordset2['cerrado']; ?></font></TD>
  </TR>
  <?php } while ($row_Recordset2 = mysql_fetch_assoc($Recordset2)); ?>
</table> 
</body> 
</html>
<?php
mysql_free_result($Recordset1);
 
mysql_free_result($Recordset2);
?>

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

ferbux · #2 (**permalink**) 22/07/2014, 12:53

Hola,

Tal vez esto te ayude:

http://www.cristalab.com/tutoriales/...eldas-c91335l/

http://www.forosdelweb.com/f18/forma...-excel-358862/

Saludos.

jmfmagnum · #3 (**permalink**) 22/07/2014, 13:54

no entendí mucho el post, lo otro parece de números, bueno lo veré de nuevo mientras no tenga otra respuesta, gracias de todos modos, de hecho ambos trabajan números, lo que necesito es que los cuadros en si de la tabla excel salgan ordenados, ya que en el archivo descargado salen de tamaños exageradamente grande

enlinea777 · #4 (**permalink**) 22/07/2014, 14:48

asi:

Código PHP:

  <?php

header("Content-type: application/vnd.ms-excel"); 

header("Content-Disposition: attachment; filename=NotificacionCasosSospechososXHosp.xls"); 

header("Pragma: no-cache"); 

?>

 

<?php require_once('pruebasesion.php'); ?>

<?php require_once('../../../Connections/brotediarreas.php'); ?>

<?php

$colname_Recordset1 = "1";

if (isset($HTTP_SESSION_VARS['usuario'])) {

  $colname_Recordset1 = (get_magic_quotes_gpc()) ? $HTTP_SESSION_VARS['usuario'] : addslashes($HTTP_SESSION_VARS['usuario']);

}

mysql_select_db($database_brotediarreas, $brotediarreas);

$query_Recordset1 = sprintf("SELECT * FROM usuarios WHERE nomusuario = '%s'", $colname_Recordset1);

$Recordset1 = mysql_query($query_Recordset1, $brotediarreas) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

$totalRows_Recordset1 = mysql_num_rows($Recordset1);

 

$colname_Recordset2 = "1";

if (isset($HTTP_SESSION_VARS['usuario'])) {

  $colname_Recordset2 = (get_magic_quotes_gpc()) ? $HTTP_SESSION_VARS['usuario'] : addslashes($HTTP_SESSION_VARS['usuario']);

}

mysql_select_db($database_brotediarreas, $brotediarreas);

$query_Recordset2 = sprintf("SELECT * FROM hospnot WHERE usuario = '%s'", $colname_Recordset2);

$Recordset2 = mysql_query($query_Recordset2, $brotediarreas) or die(mysql_error());

$row_Recordset2 = mysql_fetch_assoc($Recordset2);

$totalRows_Recordset2 = mysql_num_rows($Recordset2);

?>

 

<!-- Visalización Base de Datos Notificación de Rotavirus Hospital--> 

<html> 

<head> 

   <title>Base de Datos Notificaci&oacute;n de casos Sospechosos Rotavirus</title> 

</head> 

<body>

 
<br>

<br>

<H1><font color="#333399" size="3" face="Arial Narrow"> Base de datos Notificaci&oacute;n 

  de Casos Sospechosos de Rotavirus del <?php echo $row_Recordset1['establecimiento']; ?>.</H1>

<font face="Arial Narrow">  

<TABLE width="914" BORDER=1 CELLPADDING=1 CELLSPACING=1>

  <TR bgcolor="#DFDFDF"> 

    <td>&nbsp;N&ordm; 

      MINSAL </TD>

    <td>&nbsp;Fecha 

      Digitaci&oacute;n&nbsp;</TD>

    <td>Nombres&nbsp;</TD>

    <td>&nbsp;Apellidos&nbsp;</TD>

    <td>Fecha Nacimiento</TD>

    <td>Edad</TD>

    <td>Sexo</TD>

    <td>Rut </TD>

    <td>dv</TD>

    <td>Direcci&oacute;n</TD>

    <td>Cod. Comuna</TD>

    <td>Consultorio</TD>

    <td>Hospital</TD>

    <td> Fecha Ingreso 

      Hospital</TD>

    <td>N&ordm; 

      Ficha</TD>

    <td>Fecha Inicio 

      Diarrea</TD>

    <td>Presencia 

      de Sangre</TD>

    <td>Fecha Toma 

      Muestra </TD>

    <td>T&eacute;cnica 

      Diag. Lab.</TD>

    <td>Result. Lab.</TD>

    <td>Unidad / 

      Laboratorio</TD>

    <td>Responsable</TD>

    <td>Fecha Envio 

      Muestra </TD>

    <td>N&ordm; Registro 

      ISP </TD>

    <td>Resultado 

      ISP</TD>

    <td>Caso Cerrado</TD>

  </TR>

  <?php do { ?>

  <TR> 

    <TD><?php echo $row_Recordset2['ncor']; ?></TD>

    <TD><?php echo $row_Recordset2['fechadig']; ?></TD>

    <TD><?php echo $row_Recordset2['nompac']; ?></TD>

    <TD><?php echo $row_Recordset2['apellpac']; ?></TD>

    <TD><?php echo $row_Recordset2['fnac']; ?></TD>

    <TD><?php echo $row_Recordset2['edad']; ?></TD>

    <TD><?php echo $row_Recordset2['sexo']; ?></TD>

    <TD><?php echo $row_Recordset2['rut']; ?></TD>

    <TD><?php echo $row_Recordset2['dv']; ?></TD>

    <TD><?php echo $row_Recordset2['direc']; ?></TD>

    <TD><?php echo $row_Recordset2['comuna']; ?></TD>

    <TD><?php echo $row_Recordset2['consultorio']; ?></TD>

    <TD><?php echo $row_Recordset2['nomhosp']; ?></TD>

    <TD><?php echo $row_Recordset2['finghosp']; ?></TD>

    <TD><?php echo $row_Recordset2['nficha']; ?></TD>

    <TD><?php echo $row_Recordset2['finidiarr']; ?></TD>

    <TD><?php echo $row_Recordset2['psangre']; ?></TD>

    <TD><?php echo $row_Recordset2['ftomamuestra']; ?></TD>

    <TD><?php echo $row_Recordset2['tecdiaglab']; ?></TD>

    <TD><?php echo $row_Recordset2['resultado']; ?></TD>

    <TD><?php echo $row_Recordset2['unilab']; ?></TD>

    <TD><?php echo $row_Recordset2['respnom']; ?></TD>

    <TD><?php echo $row_Recordset2['respfenvmues']; ?></TD>

    <TD><?php echo $row_Recordset2['regisp']; ?></TD>

    <TD><?php echo $row_Recordset2['ispresultado']; ?></TD>

    <TD><?php echo $row_Recordset2['cerrado']; ?></TD>

  </TR>

  <?php } while ($row_Recordset2 = mysql_fetch_assoc($Recordset2)); ?>

</table> 

</body> 

</html>

<?php

mysql_free_result($Recordset1);

mysql_free_result($Recordset2);

?>

jmfmagnum · #5 (**permalink**) 22/07/2014, 20:22

hiciste algun cambio?, perdon si no lo veo no soy muy perpicaz u,u

jmfmagnum · #6 (**permalink**) 23/07/2014, 06:52

no, espera ya lo vi, muchas gracias justo lo que necesitaba :D