php解析Excel表格并且导入MySQL数据库

        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=\D:/wamp64/www/Book1.xlsx\;
        //$excelpath = $uploadAddr;

        //$objPHPExcel = $objReader->load($excelpath); 
        $objPHPExcel = PHPExcel_IOFactory::load($excelpath);
        $sheet = $objPHPExcel->getSheet(0); 

        $highestRow = $sheet->getHighestRow();       //取得总行数 

        $highestColumn = $sheet->getHighestColumn(); //取得总列数
        error_reporting( E_ALL&~E_NOTICE );
        $str = "";
        for($j=2;$j<=$highestRow;$j++)
        { 
            $id = "";
            $name = "";
            for($k=\A\;$k<=$highestColumn;$k++)
            { 
                //$str .= $objPHPExcel->getActiveSheet()->getCell("$k$j")->getValue().\\\\;//读取单元格
                $str = $sheet->getCell($k.$j)->getValue();
                //$str = $sheet->getCell($k.$j+1)->getValue(); echo $str."<br>";
                //echo $sheet->getCell($k.$j)->getValue()."  "; 
                 //explode:函数把字符串分割为数组。
                $strs = explode("\\",$str); 
                if ($k==\A\) $id = $str;
                if ($k==\B\) $name = $str;
            } 
            echo $id; echo $name."<br>";
            $link = mysqli_connect("localhost", "root", "", "excel");
                //$db_ed = mysql__db("excel", $link);
                if (mysqli_connect_errno()) {
                    printf("Connect failed: sn", mysqli_connect_error());
                    exit();
                } 
                mysqli_query($link,"set names utf8"); 
            try {
                    mysqli_query($link, "  test(id,name) VALUES(\".$id."\,\".$name."\)"); 
                    // echo "$strs[0]"." | "."$strs[1]"."<br>"; 
                    // echo "  test(id,classname) VALUES(\".$strs[0]."\,\".$strs[1]."\)";
                    // echo "<br>";
                } catch (Exception $e) {
                  print $e->getMessage();  
                }   
        }    

打赏

感谢支持与鼓励～