Cell

Describes cell associated properties.

Properties of interest include style, type, value, and address.

Cell(worksheet, row=None, column=None, value=None, style_array=None)

Attributes

`alignment`

attributealignment

= StyleDescriptor('_alignments', 'alignmentId')

`base_date`

attributebase_date

`border`

attributeborder

= StyleDescriptor('_borders', 'borderId')

`col_idx`

attributecol_idx

The numerical index of the column

`column`

attributecolumn

= column

Column number of this cell (1-based)

`column_letter`

attributecolumn_letter

`comment`

attributecomment

Returns the comment associated with this cell

:type: openpyxl.comments.Comment

`coordinate`

attributecoordinate

This cell's coordinate (ex. 'A5')

`data_type`

attributedata_type

`encoding`

attributeencoding

`fill`

attributefill

= StyleDescriptor('_fills', 'fillId')

`font`

attributefont

= StyleDescriptor('_fonts', 'fontId')

`has_style`

attributehas_style

`hyperlink`

attributehyperlink

Return the hyperlink target or an empty string

`internal_value`

attributeinternal_value

Always returns the value for excel.

`is_date`

attributeis_date

True if the value is formatted as a date

:type: bool

`number_format`

attributenumber_format

= NumberFormatDescriptor()

`parent`

attributeparent

= sheet

`pivotButton`

attributepivotButton

= StyleArrayDescriptor('pivotButton')

`protection`

attributeprotection

= StyleDescriptor('_protections', 'protectionId')

`quotePrefix`

attributequotePrefix

= StyleArrayDescriptor('quotePrefix')

`row`

attributerow

= row

Row number of this cell (1-based)

`style`

attributestyle

= NamedStyleDescriptor()

`style_id`

attributestyle_id

`value`

attributevalue

Get or set the value held in the cell.

Functions

`check_error`

funccheck_error(value)

Tries to convert Error" else N/A

paramvalue

`check_string`

funccheck_string(value)

Check string coding, length, and line break character

paramvalue

`offset`

funcoffset(row=0, column=0)

Returns a cell location relative to this cell.

paramrowint

= 0

number of rows to offset

paramcolumnint

= 0

number of columns to offset

On this page