.. wxPython Phoenix documentation
This file was generated by Phoenix's sphinx generator and associated
tools, do not edit by hand.
Copyright: (c) 2011-2020 by Total Control Software
License: wxWindows License
.. include:: headings.inc
.. currentmodule:: wx.lib.agw.xlsgrid
.. highlight:: python
.. _wx.lib.agw.xlsgrid.XLSCell:
==========================================================================================================================================
|phoenix_title| **wx.lib.agw.xlsgrid.XLSCell**
==========================================================================================================================================
This is a class which holds information about a single cell in :class:`XLSGrid`.
It stores (via auxiliary classes), all details about cell background, text,
font, colours and borders.
|
|class_hierarchy| Class Hierarchy
=================================
.. raw:: html

Inheritance diagram for class
XLSCell:
|
|method_summary| Methods Summary
================================
================================================================================ ================================================================================
:meth:`~wx.lib.agw.xlsgrid.XLSCell.__init__` Default class constructor.
:meth:`~wx.lib.agw.xlsgrid.XLSCell.GetAttr` Returns the attribute to use for this specific cell.
:meth:`~wx.lib.agw.xlsgrid.XLSCell.GetComment` Returns the cell comment, if any.
:meth:`~wx.lib.agw.xlsgrid.XLSCell.GetValue` Returns the actual WYSIWYG representation of the cell value.
:meth:`~wx.lib.agw.xlsgrid.XLSCell.SetCellSize` Sets the size of the cell.
:meth:`~wx.lib.agw.xlsgrid.XLSCell.SetupCell` Actually sets up the :class:`XLSCell` class. This is an auxiliary method to
:meth:`~wx.lib.agw.xlsgrid.XLSCell.SetValue` Sets the actual WYSIWYG representation of the cell value.
================================================================================ ================================================================================
|
|api| Class API
===============
.. class:: XLSCell(object)
This is a class which holds information about a single cell in :class:`XLSGrid`.
It stores (via auxiliary classes), all details about cell background, text,
font, colours and borders.
.. method:: __init__(self, book, cell, xf_index, xls_text, xls_comment, hyperlink, rich_text, default_width, default_colour)
Default class constructor.
:param `book`: an instance of the `xlrd.Book` class;
:param `cell`: an instance of `xlrd.sheet.Cell` class;
:param `xf_index`: an index into `xlrd.Book.xf_list`, which holds a
reference to the `xlrd.sheet.Cell` class (the actual cell for `xlrd`);
:param `xls_text`: the actual WYSIWYG cell text, if available;
:param `xls_comment`: the cell comment (note), if any;
:param `hyperlink`: an instance of `xlrd.sheet.hyperlink`;
:param `rich_text`: if this cell contains text in rich text format, :class:`XLSGrid`
will do its best to render the text as rich text;
:param `default_width`: this is the default width of the text in 1/256
of the width of the zero character, using default Excel font (first FONT
record in the Excel file);
:param `default_colour`: the "magic" colour used by Excel to draw non-custom
border lines.
.. note:: If you are using version 0.7.1 or lower for `xlrd`, the *hyperlink*
parameter will always be ``None`` as this feature is available only in
`xlrd` 0.7.2 (SVN).
.. note:: If you are using version 0.7.1 or lower for `xlrd`, the `rich_text`
parameter will always be ``None`` as this feature is available only in
`xlrd` 0.7.2 (SVN).
.. note:: if Mark Hammonds' `pywin32` package is not available, the `xls_text`
parameter will almost surely not be the WYSIWYG representation of the cell
text.
.. note:: If Mark Hammonds' `pywin32` package is not available, the `xls_comment`
parameter will always be ``None``.
.. method:: GetAttr(self)
Returns the attribute to use for this specific cell.
:returns: an instance of :class:`grid.GridCellAttr`.
.. method:: GetComment(self)
Returns the cell comment, if any.
:returns: an instance of :class:`XLSComment`.
.. note:: If Mark Hammonds' `pywin32` package is not available, this method
always returns ``None``.
.. method:: GetValue(self)
Returns the actual WYSIWYG representation of the cell value.
.. method:: SetCellSize(self, rows, cols)
Sets the size of the cell.
Specifying a value of more than 1 in `rows` or `cols` will make the cell
at (`row`, `col`) span the block of the specified size, covering the other
cells which would be normally shown in it. Passing 1 for both arguments
resets the cell to normal appearance.
:param `rows`: number of rows to be occupied by this cell, must be >= 1;
:param `cols`: number of columns to be occupied by this cell, must be >= 1.
.. method:: SetupCell(self, book, cell, xf_index, xls_text, xls_comment, hyperlink, rich_text, default_width, default_colour)
Actually sets up the :class:`XLSCell` class. This is an auxiliary method to
avoid cluttering the :meth:`~xlsgrid.XLSCell.__init__` method.
:param `book`: an instance of the `xlrd.Book` class;
:param `cell`: an instance of `xlrd.sheet.Cell` class;
:param `xf_index`: an index into `xlrd.Book.xf_list`, which holds a
reference to the `xlrd.sheet.Cell` class (the actual cell for `xlrd`);
:param `xls_text`: the actual WYSIWYG cell text, if available;
:param `xls_comment`: the cell comment (note), if any;
:param `hyperlink`: an instance of `xlrd.sheet.hyperlink`;
:param `rich_text`: if this cell contains text in rich text format, :class:`XLSGrid`
will do its best to render the text as rich text;
:param `default_width`: this is the default width of the text in 1/256
of the width of the zero character, using default Excel font (first FONT
record in the Excel file);
:param `default_colour`: the "magic" colour used by Excel to draw non-custom
border lines.
.. note:: If you are using version 0.7.1 or lower for `xlrd`, the *hyperlink*
parameter will always be ``None`` as this feature is available only in
`xlrd` 0.7.2 (SVN).
.. note:: If you are using version 0.7.1 or lower for `xlrd`, the `rich_text`
parameter will always be ``None`` as this feature is available only in
`xlrd` 0.7.2 (SVN).
.. note:: if Mark Hammonds' `pywin32` package is not available, the `xls_text`
parameter will almost surely not be the WYSIWYG representation of the cell
text.
.. note:: If Mark Hammonds' `pywin32` package is not available, the `xls_comment`
parameter will always be ``None``.
.. method:: SetValue(self, value)
Sets the actual WYSIWYG representation of the cell value.
:param `value`: the current text value to insert in the cell.
.. note:: This method is currently unused as everything is handled inside the :class:`XLSText` class.
.. seealso:: :meth:`~xlsgrid.XLSCell.GetValue`