下载
sourceforge.net/projects/phpexcelreader/
一:修改reader.php内
require_once ‘Spreadsheet/Excel/Reader/OLERead.php’;
为
require_once ‘Excel/oleread.inc’;
二:数据库utf-8编码
三:php执行程序
$data = new Spreadsheet_Excel_Reader();
$data->setOutputEncoding(‘UTF-8’);//设置编码
$data->read(‘test.xls’);//excel,csv文件位置
error_reporting(E_ALL ^ E_NOTICE);
for ($i = 2; $i <= $data->sheets[0][‘numRows’]; $i++) {//插入数据库开始
$sql="INSERT INTO {$table}kehu (userid,sortid,danwei,xingming,zuncheng,tel,mobile,fax,email,website,qq,address,postcode,sex,beizhu,addtime) values(‘$_COOKIE[WECMS_user_id]’,’$sortid’,
‘".$data->sheets[0][‘cells’][$i][1]."’,
‘".$data->sheets[0][‘cells’][$i][2]."’,
‘".$data->sheets[0][‘cells’][$i][3]."’,
‘".$data->sheets[0][‘cells’][$i][4]."’,
‘".$data->sheets[0][‘cells’][$i][5]."’,
‘".$data->sheets[0][‘cells’][$i][6]."’,
‘".$data->sheets[0][‘cells’][$i][7]."’,
‘".$data->sheets[0][‘cells’][$i][8]."’,
‘".$data->sheets[0][‘cells’][$i][9]."’,
‘".$data->sheets[0][‘cells’][$i][10]."’,
‘".$data->sheets[0][‘cells’][$i][11]."’,
‘".$data->sheets[0][‘cells’][$i][12]."’,
‘".$data->sheets[0][‘cells’][$i][13]."’,
‘$nowtime’)";
$res=$db->query($sql);
//插入数据库结束
}
成功