//获取数据
header('Content-Disposition: attachment; filename=排行统计.xls');
header('Pragma: no-cache');
{
echo iconv('utf-8', 'gbk', implode("\t", $value)), "\n";
$list=Ativity::getTw_statisticExecl($activity_id,$status);
// execl导出
header('Content-Type: application/vnd.ms-excel');header('Content-Disposition: attachment; filename=排行统计.xls');
header('Pragma: no-cache');
header('Expires: 0');
//输出表头
$title = array('编号', '姓名', '电话', '得票数', '排行', '状态');echo iconv('utf-8', 'gbk', implode("\t", $title)), "\n";
//输出内容
foreach ($list as $key => $value){
echo iconv('utf-8', 'gbk', implode("\t", $value)), "\n";
}
编号 | 姓名 | 电话 | 得票数 | 排行 | 状态 |
85 | 买路 | 15116330000 | 31 | 1 | 1 |
86 | 测试大爷 | 15116330006 | 14 | 2 | 1 |
87 | 英文不行 | 14789517896 | 7 | 3 | 1 |
103 | 河口 | 15116330090 | 6 | 4 | 1 |
89 | 勒个去 | 14789510917 | 4 | 5 | 1 |
88 | 小爷 | 15116330001 | 3 | 6 | 1 |
92 | 蛮低37 | 15916978137 | 3 | 7 | 1 |
93 | 蛮低36 | 15916978136 | 3 | 8 | 1 |
91 | 蛮低39 | 15916978139 | 2 | 9 | 0 |
102 | 破了 | 14789510917 | 2 | 10 | 0 |
94 | 蛮低31 | 15916978131 | 1 | 11 | 0 |
95 | 蛮低28 | 15916978128 | 1 | 12 | 0 |
96 | 蛮低14 | 15916978114 | 1 | 13 | 0 |
97 | 蛮低12 | 15916978112 | 1 | 14 | 0 |
98 | 蛮低40 | 15916978140 | 1 | 15 | 0 |
99 | 蛮低38 | 15916978138 | 1 | 16 | 0 |
100 | 蛮低35 | 15916978135 | 1 | 17 | 0 |
101 | 蛮低33 | 15916978133 | 1 | 18 | 0 |
104 | 蛮低32 | 15916978132 | 1 | 19 | 0 |