php 生成excel
<?php$data = array();
$data[] =array('14444444','dddd');
$data[] =array('1555','dddd');
$column_name = array('手机号','用户ID');
//导出文件名称
$name = "_data_".date('Y-m-d');
Header("Content-type: application/octet-stream");
Header("Content-Disposition: attachment; filename=" . $name. ".csv");
Header("Pragma:public");
//输出文件第一行字段描述信息
//ksort($column_name);
echo join(',', $column_name);
echo "\r\n";
foreach ($data as $v)
{
//ksort($v);
$v = str_replace(',', ' ', $v);
echo str_replace(array(
"\r\n",
"\r",
"\n"
), '', join(',', $v));
echo "\r\n";
}
exit();
?>
页:
[1]