php 导出excel ,同样稍微修改一下适合其他语言
下边是php到处excel的程序,主要是设置header,$content是文件的内容格式(data1,data2,data3\r\ndata4,data5,data6\r\n等等),$title是标题栏
function excel($filename, $title=array(), $content=array()) { $filename = empty($filename) ? date('Ymd') . rand(1, 100000) : $filename; $filename = iconv("utf-8", "gb2312", $filename); header("Content-Type: application/vnd.ms-excel; charset=UTF-8"); header("Pragma: public"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream"); header("Content-Type: application/download"); header("Content-Disposition: attachment;filename={$filename}.xls "); header("Content-Transfer-Encoding: binary "); if (!empty($title)) { foreach ($title as $key => $value) { echo iconv("utf-8", "gb2312", $value) . "\t"; } echo "\n"; } if (!empty($content)) { foreach ($content as $key => $value) { foreach ($value as $k => $v) { echo iconv("utf-8", "gb2312", $v) . "\t"; } echo "\n"; } return true; } }