CellValueHandler
General
CellValueHandler és un enum a Aspose.Cells per Python.
Mantenir les operacions d’importació i exportació de valors en cèl·lula segons la especificació ECMA-376.
Valors
| Value | Description |
|---|---|
TYPE_SHARED_STRING | Represents the ’s’ type for shared string cells |
TYPE_INLINE_STRING | Represents the ‘str’ type for inline string cells |
TYPE_NUMBER | Represents the ’n’ type for numeric cells |
TYPE_BOOLEAN | Represents the ‘b’ type for boolean cells |
TYPE_ERROR | Represents the ’e’ type for error cells |
ERROR_NULL | Represents the ‘#NULL!’ error value |
ERROR_DIV_0 | Represents the ‘#DIV/0!’ error value |
ERROR_VALUE | Represents the ‘#VALUE!’ error value |
ERROR_REF | Represents the ‘#REF!’ error value |
ERROR_NAME | Represents the ‘#NAME?’ error value |
ERROR_NUM | Represents the ‘#NUM!’ error value |
ERROR_NA | Represents the ‘#N/A’ error value |
VALID_ERRORS | Represents the set of all defined ECMA-376 error strings |
Mètodes
| Signature | Description |
|---|---|
get_cell_type(value) | Determines the ECMA-376 cell type attribute for a given value. |
format_value_for_xml(value, cell_type) | Formats a cell value for XML output according to ECMA-376 specification. |
parse_value_from_xml(value_str, cell_type, shared_strings) | Parses a cell value from XML according to ECMA-376 specification. |
excel_serial_to_datetime(serial_date) | Converts an Excel serial date number to a datetime object. |
is_error_value(value) | Checks if a value is a valid ECMA-376 error value. |
get_error_type(value) | Returns the error type name for a given error value. |
