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頭像上傳