PHPExcel操作excel、csv格式的文件代码,PHP代码库,德仔网

代码语言
代码分类
【PHP】 PHPExcel操作excel、csv格式的文件
作者:晓瑜 / 发布于2017/4/10/ 1113
/**
 *
 * @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 '<pre>', print_r($data), '</pre>';

			//echo "\n";
		return $data;
	}
}

//测试

/*$import=new Excel();

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

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

echo '<pre>', print_r($import->fetch()), '</pre>';*/
试试其它关键字
同语言下
可能有用的
晓瑜贡献的其它代码(6)