PHP > EXCEL 导入

 

 

<meta charset="utf-8">


<form method=post action="" name="">
	<input type="file" name="file1" />
	<input type="submit" name="sub" value="提交">
</form>

<?php

if(isset($_POST['sub'])){
	$excle_file = $_POST['file1'];
	
	// 测试文档
	require_once 'excel/reader.php';
	
	// Excel文件($filename, $encoding);
	$data = new Spreadsheet_Excel_Reader();
	
	// 设置输入编码 UTF-8/GB2312/CP936等等
	$data->setOutputEncoding('UTF-8'); 
	
	$data->read($excle_file);
	
	error_reporting(E_ALL ^ E_NOTICE);
	
	for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) {
		if($i != 1){
			$user_name =  $data->sheets[0]['cells'][$i][1];
			$user_pwd =  $data->sheets[0]['cells'][$i][2];
			$user_email =  $data->sheets[0]['cells'][$i][3];
			echo $user_name.'&nbsp;&nbsp;'.$user_pwd.'&nbsp;&nbsp;'.$user_email.'&nbsp;&nbsp;'."<HR>";		
		}	
	}
	
	
}
?>