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); $apellido = (string) $vp["apellido"]; $myxls->xlsWriteText($j, 1, $apellido); $cedula = (string) $vp["cedula"];
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; }