欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  后端开发

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

程序员文章站 2022-05-17 21:47:48
...
当然首先要判断是否有文件和文件类型,接着把文件保存到某个路径中

/**
 * 读取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
相关标签: excel