formula in phpOffice

25 Views Asked by At

I use Symfony 4.4 and phpspreadsheet 1.28.0, how to enter a formula like $excel->setCellValue("D6", "=NB.JOURS.OUVRES(B4;B5)");

WHen I use this formula the page don't load

Thanks for your help

<?php

namespace App\Services\Factory;

.....
use PhpOffice\PhpSpreadsheet\Exception;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Style\Alignment;
use PhpOffice\PhpSpreadsheet\Style\Border;
use PhpOffice\PhpSpreadsheet\Style\Color;
use PhpOffice\PhpSpreadsheet\Style\Fill;
use PhpOffice\PhpSpreadsheet\Style\NumberFormat;
use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
use PhpOffice\PhpSpreadsheet\Writer\Xls;

class ExcelPointageFactory
{
    .......

    /**
     * @return void
     * @throws Exception
     */
    private function fillHeaders(): void
    {
        $excel = $this->sheet;
        $excel->setCellValue("D6", "=NB.JOURS.OUVRES(B4;B5)");
    }
0

There are 0 best solutions below