yii中集成PHPExcel 实现excel导入

最新推荐文章于 2023-12-08 09:48:33 发布

andyliu

最新推荐文章于 2023-12-08 09:48:33 发布

阅读量2.5k

点赞数 1

分类专栏： php

本文链接：https://blog.csdn.net/liushuai_andy/article/details/19626381

版权

php 专栏收录该内容

45 篇文章 0 订阅

订阅专栏

下载PHPexcel http://phpexcel.codeplex.com/releases/view/96183
下载完成后将其解压至extensions/yiiexcel下 yiiexcel是后来创建的文件夹

修改PHPExcel/Autoloader.php文件将PHPExcel/Autoloader.php文件修改为

<?php
/**
 * PHPExcel
 *
 * Copyright (c) 2006 - 2012 PHPExcel
 *
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation; either
 * version 2.1 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
 *
 * @category   PHPExcel
 * @package    PHPExcel
 * @copyright  Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)
 * @license    http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt    LGPL
 * @version    1.7.8, 2012-10-12
 */

PHPExcel_Autoloader::Register();
//	As we always try to run the autoloader before anything else, we can use it to do a few
//		simple checks and initialisations
PHPExcel_Shared_ZipStreamWrapper::register();
// check mbstring.func_overload
if (ini_get('mbstring.func_overload') & 2) {
    throw new Exception('Multibyte function overloading in PHP must be disabled for string functions (2).');
}
PHPExcel_Shared_String::buildCharacterSets();


/**
 * PHPExcel_Autoloader
 *
 * @category	PHPExcel
 * @package		PHPExcel
 * @copyright	Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)
 */
class PHPExcel_Autoloader
{
	/**
	 * Register the Autoloader with SPL
	 *
	 */
	public static function Register() {
		/*if (function_exists('__autoload')) {
			//	Register any existing autoloader function with SPL, so we don't get any clashes
			spl_autoload_register('__autoload');
		}
		//	Register ourselves with SPL
		return spl_autoload_register(array('PHPExcel_Autoloader', 'Load'));
		 */
		$functions = spl_autoload_functions();
		foreach ( $functions as  $function)
		spl_autoload_unregister($function);
		$functions = array_merge(array(array('PHPExcel_Autoloader','Load')),$functions);
		foreach ( $functions as $function)
		$x = spl_autoload_register($function);
		return $x;
	}	//	function Register()


	/**
	 * Autoload a class identified by name
	 *
	 * @param	string	$pClassName		Name of the object to load
	 */
	public static function Load($pClassName){
		if ((class_exists($pClassName,FALSE)) || (strpos($pClassName, 'PHPExcel') !== 0)) {
			//	Either already loaded, or not a PHPExcel class request
			return FALSE;
		}

		$pClassFilePath = PHPEXCEL_ROOT .
						  str_replace('_',DIRECTORY_SEPARATOR,$pClassName) .
						  '.php';

		if ((file_exists($pClassFilePath) === false) || (is_readable($pClassFilePath) === false)) {
			//	Can't load
			return FALSE;
		}

		require($pClassFilePath);
	}	//	function Load()

}

在控制器的方法中写入代码

		Yii::import('ext.yiiexcel.PHPExcel',true);
		Yii::import('ext.yiiexcel.PHPExcel.IOFactory',true);
		Yii::import('ext.yiiexcel.PHPExcel.Reader.Excel5',true);
		$objReader = PHPExcel_IOFactory::createReader('Excel5');//use excel2007 for 2007 format 
		
		$objPHPExcel = $objReader->load('sensitive.xls'); //$filename可以是上传的文件，或者是指定的文件
		$sheet = $objPHPExcel->getSheet(0); 
		$highestRow = $sheet->getHighestRow(); // 取得总行数 
		$highestColumn = $sheet->getHighestColumn(); // 取得总列数



		//循环读取excel文件,读取一条,插入一条
		//j表示从哪一行开始读取
		
	
		for($j=2;$j<=$highestRow;$j++)
		{
			$a = $objPHPExcel->getActiveSheet()->getCell("A".$j)->getValue();//获取A列的值
			$b = $objPHPExcel->getActiveSheet()->getCell("B".$j)->getValue();//获取B列的值
			$c = $objPHPExcel->getActiveSheet()->getCell("C".$j)->getValue();//获取C列的值
			echo $a.'---'.$b.'---'.$c.'<br />';
		}