$excel_arr = explode("uploadfile",$excel_file_url);
$resource = str_replace("\\","/",getcwd())."/uploadfile".$excel_arr[1];
error_reporting(E_ALL);
set_include_path(get_include_path() . PATH_SEPARATOR . str_replace("\\","/",getcwd())."/excel/");
include 'PHPExcel/IOFactory.php';
if (!file_exists($resource)) {
exit("no file .\n");
}
$excel_ext = fileext($resource);
if($excel_ext=="xlsx"){
$reader = PHPExcel_IOFactory::createReader('Excel2007');
}else{
$reader = PHPExcel_IOFactory::createReader('Excel5');
}
$PHPExcel = $reader->load($resource);
$sheet = $PHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow();
$highestColumn = $sheet->getHighestColumn();
$arr = array(1=>'A',2=>'B',3=>'C',4=>'D',5=>'E',6=>'F',7=>'G',8=>'H',9=>'I',10=>'J',11=>'K',12=>'L',13=>'M', 14=>'N',15=>'O',16=>'P',17=>'Q',18=>'R',19=>'S',20=>'T',21=>'U',22=>'V',23=>'W',24=>'X',25=>'Y',26=>'Z');
$rtime=time();
echo "数据导入中...<Br>";
$this->db->delete("id>0");
for ($row = 2; $row <= $highestRow; $row++) {
$data['siteid']=0;
$data['city'] = $sheet->getCellByColumnAndRow(0, $row)->getValue();
$data['county'] = $sheet->getCellByColumnAndRow(1, $row)->getValue();
$data['home'] = $sheet->getCellByColumnAndRow(2, $row)->getValue();
$data['village'] = $sheet->getCellByColumnAndRow(3, $row)->getValue();
$data['rtime'] = $rtime;
$data['username'] = param::get_cookie('admin_username');
$data['is_valid']=1;
$data['sort_by']=0;
$this->db->insert($data);
echo $data['city']."-".$data['county']."-".$data['home']."-".$data['village']."导入成功!<br>";
}
showmessage('数据导入完毕', "?m=check&c=admin_check&a=init");
phpexcel 导入excel2003或2007文件数据
最新推荐文章于 2021-03-27 17:04:29 发布