XLSGrid is a class based on wx.grid.Grid that can be used to faithfully reproduce the appearance of a Microsoft Excel spreadsheet (one worksheet per every instance of XLSGrid).
XLSGrid is a completely owner-drawn control, and it relies on the power of wx.grid.PyGridTableBase and wx.grid.PyGridCellRenderer to draw the cell content. For this reasons (and for some others, see the TODOs section), it will work efficiently only for relatively small Excel files.
__init__ | Default class constructor. |
DestroyTip | If a comment window or a tooltip over a hyperlink have been created, this |
FormatCell | Processes the creation of a single cell (an instance of XLSCell). |
GetDefaultFontData | Returns suitable width and height (in pixels) starting from Excel’s own |
InstallGridHint | Auxiliary method used to bind a wx.EVT_MOTION event to XLSGrid. |
PopulateGrid | This is the main method of this class, and it is used to actually create the cells, size the columns and rows, merging cells, etc... |
XLSGrid is a class based on wx.grid.Grid that can be used to faithfully reproduce the appearance of a Microsoft Excel spreadsheet (one worksheet per every instance of XLSGrid).
XLSGrid is a completely owner-drawn control, and it relies on the power of wx.grid.PyGridTableBase and wx.grid.PyGridCellRenderer to draw the cell content. For this reasons (and for some others, see the TODOs section), it will work efficiently only for relatively small Excel files.
Default class constructor.
Parameters: | parent – the grid parent window. Must not be None. |
---|
If a comment window or a tooltip over a hyperlink have been created, this method destroys them.
Processes the creation of a single cell (an instance of XLSCell).
Parameters: |
|
---|
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 display_texts and comments parameter will be two empty nested lists.
Returns suitable width and height (in pixels) starting from Excel’s own measurements (in characters, whatever that means).
Parameters: | book – an instance of the xlrd.Book class. |
---|---|
Returns: | a default_width and default_height in pixels, based on 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). |
This is the main method of this class, and it is used to actually create the cells, size the columns and rows, merging cells, etc...
Parameters: |
|
---|