phpexcel将json转excel

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 "
";$array = json_decode($json_string,true);
if (!is_array($array)){die('no successful');
}// echo "
";
// print_r($array);
// echo "
";$flightsArray = $array['datas'];
// echo "
";
// print_r($flightsArray);
// echo "
";$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 "
";
// print_r($sortFlightsArray);
// echo "
";//********************************************************************************// 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");?>

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！