HotXLS Docs
Home Contents Overview

TXLSLineFormat class

Unit: lxDraw
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

Style property
DashStyle property
ForeColor property
Visible property
Weight property