哪位大虾做过? 求源码! 急!
需要输出来的格式为下
"goods_id","price","shipfee"这是字段
导出来的数据
"1","10","15"
"2","12","5"
"3","13","4"
............
可以用到的直接给100分
需要输出来的格式为下
"goods_id","price","shipfee"这是字段
导出来的数据
"1","10","15"
"2","12","5"
"3","13","4"
............
可以用到的直接给100分
不要太急……header('Content-type: application/vnd.ms-excel')用这根行不? 把数据以excel文件方式输出
$filename = "2.csv";$handle = fopen($filename, "w");$field = array("goods_id", "price", "shipfee");
$data = array(
array("1","10","15"),
array("2","12","5"),
array("3","13","4")
);//写入字段
fputcsv($handle, $field);
//写入数据
foreach($data as $k=>$v)
{
fputcsv($handle, $v);
}
fclose($handle);
?>
<?php
function escapeCSV($str){
$str = str_replace(array(',','"',"\n\r"),array('','""',''),$str);
if($str == ""){
$str = '""';
}
return $str;
}function iconvstr($str){
return iconv('utf-8','gb2312',escapeCSV($str));
}$dataforcsv = array(
array(1,'psdshow','[email protected]','2008-9-10'),
array(2,'我的姓名','[email protected]','2008-9-11')
);
$filename = date('YmdHis').'.csv';$data = "\"ID\",Username,Email,Day"."\n";foreach($dataforcsv as $r) {
$data .= $r[0].','.iconvstr($r[1]).','.iconvstr($r[2]).','.$r[3]."\n";
}header("Content-type: text/csv");
header ("Content-Disposition: attachment; filename=" . $filename);
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Expires: 0');
header('Pragma: public');
echo $data;
?>
$list = array (
'aaa,bbb,ccc,dddd',
'123,456,789',
'"aaa","bbb"'
);$fp = fopen('file.csv', 'w');foreach ($list as $line) {
fputcsv($fp, split(',', $line));
}fclose($fp);