美文网首页php知识总结
PhpSpreadsheet导入Csv中文无法读取

PhpSpreadsheet导入Csv中文无法读取

作者: 响呼雷 | 来源:发表于2022-02-21 09:25 被阅读0次
 public function departThirdInfo()
    {
        $file = $request->file('file');
        if (!$file){
            return error('请传入文件');
        }
        $realpath = $file->getRealPath();
        $extension = $file->getClientOriginalExtension();
        if ($extension == 'xlsx'){
            $reader = new Xlsx();
            $spreadsheet = $reader->load($realpath);
        }elseif ($extension == 'xls'){
            $reader = new Xls();
            $spreadsheet = $reader->load($realpath);
        }elseif ($extension == 'csv'){
            $reader = new Csv();
            $reader->setInputEncoding('GB2312'); //这一步必须,否则无法识别中文
            $spreadsheet = $reader->load($realpath);
        }
        $sheet = $spreadsheet->getActiveSheet();
        $row_count = $sheet->getHighestRow();
        for ($row = 2;$row <= $row_count+1;$row++){
            $third_police_units = $sheet->getCell('I'.$row)->getValue();
            //编写自己的逻辑
        }
        return success();
    }

导出操作请看PhpSpreadsheet导出Csv

相关文章

网友评论

    本文标题:PhpSpreadsheet导入Csv中文无法读取

    本文链接:https://www.haomeiwen.com/subject/zrbblrtx.html