01.
error_reporting
(E_ERROR);
02.
require_once
'Excel/PHPExcel.php'
;
03.
$objPHPExcel
=
new
PHPExcel();
04.
$objPHPExcel
->getActiveSheet()->getDefaultStyle()->getFont()->setName(
'EucrosiaUPC'
);
05.
$objPHPExcel
->getActiveSheet()->getDefaultStyle()->getFont()->setSize(14);
06.
$objPHPExcel
->getActiveSheet()->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE);
07.
$objPHPExcel
->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);
08.
$objPHPExcel
->getActiveSheet()->getPageSetup()->setFitToWidth(1);
09.
$objPHPExcel
->getActiveSheet()->getPageSetup()->setFitToHeight(0);
10.
$objPHPExcel
->getActiveSheet()->getPageMargins()->setTop(1);
11.
$objPHPExcel
->getActiveSheet()->getPageMargins()->setRight(0.75);
12.
$objPHPExcel
->getActiveSheet()->getPageMargins()->setLeft(0.75);
13.
$objPHPExcel
->getActiveSheet()->getPageMargins()->setBottom(1);
14.
$objPHPExcel
->getActiveSheet()->setCellValue(
'a5'
,
'ทดสอบ'
);
15.
$objPHPExcel
->getActiveSheet()->setCellValue(
'a6'
,
''
.iconv(
'UTF-8'
,
'TIS-620'
,
'ทดสอบ'
).
''
);
16.
$objPHPExcel
->getActiveSheet()->setCellValue(
'a7'
,
''
.iconv(
'TIS-620'
,
'UTF-8'
,
'ทดสอบ'
).
''
);
17.
$objPHPExcel
->getActiveSheet()->setTitle(
'ทดสอบภาษาไทย'
);
18.
$objPHPExcel
->setActiveSheetIndex(0);
19.
header(
'Content-Type: application/pdf'
);
20.
header(
'Content-Disposition: attachment;filename="'
.iconv(
'UTF-8'
,
'TIS-620'
,
'ทดสอบภาษาไทย'
).
'.pdf"'
);
21.
header(
'Cache-Control: max-age=0'
);
22.
$objWriter
= PHPExcel_IOFactory::createWriter(
$objPHPExcel
,
'PDF'
);
24.
exit
;