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文件的方法
http://www.bkjia.com/phpjc/1092842.htmlwww.bkjia.comtruehttp://www.bkjia.com/phpjc/1092842.htmltecharticlephp实现的操作excel类详解，phpexcel类详解 本文实例讲述了php实现的操作excel类。分享给大家供大家参考，具体如下： phpclass excel{ static $inst...