因此,我正在使用此命令导出我的单个产品详细信息。在导出时,我也要导出标题。那么我如何导出数据和数据头呢?
composer require maatwebsite/excel
在产品中(index.blade.php)
@foreach($products as $product)
<tr>{{$product->name}}</tr>
<tr>{{$product->price}}</tr>
<tr><a href="{{route('prodcutExport',$product->id)}}">Export Product Detail</></tr>
@endforeach
在ProductController.php中
public function export()
{
$products = Product::where('id',1)->get();
return Excel::download(new ProductExport($products), 'patient.xlsx');
}
在ProductExport.php中
namespace App\Exports;
use App\Product;
use Maatwebsite\Excel\Concerns\FromCollection;
class ProductExport implements FromCollection
{
public function __construct($products)
{
$this->products = $products;
}
public function collection()
{
return $this->products;
}
public function headings() //How can i export this
{
return [
'Name','Price','Colour','Created At'
]
}
}
您需要添加WithHeadings
到您的班级:
namespace App\Exports;
use App\Product;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
class ProductExport implements FromQuery, WithHeadings
{
public function __construct($products)
{
$this->products = $products;
}
public function collection()
{
return $this->products;
}
public function headings(): array
{
return [
'Name','Price','Colour','Created At'
]
}
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句