<?php
include("conn.php"); 
 require_once './PHPExcel/PHPExcel.php';
    require_once './PHPExcel/PHPExcel/IOFactory.php';
    require_once './PHPExcel/PHPExcel/Reader/Excel5.php';
$objReader = PHPExcel_IOFactory::createReader('excel2007'); //use Excel5 for 2003 format 
$excelpath='myexcel.xlsx';
$objPHPExcel = $objReader->load($excelpath); 
    $sheet = $objPHPExcel->getSheet(0); 
    $highestRow = $sheet->getHighestRow();           //取得總行數(shù) 
$highestColumn = $sheet->getHighestColumn(); //取得總列數(shù)
for($j=2;$j<=$highestRow;$j++)                        //從第二行開(kāi)始讀取數(shù)據(jù)
    { 
$str="";
        for($k='A';$k<=$highestColumn;$k++)            //從A列讀取數(shù)據(jù)
         { 
             $str .=$objPHPExcel->getActiveSheet()->getCell("$k$j")->getValue().'|*|';//讀取單元格
         } 
$str=mb_convert_encoding($str,'GBK','auto');//根據(jù)自己編碼修改
$strs = explode("|*|",$str);
//echo $str . "<br />";
//exit;
            $sql = "insert into test (title,content,sn,num) values ('{$strs[0]}','{$strs[1]}','{$strs[2]}','{$strs[3]}')";
//echo $sql;
//exit;
            if(!mysql_query($sql,$conn))
            {
               echo 'excel err';
            }
}
?>