<?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);
function Demo()
{
global $fname;
$myxls = new BiffWriter();
// file name suggested to the browser (stream)
$myxls->outfile = 'demo.xls';
// create 4 default fonts
$myxls->xlsSetFont('Arial', 10, FONT_NORMAL);
$myxls->xlsSetFont('Arial', 10, FONT_BOLD);
$myxls->xlsSetFont('Courier New', 8, FONT_NORMAL);
$myxls->xlsSetFont('Courier New', 8, FONT_BOLD);
// set default row height to 14 points
$myxls->xlsSetDefRowHeight(14);
// turn backup flag on (xlk)
$myxls->xlsSetBackup();
// print grid lines
$myxls->xlsSetPrintGridLines();
// print row (1,2...) and col (A, B..) references
$myxls->xlsSetPrintHeaders();
// protect the sheet against changes, pw = ABCD
// all EMPTY cells AND cells having the status CELL_LOCKED are protected
$myxls->xlsProtectSheet('ABCD', TRUE);
// print header
$myxls->xlsHeader('&12BiffWriter Demo (c) C. Novak - cnovak@gmx.net');
// print footer
$myxls->xlsFooter('&L&12Page &P of &N &C&D &T &R&F/&A');
// print margin in inches
$myxls->xlsPrintMargins(1, 1, 1, 1);
// set a page break after row 2
$myxls->xlsAddHPageBreak(2);
// set a page break before column C
$myxls->xlsAddVPageBreak('C');
// create some content
$myxls->xlsWriteText('A1', 0, 'BiffWriter Demo (c) C. Novak - cnovak@gmx.net', -1, 0, FONT_1, CELL_BOTTOM_BORDER, CELL_LOCKED);
$myxls->xlsCellNote('A1', 0, 'This cell is protected with CELL_LOCKED. Notes can contain up to 2048 characters currently');
$myxls->xlsWriteText('A2', 0, 'Biff 2.1 allows for up to 4 fonts having different attributes:', -1);
$myxls->xlsWriteText('A3', 0, 'Arial', 0, 0, FONT_0, ALIGN_RIGHT);
$myxls->xlsWriteText('A4', 0, 'Arial bold', 0, 0, FONT_1, ALIGN_RIGHT);
$myxls->xlsWriteText('A5', 0, 'Courier', 0, 0, FONT_2, ALIGN_RIGHT);
$myxls->xlsWriteText('A6', 0, 'Courier bold', 0, 0, FONT_3, ALIGN_RIGHT);
$myxls->xlsWriteText('A7', 0, 'BIFF 2.1 comes with 21 predefined formats, custom formats can be added:', -1);
$myxls->xlsCellNote('A7', 0, 'The cells below are set to "autowidth" and determine the width of column A');
// add a user defined picture (format)
$idx_fmt = $myxls->xlsAddFormat('[Blue] 0 "US$"');
// print all defined picture strings using 33333.3333
for ($x = 0; $x < count($myxls->picture); $x++) {
$myxls->xlsWriteText($x + 7, 0, 'Format id ' . strval($x), 0, 0, FONT_2);
$myxls->xlsWriteNumber($x + 7, 1, 33333.3333, 20, $x, FONT_2);
if (empty($myxls->picture[$x])) {
$myxls->xlsWriteText($x + 7, 2, 'predefined', 0, 0, FONT_2);
} else {
$myxls->xlsWriteText($x + 7, 2, 'custom ' . $myxls->picture[$x], 0, 0, FONT_3, CELL_BOX_BORDER);
}
}
// assemble the stream
// and either send the stream to the browser or
// save it as a file in the location/filename passed via $fname
$myxls->xlsParse($fname);
return;
}
