php实现的操作excel类详解

<?phpclass Excel{  static $instance=null;  private $excel=null;  private $workbook=null;  private $workbookadd=null;  private $worksheet=null;  private $worksheetadd=null;  private $sheetnum=1;  private $cells=array();  private $fields=array();  private $maxrows;  private $maxcols;  private $filename;  //构造函数  private function Excel()  {    $this->excel = new COM("Excel.Application") or die("Did Not Connect");  }  //类入口  public static function getInstance()  {    if(null == self::$instance)    {      self::$instance = new Excel();    }    return self::$instance;  }  //设置文件地址  public function setFile($filename)  {    return $this->filename=$filename;  }  //打开文件  public function Open()  {    $this->workbook=$this->excel->WorkBooks->Open($this->filename);  }  //设置Sheet  public function setSheet($num=1)  {    if($num>0)    {      $this->sheetnum=$num;      $this->worksheet=$this->excel->WorkSheets[$this->sheetnum];      $this->maxcols=$this->maxCols();      $this->maxrows=$this->maxRows();      $this->getCells();    }  }  //取得表所有值并写进数组  private function getCells()  {    for($i=1;$i<$this->maxcols;$i++)    {      for($j=2;$j<$this->maxrows;$j++)      {        $this->cells[$this->worksheet->Cells(1,$i)->value][]=(string)$this->worksheet->Cells($j,$i)->value;      }    }    return $this->cells;  }  //返回表格内容数组  public function getAllData()  {    return $this->cells;  }  //返回制定单元格内容  public function Cell($row,$col)  {    return $this->worksheet->Cells($row,$col)->Value;  }  //取得表格字段名数组  public function getFields()  {    for($i=1;$i<$this->maxcols;$i++)    {      $this->fields[]=$this->worksheet->Cells(1,$i)->value;    }    return $this->fields;  }  //修改制定单元格内容  public function editCell($row,$col,$value)  {    if($this->workbook==null || $this->worksheet==null)    {      echo "Error:Did Not Connect!";    }else{      $this->worksheet->Cells($row,$col)->Value=$value;      $this->workbook->Save();    }  }  //修改一行数据  public function editOneRow($row,$arr)  {    if($this->workbook==null || $this->worksheet==null || $row>=2)    {      echo "Error:Did Not Connect!";    }else{      if(count($arr)==$this->maxcols-1)      {        $i=1;        foreach($arr as $val)        {          $this->worksheet->Cells($row,$i)->Value=$val;          $i++;        }        $this->workbook->Save();      }    }  }  //取得总列数  private function maxCols()  {    $i=1;    while(true)    {      if(0==$this->worksheet->Cells(1,$i))      {        return $i;        break;      }      $i++;    }  }  //取得总行数  private function maxRows()  {    $i=1;    while(true)    {      if(0==$this->worksheet->Cells($i,1))      {        return $i;        break;      }      $i++;    }  }  //读取制定行数据  public function getOneRow($row=2)  {    if($row>=2)    {      for($i=1;$i<$this->maxcols;$i++)      {        $arr[]=$this->worksheet->Cells($row,$i)->Value;      }      return $arr;    }  }  //关闭对象  public function Close()  {    $this->excel->WorkBooks->Close();    $this->excel=null;    $this->workbook=null;    $this->worksheet=null;    self::$instance=null;  }};/*$excel = new COM("Excel.Application");$workbook = $excel->WorkBooks->Open('D://Apache2//htdocs//wwwroot//MyExcel.xls');$worksheet = $excel->WorkSheets(1);echo $worksheet->Cells(2,6)->Value;$excel->WorkBooks->Close();*/$excel=Excel::getInstance();$excel->setFile("D://kaka.xls");$excel->Open();$excel->setSheet();for($i=1;$i<16;$i++ ){  $arr[]=$i;}//$excel->editOneRow(2,$arr);//print_r($excel->getAllData());    $str=$excel->getAllData();    include_once('mail.class.php');    $smtpserver="smtp.yeah.net";   $smtpserverport=25;   $smtpuseremail="yanqihu58@yeah.net";   $smtpemailto="yanqihu@139.com";   $smtpuser="yanqihu58";   $smtppwd="123456789";    $mailtype="HTML";    $smtp=new smtp($smtpserver,$smtpserverport,true,$smtpuser,$smtppwd);    $message="你好";   //$message.="首页连接地址为：".$this->link_url."<br>";   //$message.="电子邮箱为：".$this->link_email."<br>";   //$message.="商务联系QQ：".$this->link_qq."<br>";   //$message.="商务电话QQ：".$this->link_tel."<br>";   //$message.="联系人：".$this->link_people."<br>";    $smtp->debug=false;    foreach($str['email'] as $key=>$value){      $smtpemailto=$value;      @$smtp->sendmail($smtpemailto,$smtpuseremail,$mailsubject,$message,$mailtype);      exit;    }    //exit;$excel->Close();?>