無聊寫這玩的,喜歡擴展的朋友別忘了發我一份哦,哈哈 謝謝,
ps:測試沒什麼效率的說,哈哈~~~
[email protected]復制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++)
{
for($j=2;$j<$this->maxrows;$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;$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;
&nb