The XFBorder Object

class XFBorder

A collection of the border-related attributes of an XF record. Items correspond to those in the Excel UI’s Format/Cells/Border tab.

An explanations of “colour index” is given in the Formatting section at the start of this document.

There are five line style attributes; possible values and the associated meanings are:

_images/border.png

The line styles 8 to 13 appear in BIFF8 files (Excel 97 and later) only. For pictures of the line styles, refer to OOo docs s3.10 (p22) “Line Styles for Cell Borders (BIFF3-BIFF8)”.

  • New in version 0.6.1
XFBorder.bottom_colour_index

The colour index for the cell’s bottom line

XFBorder.bottom_line_style

The line style for the cell’s bottom line

XFBorder.diag_colour_index

The colour index for the cell’s diagonal lines, if any

XFBorder.diag_down

1 = draw a diagonal from top left to bottom right

XFBorder.diag_line_style

The line style for the cell’s diagonal lines, if any

XFBorder.diag_up

1 = draw a diagonal from bottom left to top right

XFBorder.left_colour_index

The colour index for the cell’s left line

XFBorder.left_line_style

The line style for the cell’s left line

XFBorder.right_colour_index

The colour index for the cell’s right line

XFBorder.right_line_style

The line style for the cell’s right line

XFBorder.top_colour_index

The colour index for the cell’s top line

XFBorder.top_line_style

The line style for the cell’s top line

Previous topic

The XFBackground Object

Next topic

The XFProtection Object

This Page