NativeExcel suite v3.x

TXLSLineFormat class

Unit: xlsdrw
Represents line formatting. For a shape with a border, this object contains formatting information for the shape's border.

Using the LineFormat Object

Use the Line property to return a LineFormat object.
The following example adds a green, dashed border to first shape on sheet one.
With WorkBook.Sheets[1] do begin
  if Shapes.Count > 0 then begin
    With Shapes[1] do begin
      Line.Style     := msoLineSingle;
      Line.DashStyle := msoLineDash;
      Line.Weight    := 2;
      Line.Visible   := true;
      Line.ForeColor.RGB := $00A000;
    end;
  end;
end;

Properties

Copyright © NikaSoft 2004-2013