การใช้ template excel เพื่อ export รายงาน แต่กล่องข้อความ ไม่เเสดง

<?
//ideafunction.com

/** Error reporting */
error_reporting(E_ALL);

//date_default_timezone_set('Europe/London');

/** PHPExcel */
require_once 'Classes/PHPExcel.php'; 
//require_once 'Classes/PHPExcel/Reader/Excel2007.php';
//require_once 'Classes/PHPExcel/Writer/Excel2007/ContentTypes.php';
//require_once 'Classes/PHPExcel/Writer/Excel2007/Rels.php';
//require_once 'Classes/PHPExcel/Worksheet/BaseDrawing.php';
//require_once 'Classes/PHPExcel/Writer/Excel2007/Drawing.php';
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();


// Set fonts
$objPHPExcel->getActiveSheet()->getDefaultStyle()->getFont()->setName('tahoma');
$objPHPExcel->getActiveSheet()->getDefaultStyle()->getFont()->setSize(10);

// Set column widths
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(22);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(52);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);

// Set alignments
$objPHPExcel->getActiveSheet()->getStyle()->getAlignment('A')->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle()->getAlignment('B')->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getStyle()->getAlignment('C')->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_JUSTIFY);
$objPHPExcel->getActiveSheet()->getStyle()->getAlignment('D')->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);

$objPHPExcel->getProperties()->setCreator("www.ideafunction.com");
$objPHPExcel->getProperties()->setLastModifiedBy("www.ideafunction.com");
$objPHPExcel->getProperties()->setTitle("Office 2007 XLSX Test Document");
$objPHPExcel->getProperties()->setSubject("Office 2007 XLSX Test Document");
$objPHPExcel->getProperties()->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.");




$objReader = PHPExcel_IOFactory::createReader('Excel5');
$objPHPExcel = $objReader->load("Tests/templates/book.xls");
//$objPHPExcel->Application->Visible = true;  

//$objPHPExcel->setActiveSheetIndex(0)
//->setCellValue(textbox1.text,"55");
//textbox1= ActiveSheet.Offset(3,1).Value;
//Worksheets("555").Cells(0, 41).Value = textbox1;
//$objPHPExcel->getActiveSheet()->SetValue(TextBox1.Text);

//// Set document security
//$objPHPExcel->getSecurity()->setLockWindows(true);
//$objPHPExcel->getSecurity()->setLockStructure(true);
//$objPHPExcel->getSecurity()->setWorkbookPassword("PHPExcel");
//
//
//// Set sheet security
//$objPHPExcel->getActiveSheet()->getProtection()->setPassword('PHPExcel');
//$objPHPExcel->getActiveSheet()->getProtection()->setSheet(true); // This should be enabled in order to enable any of the following!
//$objPHPExcel->getActiveSheet()->getProtection()->setSort(true);
//$objPHPExcel->getActiveSheet()->getProtection()->setInsertRows(true);
//$objPHPExcel->getActiveSheet()->getProtection()->setFormatCells(true);

// 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);
		
//  Excel 2007
//$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); 
$objPHPExcel = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objPHPExcel->save('book.xls');


echo "ทดสอบการทำงาน<br/>";
echo "<a href=\"book.xls\">DownloadFile</a>"


//// redirect output to client browser
//header('Content-Type: application/vnd.ms-excel');
//header('Content-Disposition: attachment;filename="myfile.xls"');
//header('Cache-Control: max-age=0');