PHPExcel18导入数据库前段和后端代码

前端代码：

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

//创建PHPExcel对象
$objExcel = new PHPExcel();

//读取Excel文件
$objReader = PHPExcel_IOFactory::createReader('Excel5');
$objPHPExcel = $objReader->load('example.xls');

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

//获取总行数和总列数
$maxRow = $objSheet->getHighestRow();
$maxColumn = $objSheet->getHighestColumn();

//循环读取每个单元格的数据
for($row = 1; $row <= $maxRow; $row++){
    for($column = 'A'; $column <= $maxColumn; $column++){
        $value = $objSheet->getCell($column.$row)->getValue();
        //将数据写入数据库中
        //...
    }
}
?>

后端代码：

<?php
//连接数据库
$link = mysqli_connect('localhost', 'root', '123456', 'test');

//设置字符集
mysqli_set_charset($link, 'utf8');

//读取Excel文件
$objPHPExcel = PHPExcel_IOFactory::load('example.xls');

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

//获取总行数和总列数
$maxRow = $objSheet->getHighestRow();
$maxColumn = $objSheet->getHighestColumn();

//循环读取每个单元格的数据
for($row = 1; $row <= $maxRow; $row++){
    for($column = 'A'; $column <= $maxColumn; $column++){
        $value = $objSheet->getCell($column.$row)->getValue();
        //将数据写入数据库中
        mysqli_query($link, "INSERT INTO example VALUES ('$value')");
    }
}

//关闭连接
mysqli_close($link);
?>
``