php excel csv格式,PHPExcel操作excel、csv格式的文件

/**

*

* @author Sam@ozchamp.net

*

*/

class Excel

{

public $currentSheet;

public $filePath;

public $fileType;

public $sheetIndex=0;

public $allColumn;

public $allRow;

public function initialized($filePath) {

if (file_exists($filePath)) {

$this->filePath=$filePath;

}else{

return array();

}

//以硬盤方式緩存

$cacheMethod = PHPExcel_CachedObjectStorageFactory:: cache_to_discISAM;

$cacheSettings = array();

PHPExcel_Settings::setCacheStorageMethod($cacheMethod, $cacheSettings);

$file_ext=strtolower(pathinfo($this->filePath, PATHINFO_EXTENSION));

switch ($file_ext) {

case 'csv':

$this->fileType='csv';

break;

case 'xlsx':

$this->fileType='excel';

break;

case 'xls':

$this->fileType='excel';

break;

default:

;

break;

}

if ($this->fileType=='csv') {

$PHPReader = new PHPExcel_Reader_CSV();

//默认的输入字符集

$PHPReader->setInputEncoding('GBK');

//默认的分隔符

$PHPReader->setDelimiter(',');

if(!$PHPReader->canRead($this->filePath)){

return array();

}

}elseif ($this->fileType=='excel'){

$PHPReader = new PHPExcel_Reader_Excel2007();

if(!$PHPReader->canRead($this->filePath)){

$PHPReader = new PHPExcel_Reader_Excel5();

if(!$PHPReader->canRead($this->filePath)){

return array();

}

}

}else{

return array();

}

$PHPReader->setReadDataOnly(true);

$PHPExcel = $PHPReader->load($this->filePath);

$this->currentSheet = $PHPExcel->getSheet((int)$this->sheetIndex);

//$this->currentSheet = $PHPExcel->getActiveSheet();

$this->allColumn=$this->currentSheet->getHighestColumn();

$this->allRow=$this->currentSheet->getHighestRow();

}

public function fetch($beginRow=NULL, $endRow=NULL){

$currentSheet=$this->currentSheet;

$allColumn=$this->allColumn;$allRow=$this->allRow;

$dataSrc=$data=array();

//取列标题

for($currentColumn= 'A';$currentColumn<= $allColumn; $currentColumn++){

$val = $currentSheet->getCellByColumnAndRow(ord($currentColumn) - 65, 1)->getValue();//ord()将字符转为十进制

$dataSrc[ord($currentColumn) - 65]=strtolower(trim($val));}

//echo implode("\t", $dataSrc);

$beginRow=$beginRow ? $beginRow : 2;

$endRow=$endRow ? $endRow : $allRow;

for($currentRow = $beginRow ;$currentRow <= $endRow ;$currentRow++){

//从第A列输出$dataRow=array();

for($currentColumn= 'A';$currentColumn<= $allColumn; $currentColumn++){

$val = $currentSheet->getCellByColumnAndRow(ord($currentColumn) - 65,$currentRow)->getValue();//ord()将字符转为十进制

$dataRow[$dataSrc[ord($currentColumn) - 65]]=$val;

}

//行集数据处理..

if($dataRow){

$data[]=$dataRow;}

}

//echo '

', print_r($data), '

';

//echo "\n";

return $data;

}

}

//测试

/*$import=new Excel();

$import->initialized(dirname(__FILE__) . '/test.xlsx');

header("Content-type: text/html; charset=utf-8");

echo '

', print_r($import->fetch()), '

';*/