phpcms 用phpexcel导入导出excel

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&