mardi 7 juillet 2020

remove leading single quote in excel laravel

When I export excel file all value columns having single quote before the value. it was always happening with number formatted values. I tried to escape the single quote. but it was not working. my result column is '3,776. please help me to resolve this error. I used maatwebsite/excel package

json element in controller

'lst_yr_cur_mnth_ach_qty'=>number_format($lastYearThisMonthProduct?$lastYearThisMonthProduct['qty']:0), 

excel generate blade column is

<td>

</td>


via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire