ป้ายกำกับ: หน้า

<?php
 
/* PHPExcel_IOFactory - Reader */
include 'PHPOffice/PHPExcel/Classes/PHPExcel.php';
 
$objPHPExcel = new PHPExcel () ;
 
/* Set default style */
$defaultStyle = $objPHPExcel->getDefaultStyle () ;
 
$defaultStyle->getFont () ->setName ('Arial') ->setSize (11) ;
 
$defaultStyle->getNumberFormat () ->setFormatCode ('yyyy-mm-dd') ;
 
/* Set document properties */
$title = 'Exports_Datas_' . date ('Y-m-d_H:i') ;
$objPHPExcel->getProperties () ->setCreator ('Pitt Phunsanit') ->setCategory ('Exports Datas') ->setDescription ($title) ->setKeywords ('Exports Datas ' . date ('Y-m-d')) ->setSubject ($title) ->setTitle ($title) ;
 
/* multiple_sheets */
for ($sheetNo = 0; $sheetNo < 10; $sheetNo++) {
 $objWorkSheet = $objPHPExcel->createSheet ($sheetNo) ;
 $objWorkSheet->setTitle ('Sheet Nane '.$sheetNo) ;
 $objWorkSheet->setCellValue ('A1', 'Add data for sheet no. '.$sheetNo) ;
}
 
/* set active sheet */
$objPHPExcel->setActiveSheetIndex (5) ;
$objWorkSheet = $objPHPExcel->getActiveSheet () ;
$objWorkSheet->setCellValue ('A4', 'Add data for sheet no. 5 after Sheet Nane '.$sheetNo) ;
 
$objWriter =PHPExcel_IOFactory::createWriter ($objPHPExcel, 'Excel2007') ;
header ('Content-Type: application/vnd.ms-excel') ;
header ('Content-Disposition: attachment;filename="' . $title . '.xlsx"') ;
header ('Cache-Control: max-age=0') ;
header ('Cache-Control: no-store, no-cache, must-revalidate, max-age=0') ;
header ('Cache-Control: post-check=0, pre-check=0', false) ;
header ('Pragma: no-cache') ;
$objWriter->save ('php://output') ;

$objWorkSheet = $objPHPExcel->getActiveSheet () ;
$objWorkSheet->setTitle ('Exports Datas') ;