php 下载excel文件，单独设置工作表(sheet1,sheet2,sheet3....)

一直以来下载excel文件，都是简单使用修改header头的方式进行下载，好处自然是简单直接，缺点是，只能使用一个工作表，即一个sheet。

下面提供一个可生成多个工作表excel文件的code。

<?php
namespace worksheet;
class WorkSheet
{
    private $lines = array();
    public $sWorksheetTitle;
    public function __construct($sWorksheetTitle)
    {
        $this->setWorksheetTitle($sWorksheetTitle);
    }
    public function setWorksheetTitle ($title)
    {
        $title = preg_replace ("/[\\\¦:¦\/¦\?¦\*¦\[¦\]]/", "", $title);
        $title = substr ($title, 0, 31);
        $this->sWorksheetTitle = $title;
    }
    public function addRow ($array)
    {
        foreach($array as $v){
            $cells = "";
            foreach ($v as $k => $v1){
                $type = 'String';
                $v1 = htmlentities($v1, ENT_COMPAT, "UTF-8");
                $cells .= "<Cell><D