php使用PHPExcel-18导入数据库前段和后端源码数据是多列数据

前端代码：

<form method="post" enctype="multipart/form-data">
    <input type="file" name="excelFile">
    <input type="submit" value="上传">
</form>

后端代码：

<?php
require_once 'PHPExcel-1.8/Classes/PHPExcel.php';

if(isset($_FILES['excelFile']) && $_FILES['excelFile']['error'] == 0){
    $filename = $_FILES['excelFile']['name'];
    $ext = pathinfo($filename, PATHINFO_EXTENSION);
    if($ext != 'xlsx' && $ext != 'xls'){
        echo '只能上传Excel文件';
        exit;
    }
    $tmpName = $_FILES['excelFile']['tmp_name'];
    $objReader = PHPExcel_IOFactory::createReader('Excel2007');
    $objPHPExcel = $objReader->load($tmpName);
    $sheet = $objPHPExcel->getSheet(0);
    $highestRow = $sheet->getHighestRow();
    $highestColumn = $sheet->getHighestColumn();
    $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
    $data = array();
    for($row = 1; $row <= $highestRow; $row++){
        $rowData = array();
        for($col = 0; $col < $highestColumnIndex; $col++){
            $value = $sheet->getCellByColumnAndRow($col, $row)->getValue();
            $rowData[] = $value;
        }
        $data[] = $rowData;
    }
    //将$data插入数据库
}

以上代码可以读取Excel文件的所有列数据，并将其存储到一个二维数组中，方便后续的数据库插入操作