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 Orderwhen 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
Please or to participate in this conversation.