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.