php – Laravel excel库(Maatwebsite):如何在导出中创建一个下
发布时间:2020-12-14 19:49:54 所属栏目:大数据 来源:网络整理
导读:我正在创建一个应该包含下拉列表的excel模板.我看到它可能与phpexcel库( PHPExcel Multiple Dropdown list that dependent). 我想知道是否可以使用 maatwebsite提供的laravel-excel库. 我需要下拉式功能,NamedRange,datavalidation,setFormula等功能的语法 p
我正在创建一个应该包含下拉列表的excel模板.我看到它可能与phpexcel库(
PHPExcel Multiple Dropdown list that dependent).
我想知道是否可以使用 maatwebsite提供的laravel-excel库. 我需要下拉式功能,NamedRange,datavalidation,setFormula等功能的语法 public function index() { Excel::create('file',function($excel) { require_once("/apppath//vendor/phpoffice/phpexcel/Classes/PHPExcel/NamedRange.php"); require_once("/apppath/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DataValidation.php"); $excel->sheet('New sheet',function($sheet) { $sheet->SetCellValue("A1","UK"); $sheet->SetCellValue("A2","USA"); $sheet->_parent->addNamedRange( new PHPExcel_NamedRange( 'countries',$sheet,'A1:A2' ) ); $sheet->SetCellValue("B1","London"); $sheet->SetCellValue("B2","Birmingham"); $sheet->SetCellValue("B3","Leeds"); $sheet->_parent->addNamedRange( new PHPExcel_NamedRange( 'UK','B1:B3' ) ); $sheet->SetCellValue("C1","Atlanta"); $sheet->SetCellValue("C2","New York"); $sheet->SetCellValue("C3","Los Angeles"); $sheet->_parent->addNamedRange( new PHPExcel_NamedRange( 'USA','C1:C3' ) ); $objValidation = $sheet->getCell('D1')->getDataValidation(); $objValidation->setType(PHPExcel_Cell_DataValidation::TYPE_LIST); $objValidation->setErrorStyle(PHPExcel_Cell_DataValidation::STYLE_INFORMATION); $objValidation->setAllowBlank(false); $objValidation->setShowInputMessage(true); $objValidation->setShowErrorMessage(true); $objValidation->setShowDropDown(true); $objValidation->setErrorTitle('Input error'); $objValidation->setError('Value is not in list.'); $objValidation->setPromptTitle('Pick from list'); $objValidation->setPrompt('Please pick a value from the drop-down list.'); $objValidation->setFormula1('countries'); //note this! }); })->download("xlsx"); return view('home'); } (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |