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* .. attribute:: XFAligment.hor_align see excelfileformat section 5.115.1 pg. 219 Const defined in :mod:`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 ======= ====================================== .. attribute:: XFAlignmaent.indent_level A number in range(15). .. attribute:: XFAlignmaent.rotation see excelfileformat section 5.115.1 pg. 220 Const defined in :mod:`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". .. attribute:: XFAligment.shrink_to_fit 1 = shrink font size to fit text into cell. .. attribute:: XFAligment.text_direction 0 = according to context; 1 = left-to-right; 2 = right-to-left .. attribute:: XFAligment.text_wrapped 1 = text is wrapped at right margin .. attribute:: XFAligment.vert_align see excelfileformat section 5.115.1 pg. 220 Const defined in :mod:`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 ======= =================================