如何超过.xls excel使用PHPExcel下拉单元格值长度

Question

I guys sorry for my English but i need help i am using PHPExcel Library for creation of xls file in PHP. i am making a drop down in this xls using this code

$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('"Item A,Item B,Item C,Item D,Item E,Item F"');

Its working fine but it only allow you to enter 250 characters only in this setFormula1 for this drop down cell if i enter more than 250 its not working. How can i enter values more than this 250 limit i have googled it but couldn't find any solution .....

Answer 1

Despite Anthony's comments and criticism of PHPExcel, this is not a PHPExcel limitation, it's an MS Excel limitation, and the way to overcome it is the same as it is in MS Excel itself.

You don't define the list of dropdown options directly in the formula; you define a range of cells containing the options (perhaps in a hidden worksheet), and then set the formula to an actual formula, e.g. ='DropdownSheet'!A1:A100