# wx.lib.agw.xlsgrid.XLSText¶

This is a class which holds information about the cell content, in terms of actual cell value, font, text colour, alignment and formatting.

## Class Hierarchy¶

Inheritance diagram for class XLSText:

## Known Subclasses¶

wx.lib.agw.xlsgrid.XLSRichText

## Methods Summary¶

 __init__ Default class constructor. CombineAttr Combines the input attribute attr with the features of the XLSText class. CreateAlignment Creates a suitable wxPython alignment flag for the text starting from a CreateFont Creates a suitable wxPython font starting from an Excel font. CreateFormat This method tries to guess the best format to apply to the current text CreateTextColour Creates a suitable wxPython colour for the text starting from a xlrd Draw Actually draws the text value on a grid cell. FormatString This method tries to guess the best format to apply to the current text GetValue Returns the string representation of the cell text value. IsHyperLink Returns whether the cell text is representing a hyperlink. SetupHyperlink Sets up the cell text value in case it represents a hyperlink.

## Class API¶

class XLSText(object)

This is a class which holds information about the cell content, in terms of actual cell value, font, text colour, alignment and formatting.

### Methods¶

__init__(self, book, cell, xf_index, display_text=None, hyperlink=None, default_width=10)

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;

• 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).

CombineAttr(self, attr)

Combines the input attribute attr with the features of the XLSText class.

Parameters

attr – an instance of grid.GridCellAttr.

CreateAlignment(self, alignment, default_width)

Creates a suitable wxPython alignment flag for the text starting from a xlrd class representing this alignment.

Parameters
• alignment – an instance of xlrd.formatting.XFAlignment class;

• 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).

CreateFont(self, font)

Creates a suitable wxPython font starting from an Excel font.

Parameters

font – an instance of xlrd.formatting.Font class.

Note

There is currently no support for strikethrough fonts, although xlrd correctly reports this format. The issue is a bug in wxWidgets itself which doesn’t allow the creation of strikethrough fonts. See (http://trac.wxwidgets.org/ticket/9907).

CreateFormat(self, format, cell, datemode)

This method tries to guess the best format to apply to the current text value.

Parameters
• format – an instance of xlrd.formatting.Format class;

• cell – an instance of xlrd.sheet.Cell class;

• datemode – the datemode associated with this Excel workbook.

Note

This method is used only if Mark Hammonds’ pywin32 package is not available to try and format the cell text in an intelligent way.

Warning

The formatting applied by this method is severely limited; for instance, you won’t probably get the exact WYSIWYG between the Excel spreadsheet and XLSGrid.

CreateTextColour(self, text_colour)

Creates a suitable wxPython colour for the text starting from a xlrd tuple representing this colour.

Parameters

text_colour – a tuple representing the RGB components of the colour. If text_colour is None, use the default wx.SYS_COLOUR_WINDOWTEXT.

Draw(self, dc, rect)

Actually draws the text value on a grid cell.

Parameters

FormatString(self, value, isDate, format_str)

This method tries to guess the best format to apply to the current text value.

Parameters
• value – the actual raw cell text value;

• isDateTrue if this value represents a xlrd date object, False otherwise;

• format_str – the actual formatting string as extracted from Excel.

Note

This method is used only if Mark Hammonds’ pywin32 package is not available to try and format the cell text in an intelligent way.

Warning

The formatting applied by this method is severely limited; for instance, you won’t probably get the exact WYSIWYG between the Excel spreadsheet and XLSGrid.

GetValue(self)

Returns the string representation of the cell text value.

Returns whether the cell text is representing a hyperlink.

Returns

True if the cell text represents a hyperlink, False otherwise.

Sets up the cell text value in case it represents a hyperlink.

Parameters

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).