php导出excel 条件,PHP 导出excel

注意

1.导出文件乱码 需要注意数据库数据字段字符编码和文件字符编码是否一致【不一致需要使用iconv函数变化字符串】

浏览器导出实例

$fileName = date('Y-m-d').'_del.csv'; //文件名

set_time_limit(0);

ini_set('memory_limit', '1024M');

header('Content-Type: application/vnd.ms-excel'); //输出文件类型

header('Content-Disposition: attachment;filename="'.$fileName.'"'); //输出文件名

header('Cache-Control: max-age=0'); //强制每次请求直接发送给源服务器，而不经过本地缓存版本的校验

// 设置标题

$title = ["t1", "t2","t3", "t4","t5","6者", "t7","t8","t9","t10"];

$fp = fopen('php://output', 'a');

fputcsv($fp, $title);

foreach($list as $k=>$v){

if($k/300 == 0){

ob_flush();

flush();

}

$str_arr = array();

$str_arr[] = $v['1'];

$str_arr[] = $v['2'];

$str_arr[] = $v['3'];

$str_arr[] = $v['4'];

$str_arr[] = $sourceList[$v['5']];

$str_arr[] = $zmtUMap[$v['6']];

$str_arr[] = $v['7'];

$str_arr[] = $v['8'];

$str_arr[] = $feedChgReason[$v['9']];

$str_arr[] = date('Y-m-d H:i',$v['10']);

fputcsv($fp, $str_arr);

}

fclose($fp);

服务器脚本导出实例

$fileName = date('Y-m-d').'_del.csv'; //文件名

$baseName = '/exportDir/'; //绝对路径写法 根据自身情况选择

//$baseName = 'exportDir/'; //相对路径写法 根据自身情况选择

$filePath = $baseName . $fileName;

set_time_limit(0);

ini_set('memory_limit', '1024M');

// 设置标题

$title = ["t1", "t2","t3", "t4","t5","6者", "t7","t8","t9","t10"];

$fp = fopen($filePath, 'a');

fputcsv($fp, $title);

foreach($list as $k=>$v){

if($k/300 == 0){

ob_flush();

flush();

}

$str_arr = array();

$str_arr[] = $v['1'];

$str_arr[] = $v['2'];

$str_arr[] = $v['3'];

$str_arr[] = $v['4'];

$str_arr[] = $sourceList[$v['5']];

$str_arr[] = $zmtUMap[$v['6']];

$str_arr[] = $v['7'];

$str_arr[] = $v['8'];

$str_arr[] = $feedChgReason[$v['9']];

$str_arr[] = date('Y-m-d H:i',$v['10']);

fputcsv($fp, $str_arr);

}

fclose($fp);