Skip to content
Advertisement

Tag: phpspreadsheet

Phpspreadsheet formula not accepted

With phpspreadsheet, i can’t put a formula in a cell. I get an error : L43 -> Formula Error: An unexpected error occurred While when i put this formula in an excel file directly it’s working nice. My formula is : “=IF(SUM(J2:J41)<>SUM(L2:L41);”1″;”2″)”. There is my code : $sheet->setCellValue($cell, $formula); I also test with $sheet->setCellValueExplicit($cell, $formula, DataType::TYPE_FORMULA); But i doesn’t work

Read XLS in PHP using PhpSpreadsheet

I have a requirements to read XLS files (not xlsx) using PhpSpreadsheet and I having trouble. I tried this (as the documentation say but…) but didn’t work (it worked with a xlsx file, but no with a xls file!) Then I tried to open file differently: but also doesn’t work… I really need to solve this… please help! PS: I’ve

Advertisement