cell.Cell
Describes cell associated properties.
Usage
cell.Cell()Properties of interest include style, type, value, and address.
Attributes
| Name | Description |
|---|---|
| cached_value | Last calculated value from the file, if present. |
| col_idx | The numerical index of the column |
| column | Column number of this cell (1-based) |
| comment | Returns the comment associated with this cell |
| coordinate | This cell’s coordinate (ex. ‘A5’) |
| hyperlink | Return the hyperlink target or an empty string |
| internal_value | Always returns the value for excel. |
| is_date | True if the value is formatted as a date |
| row | Row number of this cell (1-based) |
| value | Get or set the value held in the cell. |
cached_value
Last calculated value from the file, if present.
cached_value
Never computed by fastpyxl. None means no cache was loaded / kept, which is distinct from a cached numeric 0 or empty string.
Stored on the parent worksheet side map so default-mode cells do not pay a per-instance pointer for an unused field. Only the live sheet cell at a coordinate may read or write that map entry.
col_idx
The numerical index of the column
col_idx
column
Column number of this cell (1-based)
column=column
comment
Returns the comment associated with this cell
comment
coordinate
This cell’s coordinate (ex. ‘A5’)
coordinate
hyperlink
Return the hyperlink target or an empty string
hyperlink
internal_value
Always returns the value for excel.
internal_value
is_date
True if the value is formatted as a date
is_date
row
Row number of this cell (1-based)
row=row
value
Get or set the value held in the cell.
value
Methods
| Name | Description |
|---|---|
| check_error() | Tries to convert Error” else N/A |
| check_string() | Check string coding, length, and line break character |
| offset() | Returns a cell location relative to this cell. |
check_error()
Tries to convert Error” else N/A
Usage
check_error(value)check_string()
Check string coding, length, and line break character
Usage
check_string(value)offset()
Returns a cell location relative to this cell.
Usage
offset(row=0, column=0)Parameters
row: int = 0-
number of rows to offset
column: int = 0- number of columns to offset