+ -
当前位置:首页 → 问答吧 → 数组导出为excel求解!

数组导出为excel求解!

时间:2011-08-29

来源:互联网

用了php-excel.class.php,代码如下!
<?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号铺 ","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 "<pre>";
//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');
?>

作者: mengyao   发布时间: 2011-08-29

lz是什么问题?

作者: hzhsky1985   发布时间: 2011-08-30

LZ 什么错误? 哪里报错?

作者: wenbinglove   发布时间: 2011-08-30