Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

sayeedroshan's avatar

How to Create an dropdown in a particular excel cell in blade file

HOW TO CREATE A DROPDOWN IN CELL

THIS IS MY CONTROLLER FUNCTION

public function demo(AuthRequest $request) { $SelectModel= New SelectModel; $eventID=$request->get('eventID'); if(trim($eventID) =='') $SupplierList=$SelectModel->Suppliers(); else $SupplierList=$SelectModel->Suppliers($eventID); Excel::create('Supplier Export', function($excel) use($SupplierList) { $excel->sheet('Supplier List', function($sheet) use($SupplierList) { $sheet->cells('A1:G1',function($cells) { $cells->setBackground('#000000'); $cells->setFontColor('#fff'); }); $sheet->freezeFirstRowAndColumn(); $sheet->setShowDropDown(true); $sheet->loadView('excel.demo',array('supplierxport'=>$SupplierList)); }); })->export('xlsx'); }

AND MY BLADE FILE IS

Supplier Company Supplier Name Country EventName Link Categories Order Supplier Company Supplier Name Country EventName Link Categories Order

when i am generating an excel sheet i need a dropdown list type in place of Event name, can any one help me how to write blade file code in order to get the list of event in "EventName" cell

0 likes
0 replies

Please or to participate in this conversation.