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['numRows']; $i++) {
if($i != 1){
$user_name =$data->sheets['cells'][$i];
$user_pwd =$data->sheets['cells'][$i];
$user_email =$data->sheets['cells'][$i];
echo $user_name.' '.$user_pwd.' '.$user_email.' '."<HR>";
}
}
}
?>
页:
[1]