phpexcel 导入excel2003或2007文件数据

最新推荐文章于 2021-03-27 17:04:29 发布

haiwei_sun

最新推荐文章于 2021-03-27 17:04:29 发布

阅读量3.2k

点赞数 1

分类专栏： php

本文链接：https://blog.csdn.net/helen_shw/article/details/8332097

版权

php 专栏收录该内容

105 篇文章 0 订阅

订阅专栏

 $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");