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;
}
}