phpexcel将json转excel

<?php
header ( "Content-type: text/html; charset=utf-8" );
date_default_timezone_set ( 'PRC' ); //设置中国时区
include 'PHPExcel.php';
$dir=dirname(__FILE__);





$filename = "/Users/jiangminghui/Documents/test/hao.xlsx";

$objPHPExcel = PHPExcel_IOFactory::load($filename);//加载文件

$sheet = $objPHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow(); // 取得总行数
$highestColumn = $sheet->getHighestColumn(); // 取得总列数
$city = array();
for($i=1;$i<=$highestRow;$i++) {
	$key = $objPHPExcel->getActiveSheet()->getCell("A".$i)->getValue();
	$val = $objPHPExcel->getActiveSheet()->getCell("B".$i)->getValue();
	$city[$val] = $key;
}
print_r($city);



$filename = "/Users/jiangminghui/Documents/test/json.json";
$json_string = file_get_contents($filename);
//echo print_r($json_string,true);            //打印文件的内容
//echo "<br>";

$array = json_decode($json_string,true);
if (!is_array($array)){
	die('no successful');
}

// echo "<pre>";
// print_r($array);
// echo "</pre>";

$flightsArray = $array['datas'];
// echo "<pre>";
// print_r($flightsArray);
// echo "</pre>";

$sortFlightsArray = array();
for ($i=0; $i < count($flightsArray); $i++) {
	# code...
	$tempArray = array();
	$tempArray['created'] = $flightsArray[$i]['created'];
	$tempArray['ffv'] = $flightsArray[$i]['ffv'];
	echo array_search($flightsArray[$i]['ffv'],$city);
	$tempArray['name'] = array_search($flightsArray[$i]['ffv'],$city);
	$tempArray['imp'] = $flightsArray[$i]['imp'];
	$tempArray['click'] = $flightsArray[$i]['click'];
	$tempArray['cost'] = $flightsArray[$i]['cost'];
	$sortFlightsArray[$i] = $tempArray;
}

// echo "<pre>";
// print_r($sortFlightsArray);
// echo "</pre>";

//********************************************************************************

// Create new PHPExcel object
$objPHPExcel = new PHPExcel();

// Fill worksheet from values in array
$objPHPExcel->getActiveSheet()->fromArray($sortFlightsArray, null, 'A1');

// Rename worksheet
$objPHPExcel->getActiveSheet()->setTitle('Members');

// Set AutoSize for name and email fields
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);


// Save Excel 2007 file
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save("/Users/jiangminghui/Documents/test/ad_hao20171128_20171211.xlsx");

?>