Laravel-excel: use any functions or calculate in excel?

[thearabbit]

I want to calculate or use any functions.
Please example for me.

[MaatwebsiteSupport]

By default the Excel import will calculate all your formulas in your excel file.

[thearabbit]

I want use it in excel export.

[MaatwebsiteSupport]

Just calculate with PHP before you insert the array?

Edit: our do something like:

$sheet->setCellValue('B5','=SUM(B2:B4)');

Can't try it right now, but using '=SUM(B2:B4)' in your array should work as well.

[thearabbit]

Thank, it work fine.

[scarrillo7]

In import excel, this fuction =DIA.LAB.INTL(FIN.MES(FECHA(C4;C3;1);-1);1) can't be resolve, throw

PHPExcel_Calculation_Exception in Cell.php line 293: Sheet1!D7 -> Formula Error: Unexpected ,

Any suggestions?

[PortgasDKiba]

Hi,

do you no, why the number 0 appear to be empty in my excel cell please ?

When I convert 0 to string it appears well but in text format.

[LockdownJacc]

hi i have this error with th range
-impuestos!A1 -> 3D Range references are not yet supported
this my code
$sheet->setCellvalue('A1','=SUM(Egresos!D2:Egresos!D27)');

[amirgee007]

how to do that in the 3.0 version?

$sheet->setCellValue('B5','=SUM(B2:B4)');

[ghost]

How can I import Excel files and calculate their formulas? I only get the formula string by importing the array. But I want to get the calculation result

[GlennM]

How can I import Excel files and calculate their formulas? I only get the formula string by importing the array. But I want to get the calculation result

You can use Maatwebsite\Excel\Concerns\WithCalculatedFormulas. See Import concerns.

Next time, please create a new ticket with the issue template filled. The issue template is required for us to be able to help you and is automatically available for you when opening a new issue, please do not remove the contents of the issue template.