$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();
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; }