Beispiel #1
0
<?php

session_start();
require "../conexion.php";
include "../funciones.php";
include "biff.php";
$myxls = new BiffWriter();
$myxls->xlsSetFont('Arial', 10, FONT_NORMAL);
//FONT_BOLD
$myxls->xlsSetColWidth(0, 0, 10);
$myxls->xlsSetColWidth(1, 1, 15);
$myxls->xlsSetColWidth(2, 2, 15);
$myxls->xlsSetColWidth(3, 3, 15);
$myxls->xlsSetColWidth(4, 4, 15);
$myxls->xlsSetColWidth(5, 5, 15);
$myxls->xlsSetColWidth(6, 6, 15);
$myxls->xlsSetColWidth(7, 7, 15);
$myxls->xlsSetColWidth(8, 8, 15);
$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);
Beispiel #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;
}