Home > Backend Development > PHP Tutorial > ecshop导出excel数据

ecshop导出excel数据

WBOY
Release: 2016-06-23 13:07:54
Original
1716 people have browsed it

elseif($_REQUEST['act'] == 'exec'){    $user = exec_user();    $filename = ecs_iconv(EC_CHARSET, 'GB2312', '用户信息');    header("Content-type: application/vnd.ms-excel; charset=utf-8");    header("Content-Disposition: attachment; filename=$filename.xls");    $data="会员\t省\t市\t区\t收货地址\t分区\t线路\t业务员\t业务经理\n";    foreach($user as $item)    {        $data.="$item[user_name]\t";        $data.="$item[province]\t";        $data.="$item[city]\t";        $data.="$item[district]\t";        $data.="$item[address]\t";        $data.="$item[dist_name]\t";        $data.="$item[thread_name]\t";        $data.="$item[saleman]\t";        $data.="$item[manage]\n";    }    echo ecs_iconv(EC_CHARSET, 'GB2312', $data) . "\t";    exit;}
Copy after login

print_r($user);出来是4千多条数据;导出却200条,为什么呢,代码有问题吗,求大神赐教,谢谢


回复讨论(解决方案)

页面有无卡死?
 给php分配的内存够不够?
打开xls文件那200行数据正常吗

找到问题了,是特殊字符造成的,谢谢

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template