php excel读取 excel下拉菜单怎么做 excel2013官方下载 excel2007

当然首先要判断是否有文件和文件类型，接着把文件保存到某个路径中

/**
 * 读取excel数据
 * @author Red
 * @date
 * @param $filename 文件所在路径+文件名
 * @param string $encode
 * @param $file_type
 * @return array
 */function readExcel($filename, $encode = 'utf-8', $file_type)
{
    include './plugins/excel/PHPExcel.php';
    include './plugins/excel/PHPExcel/Reader/Excel2007.php';
    include './plugins/excel/PHPExcel/Writer/Excel5.php';
    include './plugins/excel/PHPExcel/Writer/Excel2007.php';

    if ($file_type == 'xlsx') {
        $objReader = PHPExcel_IOFactory::createReader('Excel2007');
    } else {
        $objReader = PHPExcel_IOFactory::createReader('Excel5');
    }

    $objReader->setReadDataOnly(true);

    $objPHPExcel        = $objReader->load($filename);
    $objWorksheet       = $objPHPExcel->getActiveSheet();
    $hightestrow        = $objWorksheet->getHighestRow();
    $highestColumn      = $objWorksheet->getHighestColumn();
    $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
    $excelData          = array();
　　 //从第二行开始
    for ($row = 2; $row $hightestrow