织梦excel数据库导入

<?php
require_once 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Reader\Exception as ReaderException;

// 连接数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "demedb";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 加载Excel文件
$inputFileName = 'data.xlsx';
try {
    $reader = IOFactory::createReader('Xlsx');
    $spreadsheet = $reader->load($inputFileName);
    $worksheet = $spreadsheet->getActiveSheet();

    // 获取数据范围
    $highestRow = $worksheet->getHighestRow();
    $highestColumn = $worksheet->getHighestColumn();

    // 循环读取数据并插入数据库
    for ($row = 1; $row <= $highestRow; $row++) {
        for ($column = 'A'; $column <= $highestColumn; $column++) {
            $cellValue = $worksheet->getCell($column . $row)->getValue();
            // 根据实际情况处理数据并插入数据库
            $sql = "INSERT INTO your_table (column_name) VALUES ('$cellValue')";
            if ($conn->query($sql) === TRUE) {
                echo "新记录插入成功";
            } else {
                echo "Error: " . $sql . "<br>" . $conn->error;
            }
        }
    }
} catch (ReaderException $e) {
    echo "读取Excel文件时出错: " . $e->getMessage();
}

$conn->close();
?>