用php将excel数据导入数据库表

<?php
// 引入PHPExcel库
require_once 'PHPExcel/PHPExcel.php';

// 连接数据库
$servername = "数据库服务器地址";
$username = "数据库用户名";
$password = "数据库密码";
$dbname = "数据库名";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("数据库连接失败: " . $conn->connect_error);
}

// 加载Excel文件
$excelFile = "路径/文件名.xlsx";
$excelReader = PHPExcel_IOFactory::createReaderForFile($excelFile);
$excelObj = $excelReader->load($excelFile);

// 获取第一个工作表
$worksheet = $excelObj->getSheet(0);

// 获取最大行数和列数
$highestRow = $worksheet->getHighestRow();
$highestColumn = $worksheet->getHighestColumn();

// 遍历每行数据并插入数据库
for ($row = 2; $row <= $highestRow; $row++) {
    $rowData = $worksheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, NULL, TRUE, FALSE);
    
    // 构建插入语句
    $sql = "INSERT INTO 表名 (列1, 列2, 列3) VALUES (?, ?, ?)";
    
    // 准备并绑定参数
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("sss", $rowData[0][0], $rowData[0][1], $rowData[0][2]);
    
    // 执行插入
    $stmt->execute();
}

// 关闭数据库连接
$conn->close();
?>