The XFAlignment Object

class XFAlignment

A collection of the alignment and similar attributes of an XF record. Items correspond to those in the Excel UI’s Format/Cells/Alignment tab.

• New in version 0.6.1

XFAligment.hor_align

see excelfileformat section 5.115.1 pg. 219

Const defined in xfconst (new in xlrd3):

Value	Name
0	HOR_ALIGN_GENERAL
1	HOR_ALIGN_LEFT
2	HOR_ALIGN_CENTRED
3	HOR_ALIGN_RIGHT
4	HOR_ALIGN_FILLED
5	HOR_ALIGN_JUSTIFIED
6	HOR_ALIGN_CENTRED_ACROSS_SELECTION
7	HOR_ALIGN_DISTRIBUTED

XFAlignmaent.indent_level

A number in range(15).

XFAlignmaent.rotation

see excelfileformat section 5.115.1 pg. 220

Const defined in xfconst (new in xlrd3):

Value	Description
0	ROTATION_NONE
255	ROTATION_STACKED
1-90	1 to 90 degrees counterclockwise
91-180	1 to 90 degrees clockwise

Note

file versions BIFF7 and earlier use the documented “orientation” attribute; this will be mapped (without loss) into “rotation”.

XFAligment.shrink_to_fit

1 = shrink font size to fit text into cell.

XFAligment.text_direction

0 = according to context; 1 = left-to-right; 2 = right-to-left

XFAligment.text_wrapped

1 = text is wrapped at right margin

XFAligment.vert_align

see excelfileformat section 5.115.1 pg. 220

Const defined in xfconst (new in xlrd3):

Value	Name
0	VERT_ALIGN_TOP
1	VERT_ALIGN_CENTRED
2	VERT_ALIGN_BOTTOM
3	VERT_ALIGN_JUSTIFIED
4	VERT_ALIGN_DISTRIBUTED