json如何输出成excel

Question

json内容如下：
[{"ZtdID":"100000","ZtdNo":"001 ","ZtdName":"1号店 ","Address":"XX市ZZ区YY路01号铺 ","Re":"","AreaID":"01","ZtdTel":"0000-8888888","ZtdContact":"张三"},{"ZtdID":"100001","ZtdNo":"002 ","ZtdName":"1号店 ","Address":"XX市ZZ区YY路01号铺 ","Re":"","AreaID":"01","ZtdTel":"0000-8888888","ZtdContact":"李三"}]json解析并输出excel

Answer 1

先格式化成数组，然后可以用一些生成excel的类来生成，比如http://code.google.com/p/php-excel/

Answer 2

phpexcel 或者其他一些轻量级的插件 生成excel

Answer 3

先把json转回成数据，json_decode
再生成excel，把数组中的输入放入

Answer 4

<?php
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号铺 ","Re":"","AreaID":"01","ZtdTel":"0000-8888888","ZtdContact":"张三"},{"ZtdID":"100001","ZtdNo":"002 ","ZtdName":"1号店 ","Address":"XX市ZZ区YY路01号铺 ","Re":"","AreaID":"01","ZtdTel":"0000-8888888","ZtdContact":"李三"}]';
$sr = json_decode($json, true);
echo "<pre>";
//var_dump($sr);
$data = $sr;$xls = new Excel_XML('UTF-8', false, 'My Test Sheet');
$xls->addArray($data);
$xls->generateXML('my-test');
?>

Answer 5

json 转换下格式，调用NPOI的dll，生成数据流放到excel里，下载下来