phpExecl导出execl报错

最近用PhpSpreadsheet导出数据的时候发现,包含某一数据的时候总是报错,报错信息如下:

PhpOffice\PhpSpreadsheet\Calculation\Exception: 订单信息!F278 -> Uninitialized string offset: 1 in /vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Cell/Cell.php:270
Stack trace:
#0 vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx/Worksheet.php(1113): PhpOffice\PhpSpreadsheet\Cell\Cell->getCalculatedValue()
#1 vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx/Worksheet.php(1183): PhpOffice\PhpSpreadsheet\Writer\Xlsx\Worksheet->writeCellFormula(Object(PhpOffice\PhpSpreadsheet\Shared\XMLWriter), '==', Object(PhpOffice\PhpSpreadsheet\Cell\Cell))
#2 vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx/Worksheet.php(1040): PhpOffice\PhpSpreadsheet\Writer\Xlsx\Worksheet->writeCell(Object(PhpOffice\PhpSpreadsheet\Shared\XMLWriter), Object(PhpOffice\PhpSpreadsheet\Worksheet\Worksheet), 'F278', Array)
#3 vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx/Worksheet.php(67): PhpOffice\PhpSpreadsheet\Writer\Xlsx\Worksheet->writeSheetData(Object(PhpOffice\PhpSpreadsheet\Shared\XMLWriter), Object(PhpOffice\PhpSpreadsheet\Worksheet\Worksheet), Array)
#4 vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx.php(275): PhpOffice\PhpSpreadsheet\Writer\Xlsx\Worksheet->writeWorksheet(Object(PhpOffice\PhpSpreadsheet\Worksheet\Worksheet), Array, false)
#5 crmeb/services/SpreadsheetExcelService.php(277): PhpOffice\PhpSpreadsheet\Writer\Xlsx->save('/www/wwwroot/tj...')

看信息大概是F列278行数据有问题,我就上网查了查,看见有人也遇见了这个问题,说大致是数据中有以=号开头的字符了,可能是出发了execl的函数啥的,导致参数不足,导致的错,我也是用其他字符吧这个=号替换掉就号了,希望能帮助到也遇见问题的你。

You May Also Like