hasil excel

<?php
ob_start();
error_reporting(E_ALL);
require_once 'baru/Classes/PHPExcel.php';
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();

mysql_connect("localhost", "root", "root") or die(mysql_error());
mysql_select_db("pln2") or die(mysql_error());
//$TGL=$_POST[TGL];
//echo $NM=$_POST['NM'];
echo $ID_PEL=$_GET['ID_PEL'];
/*echo $NO_METER=$_POST['NO_METER'];
$TRIF_BR=$_POST['TRIF_BR'];
$DY_BR=$_POST['DY_BR'];
$GARDU=$_POST['GARDU'];
$TIANG=$_POST['TIANG'];
*/		$unik = strtotime($_GET['TGL']." 1:0:0");
		  $tanggal=date('Y-m-d', $unik);
//            $date=date('Y-m-d',strtotime($_POST['TGL']) );

$query = "SELECT a.NM, b.ID_PEL, b.NO_METER, b.DY_BR, b.GARDU, b.TIANG, b.TGL, c.C_TIM  FROM tm_plg a, td_plg b, t_tim c where a.ID_PEL=b.ID_PEL and a.C_TIM=c.C_TIM and a.STATUS_KSR=0 and b.TGL='$tanggal'";
//$query="SELECT  a.TGL, a.ID_PEL, a.NO_METER, a.DY_BR, a.GARDU, a.TIANG, b.NM FROM td_plg a, tm_plg b WHERE a.ID_PEL=b.ID_PEL and a.TGL = $tanggal";
$hasil = mysql_query($query);

// Set properties
$objPHPExcel->getProperties()->setCreator("Daud Edison Tarigan")
->setLastModifiedBy("Daud Edison Tarigan")
->setTitle("Office 2007 XLSX Test Document")
->setSubject("Office 2007 XLSX Test Document")
->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
->setKeywords("office 2007 openxml php")
->setCategory("Test result file");


 //Add some data
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A1', 'Data Pelanggan')
->setCellValue('A2', 'Nama Tim')
->setCellValue('A3', 'Tanggal')
->setCellValue('A5', 'No')
->setCellValue('B5', 'Nama')
->setCellValue('C5', 'Id Pelanggan')
->setCellValue('D5', 'Nomor Meter')
->setCellValue('E5', 'Daya')
->setCellValue('F5', 'Gardu')
->setCellValue('G5', 'Tiang');

$rowNya = 6;
$no = 0;
while($row=mysql_fetch_array($hasil)){
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue("B2", $row['C_TIM'])
->setCellValue("B3", $tanggal);
$no = $no +1;
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue("A$rowNya", $no)
->setCellValue("B$rowNya", $row['NM'])
->setCellValue("C$rowNya", $row['ID_PEL']."    " )
->setCellValue("D$rowNya", $row['NO_METER']."    ")
->setCellValue("E$rowNya", $row['DY_BR'])
->setCellValue("F$rowNya", $row['GARDU'])
->setCellValue("G$rowNya", $row['TIANG']);
$rowNya = $rowNya + 1;
}


// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle('Simple');

// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);

// Redirect output to a client’s web browser (Excel5)
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="database_plg.xls"');
header('Cache-Control: max-age=0');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
exit;
?>
<? ob_flush(); ?>