以后自己用的Excel批量导入

<?phpheader("content-type:text/html;charset=utf8");$conn=mysql_connect("localhost","root","root") or die("数据库服务器连接错误".mysql_error());    mysql_select_db("ytwo",$conn) or die("数据库访问错误".mysql_error());    mysql_query("set character set utf8");    mysql_query("set names utf8");<?phpinclude("mysql.php");   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/Excel2007.php';$objReader = PHPExcel_IOFactory::createReader('excel2007'); //use Excel5 for 2003 format $excelpath='123.csv';$objPHPExcel = $objReader->load($excelpath); $sheet = $objPHPExcel->getSheet(0); $highestRow = $sheet->getHighestRow();           //取得总行数 $highestColumn = $sheet->getHighestColumn(); //取得总列数for($j=2;$j<=$highestRow;$j++) {                       //从第二行开始读取数据    $str="";    for($k='A';$k<=$highestColumn;$k++) {           //从A列读取数据        $str .=$objPHPExcel->getActiveSheet()->getCell("$k$j")->getValue().'|*|';//读取单元格     } $str=mb_convert_encoding($str,'UTF-8','auto');//根据自己编码修改$strs = explode("|*|",$str);// echo $str . "<br />"; // exit;            $sql = "insert into user (name,age,sex) values ('{$strs[0]}','{$strs[1]}','{$strs[2]}')";// echo $sql;// exit;    if(!mysql_query($sql,$conn)){       echo 'excel err';    }}

复制出去改一下就能用批量导入了。