大佬教程收集整理的这篇文章主要介绍了Laravel Excel:错误资源解释为文档但使用 MIME 传输,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
用于导出数据的 Laravel Excel 将下载仅包含 excel 表格中的标题的空数据! 我只想使用 excel 从我的搜索中导出过滤后的数据,但它会下载仅包含标题的空 excel 表格!!请谁能告诉我我的错误在哪里!
DealerExportSearch.php
class DealeRSSearchExport implements FromCollection,Withheadings,ShouldautoSize,WithEvents
{
use Exportable;
protected $name;
protected $email;
protected $mobile_no;
protected $city;
public function __construct( $name,$email,$mobile_no,$city)
{
$this->name = $name;
$this->email = $email;
$this->mobile_no = $mobile_no;
$this->city = $city;
}
//function SELEct data from database
public function collection()
{
return Dealer::SELEct()->where('name',$this->Name)
->where('email',$this->email)
->where('mobile_no',$this->mobile_no)
->where('city','=',$this->city) //i trIEd using the above and this also same result
->get();
}
public function registerEvents(): array
{
return [
AfterSheet::class => function (AfterSheet $event) {
$cellRange = 'A1:W1'; // All headers
$event->sheet->getDelegate()->getStyle($cellRangE)->getFont()->setSize(12);
},];
}
//function header in excel
public function headings(): array
{
return [
'No','name','email','mobile_no','shop_name','city','address'
];
}
}
我的控制器
public function index(request $request)
{
$method = $request->method();
if ($request->isMethod('get')) {
$name = $request->name;
$email = $request->email;
$city = $request->city;
$mobile_no = $request->mobile_no;
if ($request->has('search')) {
$dealers = Dealer::where('name','liKE','%'.$name.'%')
->where('email','%'.$email.'%')
->where('mobile_no','%'.$mobile_no.'%')
->where('city','%'.$city.'%')
->paginate(5);
return vIEw('dealer.index',compact('dealers'));
}
elseif ($request->has('exportSearchExcel')) {
return Excel::download(new DealeRSSearchExport($name ?? '',$email ?? '',$mobile_no ?? '',$city ?? ''),'DealeRSSearchExcel-reports.xLSX');
}
else{
$dealers = Dealer::orderBy('ID','DESC')->paginate(5);
return vIEw('dealer.index',compact('dealers'));
}
}
}
刀片
<form action="{{ route('dealer.index') }}" method="GET" enctype="multipart/form-data">
@csrf
<div class="form-group row">
<div class="col-sm-3">
<label for="name">name: </label>
<input class="form-control" name="name" value="{{ request()->input('name') }}" type="text" placeholder="The Dealer name">
</div>
.....................................................................
</div>
<div class="col-md-12 pt-3 text-right">
<button type="submit" name="search" class="btn btn-priMary"><i class="fa fa-fw fa-search"></i> Search</button>
<button type="submit" name="exportSearchExcel" class="btn btn-secondary text-light"><i class="fa fa-download"></i> Export Excel </button>
</div>
</div>
我的控制台中没有显示任何错误,每当我按下导出按钮时,它都会返回此错误并下载一个空的 xslx。
资源被解释为 document 但使用 MIME 类型 application/vnd.openxmlformats-officedocument.spreadsheetml.sheet 传输:“http://127.0.0.1:8000/dealer?_token=TTlpqFNn4hr5rwI1Jslt0d4mbtww2moO8i1WWjfn=&nameex=& /p>
我通过将我在 DealerExportSearch.php 中的查询更改为与我在 controller 中的查询相同的查询来解决此问题
DealerExportSearch.php
class DealersSearchExport implements FromCollection,WithHeadings,ShouldAutoSize,WithEvents,WithMapping
{
//the above codes not changed till the collection function
//function SELEct data from database
public function Collection()
{
return Dealer::where('name','LIKE','%'.$this->name.'%')
->where('email','%'.$this->email.'%')
->where('mobile_no','%'.$this->mobile_no.'%')
->where('city','%'.$this->city.'%')
->get();
}
public function map($row): array{
$fields = [
$row->id,$row->name,$row->gender,$row->date_of_birth,$row->email,$row->mobile_no,$row->shop_name,$row->city,$row->address,];
return $fields;
}
///below codes not changed .....
以上是大佬教程为你收集整理的Laravel Excel:错误资源解释为文档但使用 MIME 传输全部内容,希望文章能够帮你解决Laravel Excel:错误资源解释为文档但使用 MIME 传输所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。