thinkphp之Excel的导入

2016-03-22更新： 在github上传了一个demo，对导出进行了封装，只需调用thinkPHP的function中的importExcel函数就可以啦，thinkPHP3.2实现excel导入

1.导入phpexcel类库（见上篇thinkphp之Excel的导出）

2.定义Excel转换数组类，路径和代码如下：

ExcelToArrary代码：

<?php
class ExcelToArrary {
  public function __construct() {
		Vendor('PHPExcel.PHPExcel');
	    Vendor('PHPExcel.PHPExcel.IOFactory');
	    Vendor('PHPExcel.PHPExcel.Reader.Excel5');
		vendor('phpExcel.PHPExcel.Reader.Excel2007');	
  }
  public function read($filename,$encode,$file_type){
	        if(strtolower ( $file_type )=='xls')//判断excel表类型为2003还是2007
			{
				Vendor("Excel.PHPExcel.Reader.Excel5"); 
				$objReader = PHPExcel_IOFactory::createReader('Excel5');
			}elseif(strtolower ( $file_type )=='xlsx')
			{
				Vendor("Excel.PHPExcel.Reader.Excel2007"); 
				$objReader = PHPExcel_IOFactory::createReader('Excel2007');
			}
			$objReader->setReadDataOnly(true);
			$objPHPExcel = $objReader->load($filename);
			$objWorksheet = $objPHPExcel->getActiveSheet();
			$highestRow = $objWorksheet->getHighestRow();
			$highestColumn = $objWorksheet->getHighestColumn();
			$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
			$excelData = array();
			for ($row = 1; $row <= $highestRow; $row++) {
				for ($col = 0; $col < $highestColumnIndex; $col++) {
					$excelData[$row][] =(string)$objWorksheet->getCellByColumnAndRow($col, $row)->getValue();
					}
			}
			return $excelData;
	  }
}

3.前端代码：

	<div class="main">
		<p class="currentPosition"><a href="#">号码管理</a>>本地导入号码</p>
		<form method="post" action="<{:U('Excel/add',array('name'=>$vo['managername']),'')}>" enctype="multipart/form-data">
			<input style="width:65px;height:25px" type="file" name="file_stu" />
			<input type="submit" style="background:#438EB9;color:white" value="导入" />
		</form>
		<div>
		
			<div >
			<table>
				<thead>
					<tr>
					<th style="border:1px solid #DDD" > 序号</th>
					<th style="border:1px solid #DDD" > 导入日期</th>
					<th style="border:1px solid #DDD" > 导入文件名</th>
					<th style="border:1px solid #DDD" > 姓名</th>
					<th style="border:1px solid #DDD" > 电话号码</th>
					</tr>
				</thead>
				<tbody>
					<volist name="data"  id="vo">
					    <tr>
							<td style="border:1px solid #DDD" ><{$vo.account}></td>
							<td style="border:1px solid #DDD"><{$vo.datetime}></td>
							<td style="border:1px solid #DDD" ><{$vo.filename}></td>
							<td style="border:1px solid #DDD" ><{$vo.clientname}></td>
							<td style="border:1px solid #DDD" ><{$vo.phone}></td>
						 </tr>
					</volist>
					<tr><td colspan='15'>总用户数：<{$show}><td></tr>
				</tbody>
			</table>
			</div>
		</div>
	</div>

4.控制层代码：

<?php
class ExcelAction extends Action {
	public function __construct()
	{
		parent::__construct();
		import('ORG.Util.ExcelToArrary');//导入excelToArray类
	}
	
	public function index()
	{
		$this->display();
	}
	public function add()
	{	
		$name=session('username');
		$managername=M('manageruser')->where(array('account'=>$name))->find();
		$tmp_file = $_FILES ['file_stu'] ['tmp_name'];
	    $file_types = explode ( ".", $_FILES ['file_stu'] ['name'] );
		$file_type = $file_types [count ( $file_types ) - 1];
	
		 /*判别是不是.xls文件，判别是不是excel文件*/
		 if (strtolower ( $file_type ) != "xlsx" && strtolower ( $file_type ) != "xls")              
		 {
			  $this->error ( '不是Excel文件，重新上传' );
		 }
	
		 /*设置上传路径*/
		 $savePath='Public/admin/Excel/'; //上传路径 
		//检查是否有该文件夹，如果没有就创建，并给予最高权限 
		if(!file_exists($path)) 
		{ 
			mkdir($savePath, 0700); 
		}//END IF
	//	 $savePath = C('UPLOAD_DIR');
	
		 /*以时间来命名上传的文件*/
		 $str = date ( 'Ymdhis' ); 
		 $file_name = $str . "." . $file_type;
		 /*是否上传成功*/
		 if (! copy ( $tmp_file, $savePath . $file_name )) 
		  {
			  $this->error ( '上传失败' );
		  }
		$ExcelToArrary=new ExcelToArrary();//实例化
		$res=$ExcelToArrary->read($savePath.$file_name,"UTF-8",$file_type);//传参,判断office2007还是office2003

		foreach ( $res as $k => $v ) //循环excel表
		  {
			   $k=$k-1;//addAll方法要求数组必须有0索引
			   $data[$k]['clientname'] = $v [1];//创建二维数组		   
			   $data[$k]['phone'] = $v [2];
			   $data[$k]['datetime'] = date('Y-m-d',time());//创建二维数组
			   $data[$k]['managername'] = $managername['managername'];//创建二维数组
			   $data[$k]['filename'] =  $file_types[0];
		  }
		  $kucun=M('salerleadin');//M方法
		  $result=$kucun->addAll($data);
		  if(! $result)
		  {
			  $this->error('导入数据库失败');
			  exit();
		  }
		  else
		  {
			  $this->success ( '导入成功' );	
		  }
	}
}

参考例程：http://blog.csdn.net/sui13725202/article/details/9285501