asi se puede crear un excel utilizano pear!!
Código PHP:
//*** Utilizando Spreadsheet/Excel/Writer.php de PEAR***//
<?php
if($_GET['open']!='ok')
{
echo'<center><p><a href="exx.php?open=ok">excel</a></p></center>';
return false;
}
elseif($_GET['open']=='ok')
{
require_once 'include/Writer.php';
$workbook = new Spreadsheet_Excel_Writer();
$titulo =& $workbook->addFormat();
$titulo->setBold();
$titulo->setAlign('merge');
$estilo =& $workbook->addFormat();
$estilo->setBold();
$estilo->setBorder(1);
$estilo->setColor(50);//color de la letra
$estilo->setFgColor(30);//fondo de la celda
$estilo->setBorderColor(30);//color del borde
$worksheet =& $workbook->addWorksheet('hoja');
$worksheet->write(0,1, "Mi archivo Excel",$titulo);
$worksheet->write(2,0, "Salidas:",$estilo);
$worksheet->write(2,1, "",$estilo);
$worksheet->write(2,2, "1",$estilo);
$worksheet->write(3,0, "valor1:",$estilo);
$worksheet->write(3,1, "",$estilo);
$worksheet->write(3,2, "2",$estilo);
$worksheet->write(4,0, "valor1:",$estilo);
$worksheet->write(4,1, "",$estilo);
$worksheet->write(4,2, "3",$estilo);
$worksheet->write(5,0, "valor1:",$estilo);
$worksheet->write(5,1, "",$estilo);
$worksheet->write(5,2, "4",$estilo);
$workbook->send('archivo.xls');
$workbook->close();
}
?>//por alvgutierr