PhpSpreadsheet做导入功能演示_米醋屋个人技术博客

PhpSpreadsheet做导入功能演示，之前的一版有一点小问题，后面优化了一下，这里贴出来分享！主要在读取文件的时候可能会出错，推荐大家使用下文中的形式进行读取。

public function Index()
    {
        $path = "./upload/excel/wc1.xlsx";
        $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader('Xlsx');
        $reader->setReadDataOnly(TRUE);
        $spreadsheet = $reader->load($path); //载入excel表格
        $worksheet = $spreadsheet->getActiveSheet();
        $highestRow = $worksheet->getHighestRow(); // 总行数
        $highestColumn = $worksheet->getHighestColumn(); // 总列数
        $highestColumnIndex = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::columnIndexFromString($highestColumn); // e.g. 5

ob_end_clean(); //清除缓冲区,避免乱码
        $data = $worksheet->toArray();  // 转为数组

$insertData = [];
        foreach ($data as $k=> $item) {
            if($k >= 1){
                $temp['code'] = $item[1];
                $temp['name'] = $item[2];
                $temp['short_name'] = $item[3];
                $temp['department'] = $item[4];
                $temp['area'] = $item[5];
                $temp['region'] = $item[6];
                $temp['leader'] = $item[7];
                $temp['shop_email'] = $item[9];
                if($item[10] == "否"){
                    $temp['shop_status'] = 0;
                }else{
                    $temp['shop_status'] = 1;
                }

$temp['network'] = 1; //0-e网,1-王朝网;
                $insertData[] = $temp;
            }
        }

$res = Db::name("shop")->insertAll($insertData);

if ($res) {
            return ajax_return_adv('导入成功');
        } else {
            return ajax_return_adv_error('操作失败', '', '', '操作失败');
        }
    }

注:原创不易,转载请注明出处( http://www.micuu.com/new/2055.html )，本站所有资源来源于网络收集，如有侵权请联系QQ245557979进行清除。