如何创建多选下拉phpspreadsheet

composer require phpoffice/phpspreadsheet

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

$spreadsheet = new Spreadsheet();

$worksheet = $spreadsheet->getActiveSheet();

// 设置多选下拉列表的选项
$options = ['Option 1', 'Option 2', 'Option 3'];
$validation = $worksheet->getCell('A1')->getDataValidation();
$validation->setType(\PhpOffice\PhpSpreadsheet\Cell\DataValidation::TYPE_LIST);
$validation->setFormula1('"'.implode(',', $options).'"');
$validation->setAllowBlank(true);
$validation->setShowDropDown(true);

$writer = new Xlsx($spreadsheet);
$writer->save('path/to/save/file.xlsx');