无聊写这玩的,喜欢扩展的朋友别忘了发我一份哦,哈哈 谢谢,
ps:测试没什么效率的说,哈哈~~~
guyudj@yahoo.com.cn复制PHP内容到剪贴板 PHP代码:
<?php
/** *基 于 COM 的 Excel 操作类(PHP5.x) *PHPer:T.T.R *Date:[2007-05-24] *Ver:1.0.0 *Blog:[url]http://www.Gx3.cn[/url] [url]http://Gx3.cn[/url] *QQ:252319874 */ class 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++) { &nb |