You know, if you input 12 digits or more number in Excel, Excel automatically formats it to scientific notation like 1,23457E+11, if in Excel we can change format become text manually, but what if we have to export Excel from the web application?
In this post i will tell you how to convert integer to string, whether it's 12 digits or more with maatwebsite/excel Laravel.
The method its really simple, you just override the PhpSpreadsheet's default value binder with implementing WithCustomValueBinder concern and use bindValue method like this
Thanks for reading this post, i hope this post can be useful, if you have question or feedback, you can send message in Contact or leave a comment.

0 Comments