方法一

function upExecel(){//判斷是否選擇了要上傳的表格if (empty($_POST['myfile'])) { echo "alert(您未選擇表格);history.go(-1);";}//獲取表格的大小深夯，限制上傳表格的大小5M$file_size = $_FILES['myfile']['size'];if ($file_size>5*1024*1024) {echo "alert('上傳失敗抖所，上傳的表格不能超過5M的大小');history.go(-1);"; exit();}//限制上傳表格類型$file_type = $_FILES['myfile']['type'];//application/vnd.ms-excel 為xls文件類型if ($file_type!='application/vnd.ms-excel') { echo "alert('上傳失敗澎蛛，只能上傳excel2003的xls格式!');history.go(-1)"; exit();}//判斷表格是否上傳成功if (is_uploaded_file($_FILES['myfile']['tmp_name'])) { require_once 'PHPExcel-1.8/Classes/PHPExcel.php'; require_once 'PHPExcel-1.8/Classes/PHPExcel/IOFactory.php'; require_once 'PHPExcel-1.8/Classes/PHPExcel/Reader/Excel5.php'; //以上三步加載phpExcel的類 $objReader = PHPExcel_IOFactory::createReader('Excel5');//use excel2007 for 2007 format //接收存在緩存中的excel表格 $filename = $_FILES['myfile']['tmp_name']; $objPHPExcel = $objReader->load($filename); //$filename可以是上傳的表格，或者是指定的表格 $sheet = $objPHPExcel->getSheet(0); $highestRow = $sheet->getHighestRow(); // 取得總行數(shù) // $highestColumn = $sheet->getHighestColumn(); // 取得總列數(shù) //循環(huán)讀取excel表格,讀取一條,插入一條 //j表示從哪一行開始讀取 從第二行開始讀取梦鉴，因?yàn)榈谝恍惺菢?biāo)題不保存 //$a表示列號(hào) for($z=2;$z<=$highestRow;$z++) { // echo "$sql"; $a = $objPHPExcel->getActiveSheet()->getCell("A".$z)->getValue();//獲取A(業(yè)主名字)列的值 $b = $objPHPExcel->getActiveSheet()->getCell("B".$z)->getValue();//獲取B(密碼)列的值 $c = $objPHPExcel->getActiveSheet()->getCell("C".$z)->getValue();//獲取C(手機(jī)號(hào))列的值 $d = $objPHPExcel->getActiveSheet()->getCell("D".$z)->getValue();//獲取D(地址)列的值 $e = $objPHPExcel->getActiveSheet()->getCell("E".$z)->getValue(); $f = $objPHPExcel->getActiveSheet()->getCell("F".$z)->getValue(); $g = $objPHPExcel->getActiveSheet()->getCell("G".$z)->getValue(); $h = $objPHPExcel->getActiveSheet()->getCell("G".$z)->getValue(); $i = $objPHPExcel->getActiveSheet()->getCell("I".$z)->getValue(); $j = $objPHPExcel->getActiveSheet()->getCell("J".$z)->getValue(); //null 為主鍵id，自增可用null表示自動(dòng)添加 $res= mysql_query("INSERT INTO db2mistake VALUES(null,'$a','$b','$c','$d','$e','$f','$g','$h','$i','$j')"); // exit(); if ($res) { echo "alert('添加成功！');window.location.href='./uploadhtml.html';"; }else{ echo "alert('添加失斘汀！');window.location.href='./uploadhtml.html';"; exit(); } }}}//調(diào)用upExecel();

方法二

?php define('BASE_URL', realpath(dirname(__FILE__))); require_once BASE_URL . '/PHPExcel-1.8/Classes/PHPExcel.php';//引入PHPExcel類文件 //excel文件的地址 $excel_fiel_path = './mistakes1.xls'; $$host ='localhost'; $user = "root"; $password = "";$database = "contract resource management"; $server = mysql_connect($host, $user, $password); $conn = mysql_select_db($database, $server); $PHPExcel = new PHPExcel();// 實(shí)例化PHPExcel工具類 //分析文件獲取后綴判斷是2007版本還是2003 $extend = pathinfo("./" . $excel_fiel_path); $extend = strtolower($extend["extension"]); // 判斷xlsx版本晒他，如果是xlsx的就是2007版本的吱型，否則就是2003 if ($extend=="xlsx") { $PHPReader = new PHPExcel_Reader_Excel2007(); $PHPExcel = $PHPReader-load("./" . $excel_fiel_path); }else{ $PHPReader = new PHPExcel_Reader_Excel5(); $PHPExcel = $PHPReader->load("./" . $excel_fiel_path); } /* 第二種方法*/ $objWorksheet = $PHPExcel->getActiveSheet(); $highestRow = $objWorksheet->getHighestRow(); echo 'highestRow='.$highestRow; echo "

";? $highestColumn = $objWorksheet->getHighestColumn();? $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);//總列數(shù)? echo 'highestColumnIndex='.$highestColumnIndex;? echo "

";? $headtitle=array();? for ($row = 2;$row <= $highestRow;$row++)? {? ? ? $strs=array();? ? ? //注意highestColumnIndex的列數(shù)索引從0開始? ? ? for ($col = 0;$col < $highestColumnIndex;$col++)? ? ? {? ? ? ? ? $strs[$col] =$objWorksheet->getCellByColumnAndRow($col, $row)->getValue();? ? ? ? }? ? ? //todo? ? ? //連接mysql ，一條條寫入? ? ? $res= mysql_query("INSERT INTO db2mistake VALUES(null,'$strs[0]','$strs[1]','$strs[2]','$strs[3]','$strs[4]','$strs[5]','$strs[6]','$strs[7]','$strs[8]','$strs[9]')");? ? if ($res) {? ? ? ? ? ? echo "alert('添加成功陨仅！');window.location.href='./test.html';";? ? ? ? ? ? ? ? ? ? }else{? ? ? ? ? ? echo "alert('添加失斀蛑汀！');window.location.href='./test.html';";? ? ? ? ? ? exit();? ? ? ? }}