AGW Logo

agw_title XLSRichText

This is a class which holds information about the cell content, in terms of actual cell value, font, text colour, alignment and formatting. In addition to what XLSText does, this class attempts to handle cells with rich text content.

hierarchy Inheritance Diagram

Inheritance diagram for: XLSRichText

Inheritance diagram of XLSRichText


supclasses Known Superclasses


method_summary Methods Summary

__init__Default class constructor.
BuildChunksSplits the cell content accordingly to their rich text format index.
DrawActually draws all the chunks of text on a grid cell, one by one.
MeasureConvenience method to measure the maximum height and total width of all the chunks of text composing our rich text string.

API Class API

class XLSRichText(XLSText)[source]

This is a class which holds information about the cell content, in terms of actual cell value, font, text colour, alignment and formatting. In addition to what XLSText does, this class attempts to handle cells with rich text content.



__init__(book, cell, xf_index, display_text=None, hyperlink=None, rich_text=None, default_width=10)[source]

Default class constructor.

Parameters:
  • book – an instance of the xlrd.Book class;
  • cell – an instance of xlrd.sheet.Cell class;
  • xf_index – an index into xlrd.Book.xf_list, which holds a reference to the xlrd.sheet.Cell class (the actual cell for xlrd);
  • display_text – if Mark Hammonds’ pywin32 package is available, this is the WYSIWYG cell content;
  • hyperlink – if this cell contains a hyperlink, it will be displayed accordingly;
  • rich_text – if this cell contains text in rich text format, XLSGrid will do its best to render the text as rich text;
  • 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).

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, this class will note be used by XLSGrid.

Warning

This class currently supports only single-line non-rotated text, and it discards properties like shrink-to-fit and wrapping.



BuildChunks(book, xf_index, rich_text)[source]

Splits the cell content accordingly to their rich text format index.

Parameters:
  • book – an instance of the xlrd.Book class;
  • xf_index – an index into xlrd.Book.xf_list, which holds a reference to the xlrd.sheet.Cell class (the actual cell for xlrd);
  • rich_text – if this cell contains text in rich text format, XLSGrid will do its best to render the text as rich text.


Draw(dc, rect)[source]

Actually draws all the chunks of text on a grid cell, one by one.

Parameters:
  • dc – an instance of wx.DC;
  • rect – an instance of wx.Rect, representing the cell rectangle.


Measure(dc)[source]

Convenience method to measure the maximum height and total width of all the chunks of text composing our rich text string.

Parameters:dc – an instance of wx.DC.

Tree

Table Of Contents

Previous topic

XLSRenderer

Next topic

XLSTable