paper-xlsxAPI referencepreserve.validation
openpyxl.preserve.validation
paper-xlsx 0.2.1 API reference
Read deterministic list data-validation values for a worksheet cell.
allowed_values
funcallowed_values(ws, cell)Return deterministic list-validation values covering cell.
None means no list validation covers the cell. A matching validation
whose vocabulary cannot be reported exactly raises a typed refusal.
Blank cells in a static source range are returned as None entries.
paramwsopenpyxl.worksheet.worksheet.WorksheetWorksheet containing the validated cell.
paramcellopenpyxl.cell.cell.Cell | strCell object or coordinate to inspect.
Returns
list | NoneAllowed values, or None when no list validation applies.