dede excel导入数据库

<?php
require_once 'PHPExcel/IOFactory.php';

// 加载Excel文件
$inputFileName = 'data.xlsx';
$objPHPExcel = PHPExcel_IOFactory::load($inputFileName);

// 获取第一个工作表
$worksheet = $objPHPExcel->getActiveSheet();

// 连接数据库
$mysqli = new mysqli('localhost', 'username', 'password', 'database');
if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: " . $mysqli->connect_error;
    exit();
}

// 遍历工作表中的每一行数据
foreach ($worksheet->getRowIterator() as $row) {
    $cellIterator = $row->getCellIterator();
    $cellIterator->setIterateOnlyExistingCells(false);

    $rowData = [];
    foreach ($cellIterator as $cell) {
        $rowData[] = $cell->getValue();
    }

    // 插入数据到数据库
    $sql = "INSERT INTO table_name (column1, column2, column3) VALUES (?, ?, ?)";
    $stmt = $mysqli->prepare($sql);
    $stmt->bind_param('sss', $rowData[0], $rowData[1], $rowData[2]);
    if (!$stmt->execute()) {
        echo "Insert failed: " . $stmt->error . "\n";
    }
}

$mysqli->close();
?>