我用的是php-excel.class.php这个开源类,当然里面你还可改一些excel样式,
如果在IE下无法打开或者保存导出的excel的话,请加上这一句;
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/vnd.ms-excel; charset=”.$this->sEncoding.”");
header(“Content-Transfer-Encoding: binary”);
此方法可以解决php-excel.class.php在IE下导出时出现的错误!