$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