php使用PHPEXCEL 18导入数据库前段和后端代码

前端代码：

后端代码：

0) { echo "错误: " . $_FILES["file"]["error"] . "
"; } else { $inputFileType = PHPExcel_IOFactory::identify($_FILES['file']['tmp_name']); $objReader = PHPExcel_IOFactory::createReader($inputFileType); $objPHPExcel = $objReader->load($_FILES['file']['tmp_name']); $sheet = $objPHPExcel->getSheet(0); $highestRow = $sheet->getHighestRow(); $highestColumn = $sheet->getHighestColumn(); $conn = new mysqli("localhost", "root", "password", "database_name"); for ($row = 2; $row <= $highestRow; $row++) { $rowData = $sheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, NULL, TRUE, FALSE); $sql = "INSERT INTO `table_name` (`column1`, `column2`, `column3`) VALUES ('" . $rowData[0][0] . "', '" . $rowData[0][1] . "', '" . $rowData[0][2] . "')"; $conn->query($sql); } $conn->close(); } echo "数据导入成功！"; ?>

注意替换以下内容：

• PHPExcel路径：require_once 'PHPExcel/PHPExcel.php';
• 数据库连接信息：$conn = new mysqli("localhost", "root", "password", "database_name");
• 数据表信息：INSERT INTO table_name (column1, column2, column3) VALUE