html
<form method="post" action="?m=content&c=content&a=public_add_excel" enctype="multipart/form-data">
<h3>导入excel表:</h3><input type="file" name="file_stu"/>
<input type="submit" value="导入"/>
</form>
//导入的方法
public function public_add_excel()
{
$file_path=$_FILES['file_stu']['tmp_name'];
require PC_PATH.'libs/classes/PHPExcel.php';
require PC_PATH.'libs/classes/PHPExcel/IOFactory.php';
require PC_PATH.'libs/classes/PHPExcel/Reader/Excel2007.php';
require PC_PATH.'libs/classes/PHPExcel/Reader/Excel5.php';
$this->db_hb2 = pc_base::load_model('huanbao2_model');
move_uploaded_file($file_path, './tmp.xls');
$array=format_excel2array('./tmp.xls');
//array_shift($array);
//将数组入库按照官方方法入库
//var_dump($array);die;
foreach ($array as $key => $value) {
$mzinfo=array();
$mzinfo['c3']=$value['B'];
$mzinfo['com1']=$value['C'];
$mzinfo['carname']=$value['D'];
$mzinfo['fdj']=$value['E'];
$mzinfo['com2']=$value['F'];
$mzinfo['shangbiao']=$value['G'];
$mzinfo['jieduan']=$value['H'];
$mzinfo['cat']=$value['I'];
$time = (((double)$value['J'])-25569)*24*60*60-28800;//时间的转换
$mzinfo['time']=str_replace("00:00","",date('Y-m-d H:i',$time)) ;
$mzinfo['flag']=2;
$ids=$this->db_hb2->insert($mzinfo,true);
}
showmessage(L('operation_success'), HTTP_REFERER);
}
//format_excel2array
这个方法我写在phpcms/libs/functions/global.func.php里面
function format_excel2array($filePath&