PHPExcel将Excel数据导入数据库

<?php
//PHPExcel读取导入Excel数据到数据库(2003,2007通用)使用方法:
//先用excel2array（）方法将excel表中的数据存储到数组，在从遍历二维数组将数据保存进数据库
require_once "./PHPExcel.class.php";
require_once "./PHPExcel/Cell/DataType.php";
require_once "./PHPExcel/IOFactory.php";
/**
 * 将excel表中的数据存储到数组
 * @param string $filename 文件名
 * @return array
 */
function excel2array($filename){
    $ext = pathinfo($filename, PATHINFO_EXTENSION);//获取文件后缀名
    if($ext == "xls"){
        $objReader = PHPExcel_IOFactory::createReader('Excel5');
    }
    if($ext == "xlsx"){
        $objReader = PHPExcel_IOFactory::createReader('Excel2007');
    }

    $objReader->setReadDataOnly(true);
    $objPHPExcel = $objReader->load($filename);
    $objWorksheet = $objPHPExcel->getActiveSheet();
    $highestRow = $objWorksheet->getHighestRow(); //取得行数
    $highestColumn = $objWorksheet->getHighestColumn();
    $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn); //取得列数
    $excelData = array();
    for ($row = 2; $row <= $highestRow; $row++) {
        for ($col = 0; $col < $highestColumnIndex; $col++) {
            $excelData[$row][] =$objWorksheet->getCellByColumnAndRow($col, $row)->getValue();
        }
    }
    return $excelData;
}