<?php
require_once 'Spreadsheet/Excel/Writer.php';


$workbook = new Spreadsheet_Excel_Writer('catalog.xls');

$worksheet =& $workbook->addWorksheet('Catalog');
$worksheet->setMargins(0.25);
$worksheet->centerHorizontally(1);


$worksheet->activate();


$format_title =& $workbook->addFormat();
$format_title->setBold();
$format_title->setColor('blue');
$format_title->setSize(25);
$format_title->setAlign('merge');


$worksheet->write(0, 2, 'Catalog Spreadsheet', $format_title);

$format_header =& $workbook->addFormat();
$format_header->setBold();
$format_header->setSize(15);


$worksheet->write(1, 0, 'CATALOG ID', $format_header);
$worksheet->write(1, 1, 'JOURNAL',$format_header);
$worksheet->write(1, 2, 'SECTION',$format_header);
$worksheet->write(1, 3, 'EDITION',$format_header);
$worksheet->write(1, 4, 'TITLE',$format_header);
$worksheet->write(1, 5, 'AUTHOR',$format_header);


$format_row =& $workbook->addFormat();
$format_row->setItalic();
$format_row->setSize(12);
$format_row->setAlign('center');

$worksheet->write(2, 0, 'catalog1', $format_row);
$worksheet->write(2, 1, 'IBM developerWorks',$format_row);
$worksheet->write(2, 2, 'XML',$format_row);
$worksheet->write(2, 3, 'October 2005', $format_row);
$worksheet->write(2, 4, 'JAXP validation',$format_row);
$worksheet->writeUrl(2,4,"http://www-128.ibm.com/developerworks/java/library/x-jaxpval.html", "JAXP validation"); 
$worksheet->write(2, 5, 'Brett McLaughlin',$format_row);


$worksheet->write(3, 0, 'catalog2', $format_row);
$worksheet->write(3, 1, 'IBM developerWorks',$format_row);
$worksheet->write(3, 2, 'XML',$format_row);
$worksheet->write(3, 3, 'July 2006', $format_row);
$worksheet->write(3, 4, 'The Java XPath API',$format_row);
$worksheet->writeUrl(3,4,"http://www-128.ibm.com/developerworks/xml/library/x-javaxpathapi.html","The Java XPath API"); 
$worksheet->write(3, 5, 'Elliotte Harold',$format_row);


$workbook->close();
?>