csv和excel php 解析_phpexcel读取excel的xls xlsx csv格式

*

* @author XC

**/

classExcel

{public$currentSheet;public$filePath;public$fileType;public $sheetIndex=0;public$allColumn;public$allRow;publicfunction initialized($filePath) {if(file_exists($filePath)) {

$this->filePath=$filePath;

}else{returnarray();

}//以硬盘方式缓存

$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:

$this->fileType='';break;

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

$PHPReader= newPHPExcel_Reader_CSV();//默认字符集

$PHPReader->setInputEncoding('GBK');//默认分隔符

$PHPReader->setDelimiter(',');if(!$PHPReader->canRead($this->filePath)){returnarray();

}

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

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

$PHPReader= newPHPExcel_Reader_Excel5();if(!$PHPReader->canRead($this->filePath)){returnarray();

}

}

}else{returnarray();

}

$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;

}

}

require_once'Classes/PHPExcel.php';

$import=newExcel();

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

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

echo'

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

';?>