xls_SET FORMAT PROPERTY

xls_SET FORMAT PROPERTY(reference;sheet;row;column;alignment;rotation;properties;borderlineTop;borderlineTopColor;borderlineLeft;borderlineLeftColor;borderlineRight;borderlineRightColor;borderlineBottom;borderlineBottomColor;pattern;patternColor;patternBackColor)

Parameter          Type             Description
reference          Longint      ->  Excel handle
sheet              Longint      ->  Sheet number
row                Longint      ->  Row number
column             Longint      ->  Column number
alignment          Longint      ->  Alignment
rotation           Longint      ->  Rotation
properties         Longint      ->  Properties
borderlineTop      Longint      ->  Borderline top
borderlineTopColor Longint      ->  Borderline top color
borderlineLeft     Longint      ->  Borderline left
borderlineLeftColor Longint     ->  Borderline left color
borderlineRight    Longint      ->  Borderline right
borderlineRightColor Longint    ->  Borderline right color
borderlineBottom   Longint      ->  Borderline bottom
borderlineBottomColor Longint   ->  Borderline bottom color
pattern            Longint      ->  Pattern
patternColor       Longint      ->  Pattern color
patternBackColor   Longint      ->  Pattern background color

Description

The command xls_SET FORMAT PROPERTY sets format properties of a cell.

alignment:

XLS H Align General
XLS H Align Left
XLS H Align Centered
XLS H Align Right
XLS H Align Filled
XLS H Align Justified
XLS H Align Sel Centered
XLS V Align Top
XLS V Align Centered
XLS V Align Bottom
XLS V Align Justified
XLS V Align Distributed
XLS Justify Last Line

You can combine horizontal and vertical values together

rotation: rotation angle in degrees

properties: text properties: constants: XLS Text Shrink, XLS Text Default, XLS Text Left to Right and XLS Text Right to Left

Borderlines: use the following constants:

XLS Border None
XLS Border Thin
XLS Border Medium
XLS Border Dashed
XLS Border Dotted
XLS Border Thick
XLS Border Double
XLS Border Hair
XLS Border Dashed
XLS Border Dash Dotted 1
XLS Border Dash Dotted 2
XLS Border Dash Dot Dotted 1
XLS Border Dash Dot Dotted 2
XLS Border Dash Dot Dotted 3
XLS Border Diagonal Down
XLS Border Diagonal Up

Borderline colors are indexed colors:

Patterns: use the following constants:

XLS Pattern Empty
XLS Pattern Solid
XLS Pattern 2
XLS Pattern 3
XLS Pattern 4
XLS Pattern 5
XLS Pattern 6
XLS Pattern 7
XLS Pattern 8
XLS Pattern 9
XLS Pattern 10
XLS Pattern 11
XLS Pattern 12
XLS Pattern 13
XLS Pattern 14
XLS Pattern 15
XLS Pattern 16
XLS Pattern 17
XLS Pattern 18