php輸出excel php生成excel

    php輸出excel，在本站之前采用table的形式，以header代碼打開網頁為excel進行保存，但是在header方法中生成的excel不是標準的，有的時候不能被微軟的excel識別，傳送也不好傳送。
    現(xiàn)在采用<cell>的形式進行輸出。類來源于網絡，做了部分解釋
    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);//這里用來替換了非字母數字為空
    // 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 ('空格','','空格測試'),//第一行數據
    array('Schwarz', '中文測試'),//第二行數據
    array('√', '特殊字符測試')
    );
    $xls = new Excel_XML('UTF-8', false, 'php輸出Excel第一個sheet的名稱');
    $xls->addArray($data);
    $xls->generateXML('php生成Excel的名稱');
    運行試試，應該沒有錯，我已經做過測試