php完美处理Spreadsheet在写入中特殊符号导致

发布时间 2023-12-04 11:12:30作者: 徐行吟雨
$spread  = new Spreadsheet();
        $sheet = $spread->getActiveSheet();
        $sheet->getDefaultColumnDimension()->setWidth(16);
        $title1 = [
            'A2'=>'=^・^=荣',
            'B2'=>'+8613207刘zw',
            'C2'=>'-86132072刘zw',
        ];
        foreach($title1 as $key=>$title){
            //设置单元格格式为文本
            $sheet->getStyle($key)->getNumberFormat()->setFormatCode(NumberFormat::FORMAT_TEXT);
            //设置单元格格式为显示为文本
            $sheet->setCellValueExplicit($key,$title,DataType::TYPE_STRING);
            //$sheet->setCellValue($key,$title); //默认的会将 = + - 等识别为公式导致错误
        }
        $writer = IOFactory::createWriter($spread,'Xlsx');
        $writer->save('testTran.xlsx');            

以上代码处理报错:  Worksheet!B6944 -> Formula Error: Unexpected operator