json如何輸出成excel

json內容如下：
[{"ZtdID":"100000","ZtdNo":"001 ","ZtdName":"1號店 ","Address":"XX市ZZ區YY路01號鋪 ","Remark":"","AreaID":"01","ZtdTel":"0000-8888888","ZtdContact":"張三"},{"ZtdID":"100001","ZtdNo":"002 ","ZtdName":"1號店 ","Address":"XX市ZZ區YY路01號鋪 ","Remark":"","AreaID":"01","ZtdTel":"0000-8888888","ZtdContact":"李三"}]

json解析並輸出excel

回複討論(解決方案)

先格式化成數組，然後可以用一些產生excel的類來產生，比如 http://code.google.com/p/php-excel/

phpexcel 或者其他一些輕量級的外掛程式 產生excel

先把json轉回成資料，json_decode
再產生excel，把數組中的輸入放入

先格式化成數組，然後可以用一些產生excel的類來產生，比如http://code.google.com/p/php-excel/

header("Content-type: text/html; charset=utf-8");
require 'php-excel.class.php';
$json='[{"ZtdID":"100000","ZtdNo":"001 ","ZtdName":"1號店 ","Address":"XX市ZZ區YY路01號鋪 ","Remark":"","AreaID":"01","ZtdTel":"0000-8888888","ZtdContact":"張三"},{"ZtdID":"100001","ZtdNo":"002 ","ZtdName":"1號店 ","Address":"XX市ZZ區YY路01號鋪 ","Remark":"","AreaID":"01","ZtdTel":"0000-8888888","ZtdContact":"李三"}]';
$sr = json_decode($json, true);
echo "

";  
 //var_dump($sr);  
 $data = $sr;  
  
 $xls = new Excel_XML('UTF-8', false, 'My Test Sheet');  
 $xls->addArray($data);  
 $xls->generateXML('my-test');  
 ?> 
 
  to 1樓，出來成一行了？ 
 
   header("Content-type: text/html; charset=utf-8");  
 require 'php-excel.class.php';  
 $json='[{"ZtdID":"100000","ZtdNo":"001 ","ZtdName":"1號店 ","Address":"XX市ZZ區YY路01號鋪 ","Remark":"","AreaID":"01","ZtdTel":"0000-8888888","ZtdContact":"張三"},{"ZtdID":"100001","ZtdNo":"002 ","ZtdName":"1號店 ","Address":"XX市ZZ區YY路01號鋪 ","Remark":"","AreaID":"01","ZtdTel":"0000-8888888","ZtdContact":"李三"}]';  
 $sr = json_decode($json, true);  
 echo "
";  
 //var_dump($sr);  
  
 $headeAarray = array();  
 $headeAarray[] = array('店鋪ID', '店鋪編號', '店鋪名稱', '地址', '標記','地區ID','聯絡電話','連絡人');  //表頭二維數組  
 $dataArray = array();  
 while($row = ($sr)) {  
  $dataArray[] = array($row['ZtdID'], $row['ZtdNo'], $row['ZtdName'], $row['Address'], $row['Remark'],$row['AreaID'],$row['ZtdTel'],$row['ZtdContact']);    
 }  
 $xls = new Excel_XML('UTF-8', false, 'My Test Sheet');  
 $xls->addArray($headeAarray);   
 $xls->addArray($dataArray);  
 $xls->generateXML('my-test');  
 ?>  
  
 這樣還不行，有同學指導一下嗎？  
 
 
  json 轉換下格式，調用NPOI的dll，產生資料流放到excel裡，下載下來
