<?php
error_reporting
(E_ALL);
ini_set
('display_errors', TRUE);
ini_set
('display_startup_errors', TRUE);
date_default_timezone_set('Europe/London');
define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
require_once
'Classes/PHPExcel.php';
$objPHPExcel
=
new
PHPExcel();
$objPHPExcel
->getProperties()->setCreator(
"Maarten Balliauw"
)
->setLastModifiedBy(
"Maarten Balliauw"
)
->setTitle(
"PHPExcel Test Document"
)
->setSubject(
"PHPExcel Test Document"
)
->setDescription(
"Test document for PHPExcel, generated using PHP classes."
)
->setKeywords(
"office PHPExcel php"
)
->setCategory(
"Test result file"
);
$objPHPExcel
->setActiveSheetIndex(0)
->setCellValue('A1', 'authorname')
->setCellValue('B1', 'countryid')
->setCellValue('C1', 'publishtime')
->setCellValue('D1', 'nodeid')
->setCellValue('E1', 'nodetitle')
->setCellValue('F1', 'deviceinfo');
$handle
= @
fopen
(
"save_countrymessage_successed.log"
,
"r"
);
if
(
$handle
) {
$h
= [];
while
((
$buffer
=
fgets
(
$handle
, 4096)) !== false) {
$pos
=
strpos
(
$buffer
,'{');
$message
[] = json_decode(
substr
(
$buffer
,
$pos
),true);
}
if
(!
feof
(
$handle
)) {
echo
"Error: unexpected fgets() fail\n"
;
}
fclose(
$handle
);
}
foreach
(
$message
AS
$key
=>
$value
){
$objPHPExcel
->setActiveSheetIndex(0)
->setCellValue('A'.(
$key
+2),
$value
['authorname'])
->setCellValue('B'.(
$key
+2),
$value
['countryid'])
->setCellValue('C'.(
$key
+2),
$value
['publishtime'])
->setCellValue('D'.(
$key
+2),
$value
['nodeid'])
->setCellValue('E'.(
$key
+2),
$value
['nodetitle'])
->setCellValue('F'.(
$key
+2),
$value
['deviceinfo']);
}
$objPHPExcel
->getActiveSheet()->setTitle('Simple');
$objPHPExcel
->setActiveSheetIndex(0);
$callStartTime
= microtime(true);
echo
$callStartTime
;
$objWriter
= PHPExcel_IOFactory::createWriter(
$objPHPExcel
, 'Excel2007');
echo
__FILE__
;
echo
str_replace
('.php', '.xlsx',
__FILE__
);
$objWriter
->save(
str_replace
('.php', '.xlsx',
__FILE__
));