Adds a list data-validation rule to the specified classic XLS worksheet range
语法
function AddListValidation(ARange, AItems: WideString): Integer;
| ARange |
WideString. A cell or A1-style range that receives the validation rule |
| AItems |
WideString。逗号分隔的内联列表、带引号的列表公式，或工作表范围引用公式 |
备注
The method writes BIFF8 DVAL and DV records for Excel 97-2003 workbooks. Inline lists such as Yes,No,Maybe 会自动包装为 Excel 列表公式。需要直接控制源表达式时，请传入带引号的公式或包含工作表引用的公式
示例
This example adds a dropdown list to cells A1 through A10
Workbook := TXLSWorkbook.Create;
try
Sheet := Workbook.Sheets[1];
Sheet.AddListValidation('A1:A10', 'Yes,No,Maybe');
Workbook.SaveAs('validated.xls', xlExcel97);
finally
Workbook.Free;
end;
See Also