PHPExcel不会导出为CSV

|| 我将头撞在墙上,试图弄清楚为什么我不能让PHPExcel输出csv文件。奇怪的是,它可以在Internet Explorer中工作-它输出为csv,但在其他所有浏览器中,我都尝试将其输出为Excel拒绝打开的xls。 任何指针将不胜感激。
error_reporting(E_ALL);
$username=\"blah\";
$password=\"blahz\";
$database=\"hollatme\";
$sqlsrv=\"localhizzost\";
date_default_timezone_set(\'US/Central\');
$currenttime=date(\"m-d-Y\");

require_once \'Classes/PHPExcel.php\';
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties();


$viewinv = mysql_connect($sqlsrv,$username,$password);
if (!$viewinv) { die(\'Could not connect to SQL server. Contact administrator.\'); }
mysql_select_db($database, $viewinv) or die(\'Could not connect to database. Contact administrator.\');
$query = \"select somestuff from someplace;\";
$result = mysql_query($query);

if ($result = mysql_query($query) or die(mysql_error())) {
   $objPHPExcel = new PHPExcel();
   $objPHPExcel->getActiveSheet()->setTitle(\'CYImport\'.$currenttime.\'\');

$rowNumber = 1;
$headings = array(\'abunchof\',\'differentheadings\');
$objPHPExcel->getActiveSheet()->fromArray(array($headings),NULL,\'A\'.$rowNumber);
$rowNumber++;
while ($row = mysql_fetch_row($result)) {
   $col = \'A\';
   foreach($row as $cell) {
      $objPHPExcel->getActiveSheet()->setCellValue($col.$rowNumber,$cell);
      $col++;
   }
   $rowNumber++;
}


   $objWriter = new PHPExcel_Writer_CSV($objPHPExcel);
$objWriter->setDelimiter(\',\');
$objWriter->setEnclosure(\'\');
$objWriter->setLineEnding(\"\\r\\n\");
$objWriter->setSheetIndex(0);
$objWriter->save(\'blah \'.$currenttime.\'.csv\');


   header(\'Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet\');
   header(\'Content-Disposition: attachment;filename=\"CY Import \'.$currenttime.\'\"..csv\"\');
   header(\'Cache-Control: max-age=0\');

   $objWriter->save(\'php://output\');
   exit();
}
echo \'Contact your Administrator. No data received from server.\';
    
已邀请:
        您可以尝试将MIME类型更改为
header(\'Content-type: text/csv\');
    

要回复问题请先登录注册