Exemple #1
0
$myxls->xlsWriteText(0, 0, "Nombre");
$myxls->xlsWriteText(0, 1, "Apellido");
$myxls->xlsWriteText(0, 2, "Cédula");
$myxls->xlsWriteText(0, 3, "Teléfono");
$myxls->xlsWriteText(0, 4, "Ciudad");
$myxls->xlsWriteText(0, 5, "Correo");
$myxls->xlsWriteText(0, 6, "Tipo de Usuario");
$myxls->xlsWriteText(0, 7, "Estado");
$j = 1;
$pu = mysql_query("SELECT * FROM registro WHERE boletines=1 ORDER BY nombre, apellido");
while ($vp = mysql_fetch_array($pu)) {
    $nombre = (string) $vp["nombre"];
    $myxls->xlsWriteText($j, 0, $nombre);
    $apellido = (string) $vp["apellido"];
    $myxls->xlsWriteText($j, 1, $apellido);
    $cedula = (string) $vp["cedula"];
    $myxls->xlsWriteText($j, 2, $cedula);
    $telefono = (string) $vp["telefono"];
    $myxls->xlsWriteText($j, 3, $telefono);
    $ciudad = (string) $vp["ciudad"];
    $myxls->xlsWriteText($j, 4, $ciudad);
    $correo = (string) $vp["correo"];
    $myxls->xlsWriteText($j, 5, $correo);
    $tipo_usuario = (string) cual_tipo_usuario($vp["id_tipo_usuario"]);
    $myxls->xlsWriteText($j, 6, $tipo_usuario);
    $estado = (string) cual_estado($vp["activo"]);
    $myxls->xlsWriteText($j, 7, $estado);
    $j++;
}
$myxls->xlsParse();
Exemple #2
0
function Numtest()
{
    global $fname;
    $myxls = new BiffWriter();
    $myxls->outfile = 'numtest.xls';
    $myxls->xlsWriteText(0, 0, 'Largest allowed positive number 9.99999999999999E307 verify:', 60);
    $myxls->xlsWriteText(1, 0, 'Smallest allowed negative number -9.99999999999999E307 verify:', -1);
    $myxls->xlsWriteText(2, 0, 'Smallest allowed positive number 1E-307 verify:', -1);
    $myxls->xlsWriteText(3, 0, 'Largest allowed negative number -1E-307 verify:', -1);
    $myxls->xlsWriteNumber(0, 1, 9.99999999999999E+307, 10);
    $myxls->xlsWriteNumber(1, 1, -9.99999999999999E+307);
    $myxls->xlsWriteNumber(2, 1, 9.999999999999999E-308);
    $myxls->xlsWriteNumber(3, 1, -9.999999999999999E-308);
    $myxls->xlsParse($fname);
    return;
}