php实现的操作excel类详解,phpexcel类详解
程序员文章站
2024-01-10 16:31:04
...
php实现的操作excel类详解,phpexcel类详解
本文实例讲述了php实现的操作excel类。分享给大家供大家参考,具体如下:
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;$imaxcols;$i++) { for($j=2;$jmaxrows;$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;$imaxcols;$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;$imaxcols;$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;$ieditOneRow(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."
"; //$message.="电子邮箱为:".$this->link_email."
"; //$message.="商务联系QQ:".$this->link_qq."
"; //$message.="商务电话QQ:".$this->link_tel."
"; //$message.="联系人:".$this->link_people."
"; $smtp->debug=false; foreach($str['email'] as $key=>$value){ $smtpemailto=$value; @$smtp->sendmail($smtpemailto,$smtpuseremail,$mailsubject,$message,$mailtype); exit; } //exit; $excel->Close(); ?>
更多关于PHP操作Excel相关内容感兴趣的读者可查看本站专题:《php操作office文档技巧总结(包括word,excel,access,ppt)》
希望本文所述对大家PHP程序设计有所帮助。
您可能感兴趣的文章:
- php excel类 phpExcel使用方法介绍
- thinkPHP导出csv文件及用表格输出excel的方法
- PHP使用PHPexcel导入导出数据的方法
- PHP导入导出Excel代码
- php导出中文内容excel文件类实例
- 用PHP生成excel文件到指定目录
- PHPExcel中的一些常用方法汇总
- php导入excel文件到mysql数据库的方法
- php生成excel列名超过26列大于Z时的解决方法
- Yii中使用PHPExcel导出Excel的方法
- ThinkPHP基于PHPExcel导入Excel文件的方法