Level 63
Perhaps this will help you ?
https://docs.laravel-excel.com/2.1/import/calculation.html
As you don't give any detail about how you import the file, it's difficult to help you with more precision.
Nov 22, 2022
4
Level 1
Laravel Excel - While importing excel with Formulae .
Laravel Excel - While importing excel with Formulae , the Formula is getting saved into the DB instead of value from the cell . How do we handle this situation ? Advices please.
Level 1
@vincent15000 Thank you. I am using the latest version Laravel Excel -3.1 though . But your idea let me where to search for the solution . I used below concerns to get the value of the formula while importing.
Maatwebsite\Excel\Concerns\WithCalculatedFormulas
2 likes
Level 1
This Is working .
2 likes
Level 1
I've run into that issue too. What worked for me was modifying the import logic to save only the cell value, not the formula. Check the Laravel Excel documentation for specifics. Also, you can take the course to master Excel. I hope that helps!
Please or to participate in this conversation.