phpexcel导入mysql数据库

<?php
require 'PHPExcel/PHPExcel.php';

// 加载Excel文件
$objPHPExcel = PHPExcel_IOFactory::load('example.xlsx');
$sheet = $objPHPExcel->getActiveSheet();

// 读取Excel文件中的数据并存储到数组中
$data = array();
foreach ($sheet->getRowIterator() as $row) {
    $rowData = array();
    foreach ($row->getCellIterator() as $cell) {
        $rowData[] = $cell->getValue();
    }
    $data[] = $rowData;
}

// 连接到MySQL数据库
$servername = "localhost";
$username = "root";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// 将数据插入到MySQL数据库
foreach ($data as $row) {
    $sql = "INSERT INTO table_name (column1, column2, column3) VALUES ('" . $row[0] . "', '" . $row[1] . "', '" . $row[2] . "')";
    if ($conn->query($sql) === TRUE) {
        echo "Record inserted successfully";
    } else {
        echo "Error inserting record: " . $conn->error;
    }
}

$conn->close();
?>