HotXLS Delphi Excel Read Write Library / Component Developers Guide loslab Inc.

TXLSFillFormat class

Unit: lxDraw
Represents fill formatting for a shape.

Using the FillFormat Object

Use the Fill property to return a FillFormat object.
The following example changes fill color for comment on cell B2.
Var Comment: TXLSComment;
begin
  ...
  With Workbook.Sheets[1] do begin
    Comment := Range['B2', 'B2'].Comment;
    if Assigned(Comment) then Comment.Shape.Fill.ForeColor.RGB := $E0E0FF;
  end;
  ...
end;

Properties

Methods

Copyright©2007-2019 loslab.com