PHP电子表格下拉列表

Question

我想知道是否可以在phpspreadsheet中映射下拉列表，在下拉列表值形式范围单元格中显示，但是当用户选择显示第二列的值时。如:我选择下拉列表:AAA，当我选择:工作表显示111。因为我有A1 = AAA和B1 = 111

谢谢你的帮助。

Answer 1

$i = 3;
foreach($providersList as $provider) {
$sheet->setCellValue('A'.$i, $provider['id']);
$sheet->setCellValue('B'.$i, $provider['Name']);
$i++;
}
$sheet->getProtection()->setSheet(true);
$nbOfProvider = $sheet->getHighestRow('A');
for($j = 3; $j < $nbOfProvider; $j++) {
$dropdownlist = $worksheet->getCell('B'.$j)->getDataValidation();
$dropdownlist->setType(PhpOfficePhpSpreadsheetCellDataValidation::TYPE_LIST)    
->setAllowBlank(true)
->setShowDropDown(true)
->setPrompt('Choose the provider')
->setFormula1('='PROVIDERS'!$B$3:$B$'.$nbOfProvider);
$idProvider = $worksheet->getCell('C'. $j);
/*$idProvider->setValue('=VLOOKUP('PROVIDERS'!$B$3:$B$'.$nbOfProvider.',B');*/
}
$spreadsheet->getSheet(0);
$writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
$writer->save($file);
return $file;