ป้ายกำกับ: ดาต้า

<?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) ; /* rename sheet */
$objWorkSheet = $objPHPExcel->getActiveSheet () ;
$objWorkSheet->setTitle ('Exports Datas') ; for ($rowNo = 1; $rowNo < 10; $rowNo++) { for ($colNo = 0; $colNo < 5; $colNo++) { $insert = rand (0, 1) ; if ($insert == 1) { $colString = PHPExcel_Cell::stringFromColumnIndex ($colNo) ; $coordinate = $colString . $rowNo; $objWorkSheet->setCellValue ($coordinate, 'ส่งออกข้อมูล -> '.$coordinate) ; } }
} header ('Cache-Control: max-age=0') ;
header ('Content-Encoding: UTF-8') ;
header ('Content-Description: File Transfer') ;
header ('Content-Type: application/octet-stream') ;
header ('Content-type: text/csv; charset=UTF-8') ;
header ('Content-Disposition: attachment;filename="'.$title.'.csv"') ;
echo "\xEF\xBB\xBF"; /* UTF-8 BOM */ $objWriter = PHPExcel_IOFactory::createWriter ($objPHPExcel, 'CSV') ; /* set Delimiter, (defaults ,) */
//$objWriter->setDelimiter ('|') ;
//$objWriter->setEnclosure ('') ;
/* Set line ending (defaults PHP_EOL) */
//$objWriter->setLineEnding ('0x0d0a') ; $objWriter->save ('php://output') ;