当前位置:Gxlcms > PHP教程 > phpexcel读取excel下拉菜单怎么做excel2013官方下载excel2007

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

时间:2021-07-01 10:21:17 帮助过:63人阅读

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

/**
 * 读取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; $row++) {
        for ($col = 0; $col < $highestColumnIndex; $col++) {
            $excelData[$row][] = (string)$objWorksheet->getCellByColumnAndRow($col, $row)->getValue();
        }
    }

    return$excelData;
}

以上就介绍了php excel读取,包括了excel方面的内容,希望对PHP教程有兴趣的朋友有所帮助。

人气教程排行