In my case, i have problem like this
Sample table and data :
// Table Account Id | Name | 1 | Kiara | 2 | Steve |
My currently code is :
<?php namespace AppExports; use MaatwebsiteExcelConcernsFromCollection; use AppModelsAccount; class ExportTable implements FromCollection { public function collection() { return Account::all(); } }
What i had now in excel :
1 | Kiara | 2 | Steve |
I want show the headers value as dynamic as table, without more effort like this
public function headings(): array { return [ "Id", "Name" ]; }
Is it posible?
Advertisement
Answer
add your model,
public function getTableColumns() { return $this->getConnection()->getSchemaBuilder()->getColumnListing($this->getTable()); }
and …
public function headings(): array { $model = new Model(); $columns = $model->getTableColumns(); return $columns; }
try this cok.