利用PhpOffice PhpSpreadsheet导出excel ,laravel admin grid ＜a＞标签禁止跳转

  $grid->tools(function ($tools) use($search){
   
       if(Admin::user()->isAdministrator()){
   
          $tools->append('.$search.'" target="_blank" class="btn btn-sm btn-info" title="导出EXCEL">
                    导出EXCEL
              ');

      }
  });
  //target="_blank" 这句很重要
1
2
3
4
5
6
7
8
9
10
11

导出excel

  public function exportToExcel(Request $request)
    {
   
        $search = $request->search;
        $styleArray = [
            'alignment' => [
                'horizontal' => Alignment::HORIZONTAL_CENTER,
                'vertical' => Alignment::VERTICAL_CENTER
            ],
        ];
        $styleArray1 = [
            'borders' => [
                'allBorders' => [
                    'borderStyle' =>  Border::BORDER_THIN //细边框
                ]
            ]
        ];
        $user = Admin::user();
        $eq_com_str = $user->eq_com_id;
        $eq_company = explode(',',$eq_com_str);
        $res = Equipment::with(['base','company','depart'])
            ->withCount('repair')
            ->whereIn('factory_id',$eq_company);
        if(isset($search)){
   
            $arr = explode(',',$search);
            if(count($arr)==1){
   
                $arr = explode('，',$search);
            }
            array_map('trim',$arr);
            foreach ($arr as $k =>$v){
   
                if($v=='缺失'){
   
                    $res = $res->where('type',0);
                }else{
   
                    $res = $res->where(function ($query) use($v){
   
                        $query->whereHas('base',function ($q) use ($v) {
   
                            $q->where('name', 'like
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42