it is possible to do PERCENTILE.EXC in laravel? If yes how?

Asked Oct 01 '19 at 09:23

Active Oct 01 '19 at 09:23

Viewed 97 times

I am creating a program that generate report in excel. And some of my problem is when generating excel I need a formula like Percentile

I found a link of T-SQL that generate percentile but I really don't understand it.

What I need is how can I do in query in laravel that do percentile. can you give me some example or link.

I am currently using laravel 5.2 and phpoffice/phpexcel Link of phpoffice/phpexcel: https://packagist.org/packages/phpoffice/phpexcel

asked Oct 01 '19 at 09:23

Mathew Magante

https://stackoverflow.com/questions/21302389/how-can-insert-formula-in-excel-sheet-using-phpexcel – Vijay Sankhat Oct 01 '19 at 09:47
@VijaySankhat thank you for the link Sir but I already try using formula my problem on it is, its not automatic calculating. So I think I should compute it using query. – Mathew Magante Oct 01 '19 at 10:11
https://stackoverflow.com/questions/27550027/php-excel-formula-not-running-in-saved-spreadsheet – Vijay Sankhat Oct 01 '19 at 10:15
Need to enable it like this `$writer->setPreCalculateFormulas(true);` – Vijay Sankhat Oct 01 '19 at 10:16
Have you tried previous comment code? – Vijay Sankhat Oct 01 '19 at 10:47

0 Answers0