vendredi 24 novembre 2017

LaravelExcel: Evaluate Calculation when export to CSV

I am using Laravel Excel: http://ift.tt/1n2QXpH for Laravel 5+

I try to convert an XLSX file to a CSV file. This is working fine, except that in the resulting CSV file the calculations are not evaluated, and are returned as "plain text" (for example: "=IF(A1="YES";TRUE;FALSE)" )

This is how I try to do it now, but apparently this is not working:

   $file = $request->file('file');            
   $result = Excel::load($file, function($file) {})->download("csv"); 

is there another method that allows me to export the file to CSV while evaluating the cells, or do I need to create my own loops?



from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2A4o7Yg
via IFTTT

Aucun commentaire:

Enregistrer un commentaire