PHPExcel 导入表读取表中数据

最新推荐文章于 2022-06-02 18:09:49 发布

安和桥北AN

最新推荐文章于 2022-06-02 18:09:49 发布

阅读量101

点赞数

分类专栏： THINKPHP

本文链接：https://blog.csdn.net/qq_26567389/article/details/106208280

版权

THINKPHP 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

1.引入包

use PHPExcel;
use PHPExcel_Writer_Excel2007;

2.调用

if (!empty($_FILES['excel']['name'])){        //如果上传文件有值
            $file = request()->file('excel');         //接收上传的数据放进$file
            $info = $file->rule('date')->move( '../public/uploads/excel'); // 移动到框架应用根目录/uploads/ 目录下
            $excelSrc = 'uploads/excel/'.$info->getSaveName();            //保存到本地目录下的地址存入$data['img']
        }
        $phpexcel = new \PHPExcel();                                    //实例化
        $PHPReader = new \PHPExcel_Reader_Excel2007();
        $PHPExcel = $PHPReader->load('uploads/excel/20200518\28746a8365efe1e11ea830339d06ecba.xlsx');
        $currentSheet = $PHPExcel->getSheet(0);  /**取得一共有多少列*/
        $allColumn = $currentSheet->getHighestColumn();     /**取得一共有多少行*/  
        $allRow = $currentSheet->getHighestRow();

        $all = array();
        for( $currentRow = 1 ; $currentRow <= $allRow ; $currentRow++){
            $flag = 0;
            $col = array();
            for($currentColumn='A'; $currentColumn <= $allColumn ; $currentColumn++){
                $address = $currentColumn.$currentRow;   
                $string = $currentSheet->getCell($address)->getValue();
                $col[$flag] = $string;
                $flag++;
            }
            $all[] = $col;
        }
         dump($all);die;