php輸出excel，在本站之前采用table的形式，以header代碼打開網(wǎng)頁(yè)為excel進(jìn)行保存，但是在header方法中生成的excel不是標(biāo)準(zhǔn)的，有的時(shí)候不能被微軟的excel識(shí)別，傳送也不好傳送。

現(xiàn)在采用<cell>的形式進(jìn)行輸出。類來(lái)源于網(wǎng)絡(luò)，做了部分解釋

class Excel_XML

{

private $header = "<?xml version=\"1.0\" encoding=\"%s\"?\>\n<Workbook xmlns=\"urn:schemas-microsoft-com:office:spreadsheet\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\" xmlns:html=\"http://www.w3.org/TR/REC-html40\">";

private $footer = "</Workbook>";

private $lines = array();

private $sEncoding;

private $bConvertTypes;

private $sWorksheetTitle;

public function __construct($sEncoding = 'UTF-8', $bConvertTypes = false, $sWorksheetTitle = 'Table1')

{

$this->bConvertTypes = $bConvertTypes;

$this->setEncoding($sEncoding);

$this->setWorksheetTitle($sWorksheetTitle);

}

public function setEncoding($sEncoding)

{

$this->sEncoding = $sEncoding;

}

public function setWorksheetTitle ($title)

{

// $title = preg_replace ("/[\\\|:|\/|\?|\*|\[|\]]/", "", $title);//如果有特殊字符則表示替換

$title = substr ($title, 0, 31);

$this->sWorksheetTitle = $title;

}

private function addRow ($array)

{

$cells = "";

foreach ($array as $k => $v):

$type = 'String';

if ($this->bConvertTypes === true && is_numeric($v)):

$type = ‘Number’;

endif;

$v = htmlentities($v, ENT_COMPAT, $this->sEncoding);

$cells .= "<Cell><Data ss:Type=\"$type\">" . $v . "</Data></Cell>\n";

endforeach;

$this->lines[] = "<Row>\n" . $cells . "</Row>\n";

}

public function addArray ($array)

{

foreach ($array as $k => $v)

$this->addRow ($v);

}

public function generateXML ($filename = 'excel-export')

{

// correct/validate filename

// $filename = preg_replace('/[^aA-zZ0-9\_\-]/', '', $filename);//這里用來(lái)替換了非字母數(shù)字為空

// deliver header (as recommended in php manual)

header("Content-Type: application/vnd.ms-excel; charset=" . $this->sEncoding);

header("Content-Disposition: inline; filename=\"" . $filename . ".xls\"");

// print out document to the browser

// need to use stripslashes for the damn ">"

echo stripslashes (sprintf($this->header, $this->sEncoding));

echo "\n<Worksheet ss:Name=\"" . $this->sWorksheetTitle . "\">\n<Table>\n";

foreach ($this->lines as $line)

echo $line;

echo "</Table>\n</Worksheet>\n";

echo $this->footer;

}

}

生成代碼：

include("excelclass.php");

$data = array(

array ('空格','','空格測(cè)試'),//第一行數(shù)據(jù)

array('Schwarz', '中文測(cè)試'),//第二行數(shù)據(jù)

array('√', '特殊字符測(cè)試')

);

$xls = new Excel_XML('UTF-8', false, 'php輸出Excel第一個(gè)sheet的名稱');

$xls->addArray($data);

$xls->generateXML('php生成Excel的名稱');

運(yùn)行試試，應(yīng)該沒有錯(cuò)，我已經(jīng)做過(guò)測(cè)試

更多信息請(qǐng)查看IT技術(shù)專欄