PHPExcel 导入

最新推荐文章于 2025-06-19 10:29:52 发布

shinebxy

最新推荐文章于 2025-06-19 10:29:52 发布

阅读量884

点赞数

CC 4.0 BY-SA版权

分类专栏： PHPExcel 文章标签： PHPExcel 导入

本文链接：https://blog.youkuaiyun.com/shinebxy/article/details/80584562

PHPExcel 专栏收录该内容

3 篇文章

订阅专栏

    function importExecl($file='', $sheet=0)
    {
        header("Content-type:text/html;charset=utf-8");
        ini_set('memory_limit', '3072M');
        ini_set('max_execution_time', 0);
        $file = "./Uploads/20180605.xlsx";
        $file = iconv("utf-8", "gb2312", $file);   //转码
        if(empty($file) OR !file_exists($file)) {
            die('file not exists!');
        }
        vendor('PHPExcel.PHPExcel');
        $objRead = new \PHPExcel_Reader_Excel2007();   //建立reader对象
        if(!$objRead->canRead($file)){
            $objRead = new PHPExcel_Reader_Excel5();
            if(!$objRead->canRead($file)){
                die('No Excel!');
            }
        }
        $arr = array(
            'A' => 'goods_oe',
            'B' => 'goods_number',
            'C' => 'goods_name',
            'D' => 'content',
            'E' => 'source',
            'F' => 'category_name'
        );

        $obj = $objRead->load($file);  //建立excel对象
        $currentSheet = $obj->getSheet($sheet);   //获取指定的sheet表
        $allColumn = $currentSheet->getHighestColumn();   //取得最大的列号
        $allRow = $currentSheet->getHighestRow();   //获取总行数
        $i = 0;

      //方法一    $data 是所有数据
  $file = "./Uploads/20180605.xlsx";
        $file = iconv("utf-8", "gb2312", $file);   //转码
        if(empty($file) OR !file_exists($file)) {
            die('file not exists!');
        }
        vendor('PHPExcel.PHPExcel');
        $objRead = new \PHPExcel_Reader_Excel2007();   //建立reader对象
        if(!$objRead->canRead($file)){
            $objRead = new PHPExcel_Reader_Excel5();
            if(!$objRead->canRead($file)){
                die('No Excel!');
            }
        }
        $arr = array(
            'A' => 'goods_oe',
            'B' => 'goods_number',
            'C' => 'goods_name',
            'D' => 'content',
            'E' => 'source',
            'F' => 'category_name'
        );

        $obj = $objRead->load($file);  //建立excel对象
        $currentSheet = $obj->getSheet($sheet);   //获取指定的sheet表
        $allColumn = $currentSheet->getHighestColumn();   //取得最大的列号
        $allRow = $currentSheet->getHighestRow();   //获取总行数
        $i = 0;

      //方法一    $data 是所有数据

    for($j=3;$j<=$allRow;$j++){
            //从A列读取数据
            for($k='A';$k<=$allColumn;$k++){
                // 读取单元格
                $data[$j][]=$obj->getActiveSheet()->getCell("$k$j")->getValue();
            }
//            print_r($data[$j][0]);die;
        }

//方法二 $data2 每一行数据就是一个数组

    for ($currentRow = 2; $currentRow <= $allRow; $currentRow++) {
            $i++;
            /**从第A列开始输出*/
            for ($currentColumn = 'A'; $currentColumn <= $allColumn; $currentColumn++) {
                $val = $currentSheet->getCellByColumnAndRow(ord($currentColumn) - 65, $currentRow)->getValue();
                $data1[$currentColumn] = $val;
            }
            foreach ($arr as $key => $val) {
                $data2[$val] = $data1[$key];
            }
            //保存数据入库
            $this->Savedata($data2, $currentRow);
            echo "\n";
        }

}