Using the IF statement in PHPspreadsheet

Asked Sep 29 '20 at 17:47

Active Sep 29 '20 at 18:35

Viewed 589 times

I create an excel report in php using the phpspreadsheet library. But I ran into a problem: I need to use the "IF" operator in one column as in excel.

$spreadsheet->getActiveSheet()->setCellValue("O{$row_number}", "=IF(A{$row_number}>10;1;0)")

But when I open the document, I get an error that the document is damaged. Can you tell me how to implement this correctly?

edited Sep 29 '20 at 18:35

asked Sep 29 '20 at 17:47

MrJack0209

The problem is, I believe, in your unescaped quotation marks. – ΔO 'delta zero' Sep 29 '20 at 17:50
@Mech, This doesn't fit. In your case, the error appears even before the build – MrJack0209 Sep 29 '20 at 17:55
@ΔO'deltazero', This $spreadsheet->getActiveSheet()->setCellValue("N{$row_num}", "=J{$row_num}*G{$row_num}"); option works without problems. And that's exactly what IF doesn't want – MrJack0209 Sep 29 '20 at 17:57
Try with `... "=IF(A{$row_number}>10;1;0)"` – ΔO 'delta zero' Sep 29 '20 at 18:08
@ΔO'deltazero', still an error – MrJack0209 Sep 29 '20 at 18:15
inside if condition retrieve cell value using getcell method E.g. getCell('B8') – mudassir ahmed Sep 29 '20 at 19:57

Using the IF statement in PHPspreadsheet

0 Answers0