How to call PHP property from string stored in a Variable

Question

I'm using maatwebsite/excel package and I would like to dynamically pass different file type as a second parameter.
See function here

Below is the variable:

$fileType = $request->input('fileType', 'xlsx');
$writerType = Excel::$fileType;

But I get the error:

Access to undeclared static property: Maatwebsite\Excel\Excel::$fileType

I try to use curly brackets but doesn't work:

Excel::${"fileType"};

How do I pass the variable? Thanks!

so you want the value of $fileType to be the property name? like `Excel::xlsx`? What's the value of `$fileType`? — Jeff, Oct 16 '18 at 10:34
Why don't you use the variable `$fileType` without `Excel::`? — Nico Haase, Oct 16 '18 at 10:43
@gogaz This is maatwebsite/excel package. https://laravel-excel.maatwebsite.nl/3.1/exports/export-formats.html — crownhsueh, Oct 17 '18 at 01:37

Ankita Mehta · Answer 1 · 2018-10-16T11:50:54.193

0

 return Excel::create('PatientList',function($excel) use ($variable){

            $excel->sheet('List',function($sheet) use ($variable){
                $sheet->fromArray($variable);
            });

        })->download($type);

use like this when you download the file.pass $type from your view.

edited Oct 16 '18 at 11:50

answered Oct 16 '18 at 10:39

Ankita Mehta

442
3
16

Andrew Zubets · Accepted Answer · 2018-10-16T13:52:50.450

0

You passed variable correctly. But your the problem is that Maatwebsite\Excel\Excel contains constant XLSX and it's not a property. Constants can be accessed staticly Excel::XLSX or dynamicly using constant function:

     $fileType = $request->input('fileType', 'xlsx');
     $writerType = constant('Excel::' . strtoupper($fileType));

edited Oct 16 '18 at 13:52

answered Oct 16 '18 at 13:43

Andrew Zubets

71
3

It will get `Couldn't find constant Excel::XLSX`. So I use full namespace: `$writerType = constant('\\Maatwebsite\\Excel\\Excel::' . strtoupper($fileType));` It works! Thanks. – crownhsueh Oct 17 '18 at 02:03

How to call PHP property from string stored in a Variable

2 Answers2