<?php // Author : Emanuel Setio Dewo // Email : setio.dewo@gmail.com // Start : 18 Sept 2008 session_start(); include_once "../dwo.lib.php"; include_once "../db.mysql.php"; include_once "../connectdb.php"; include_once "../parameter.php"; include_once "../cekparam.php"; // *** Parameters *** $TahunID = sqling($_REQUEST['TahunID']); $ProdiID = sqling($_REQUEST['ProdiID']); // *** Main *** ExportXL($TahunID, $ProdiID); include_once "../disconnectdb.php"; // *** Functions *** function ExportXL($TahunID, $ProdiID) { include_once "Spreadsheet/Excel/Writer.php"; $xls =& new Spreadsheet_Excel_Writer(); $xls->send("nilai-{$TahunID}-{$ProdiID}-{$_SESSION['_Login']}.xls"); $sheet =& $xls->addWorksheet("{$TahunID}-{$ProdiID}"); $sheet->hideGridlines(); $sheet->hideScreenGridlines(); $bold =& $xls->addFormat(); $bold->setAlign('center'); $bold->setBold(); $bold->setSize(11); $bold->setTop(1);
<?php // Author : Emanuel Setio Dewo // Email : setio.dewo@gmail.com // Start : 08/12/2008 session_start(); include_once "../dwo.lib.php"; include_once "../db.mysql.php"; include_once "../connectdb.php"; include_once "../parameter.php"; include_once "../cekparam.php"; // *** Main *** ExportXL(); // *** Functions *** function ExportXL() { include_once "Spreadsheet/Excel/Writer.php"; $xls =& new Spreadsheet_Excel_Writer(); $xls->send("nilai-{$TahunID}-{$ProdiID}-{$_SESSION['_Login']}.xls"); $sheet =& $xls->addWorksheet("{$TahunID}-{$ProdiID}"); $sheet->hideGridlines(); $sheet->hideScreenGridlines(); $bold =& $xls->addFormat(); $bold->setAlign('center'); $bold->setBold(); $bold->setSize(11); $bold->setTop(1); $bold->setBottom(1); $bold->setRight(1); $bold->setLeft(1); $bold1 =& $xls->addFormat();