php实现的操作excel类详解

2020-03-22 19:28:54

字体：大中小

来源：转载

供稿：网友

$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)- html' target='_blank'>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 $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();
更多关于PHP操作Excel相关内容感兴趣的读者可查看本站专题：《php操作office文档技巧总结(包括word,excel,access,ppt)》希望本文所述对大家PHP程序设计有所帮助。PHP教程

郑重声明：本文版权归原作者所有，转载文章仅为传播更多信息之目的，如作者信息标记有误，请第一时间联系我们修改或删除，多谢。

上一篇：PHP闭包函数详解

下一篇：PHP头像上传